User Answers

The answer is:

To remove the Count measure put any other measure of the cube into the Measures section of the Pivot.

Hi Vivek!

Instead of &sql ... 

you can do:

write objExternalUser.%Id()

Hi Jimmy!

401 means that Authenticated user is not authorized to reach the server.

To prove the fact you could grant the application a %ALL role (the second tab) and this should work then.


Hi Stella!

This is complicated cause the base class of a cube should contain the most granular records for the subject area being analyzed. Speaking with family terms children can analyze their dads in a cube but not vice versa.  That means want to analyze Kids - build the cube for Kids.

There is one trick though which lets you analyze Kids from Dads assuming if your Dad is not very fruitful ;) I mean this will work if your Dad has less then 1,000 kids) 

Hi, Edward!

Here is the post about using Twilio

It’s about phone calls but Twilio provides services for SMS too.


Hi, Akio!

I bet there is no Caché Evaluation version on Mac, only Windows.

So if you want to run it on Mac - the virtual machine is your friend.

But I would suggest starting with new product InterSystems IRIS - you can get your sandbox here or on GCP.