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?
Is it possible to populate a pivot variable with a defined runtime variable from the settings page?
If so, what is the syntax?
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.