when using a standard dimension/fact item as a report parameter, relevant context substitution variables will be visible to choose as the default value.
However, when a QIS is created based on an IAL, this is not possible. Here, the DIM_COMPANY dimensions was connected to the QIS from custom dimension connections oage.
Is this a framework limitation? Is there any setting or workaround to achieve this behavior?
We have created a QIS based on an IAL and connected DIM_COMPANY dimension from Custom Dimension Connections page. Context Substitution Variables were visible when a parameter was created from DIM_COMPANY.CODE.
Could you please check whether the Join Info and the Join Info Details are added accurately in the Custom Dimension Connections?
I created another IAL with the exact same query, and this time it worked. It might have been a one-off issue. However, this has happened frequently when setting CSVs as default values for BR parameters.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.