+1Hi,
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?
Best Regards,
Nisansala
Best answer by shwiclk
Hi
Given below are the steps that I followed. You can follow the same steps and check whether Context Substitution Variables are enabled.
Context Substitution Variables were visible in the list of Values Pane
Thank You
Hi
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?
Thank You
+1Hi
Thanks for the prompt response.
Yes, I have created the connection exact same way as you did.
But the issue persists. Is there any other setting that could affect this?
Best Regards,
Nisansala
Hi
Given below are the steps that I followed. You can follow the same steps and check whether Context Substitution Variables are enabled.
Context Substitution Variables were visible in the list of Values Pane
Thank You
+1Hi
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.
Thanks for your support on this.
Best Regards,
Nisansala
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
