Defining pivot variables
Is it possible to populate a pivot variable with a defined runtime variable from the settings page?
If so, what is the syntax?
Discussion (4)0
Log in or sign up to continue
https://community.intersystems.com/post/defining-pivot-variables
No.
Hi Trevor.
The other question is why do you need this? What is the end goal that you want to achieve?
Thank you,
Alexander.
I want to use a pivot variable with a run time value. E. G. Deepsee embedded in an app which knows what company a user has as the current company in the %session object. I want to use that as a default filter value
Runtime Variables are for that purpose.
And if you want to apply filter to any MDX query against a cube, you can specify a %OnGetFilterSpec callback.