KB47602: How to use Essbase substitution variables in multisource reports in MicroStrategy Developer

Essbase substitution variables are global placeholders for data whose values can be set for the entire Essbase server, an application or database. The following technical note explains how to create substitution variables in Essbase and how to use them in MDX reports:
 
KB47150: How to use Essbase substitution variables in MDX reports in MicroStrategy Desktop 9.x 
 
The below steps describe how to use Essbase substitution variables in report filters within an MDX multisource report. In this example, a substitution variable 'CurQtr' was created in Essbase so that it would be replaced with the value of the current quarter (which in this example is Qtr1) when it is passed to Essbase. Furthermore, the 'Year' attribute from Essbase has been mapped to the project attribute called 'Year':
 
 
 

• Create a standard report and add the relational Year attribute and an Essbase metric to the grid.
• Add a new Attribute Qualification on Year, that will determine if ID form of Year is equal to the substitution varilable 'CurQtr'.
• The syntax that has to be used for the substitution variable is shown below. Note that it is different from the syntax used in MDX reports, as detailed in the above technical note:
   
  

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
KB47602