I have a formula stored in a variable that is giving me an accurate result of what I need to get when I check via static value based on a date filter I am putting in. However, when I pull it to my OLAP table it is showing me another value even though the same date filter is applied?
Example: 83000 is stored in <%=Var_1%>. When I apply the date filter is changes to 17000 (which is correct), but when I try to store the same value as a KPI in my OLAP table it still shows 83000
Hi @mohamed.ruzli.moham ,
This might not be it, but are you sure that the OLAP table has the option 'component is not filtered with selections' disabled? 😀
If not, for me I would need a bit more screenshots on the details to help you figure this one out. (for me variables as KPI's work as expected so we should be able to figure this one out.)
Hi @mohamed.ruzli.moham ,
This might not be it, but are you sure that the OLAP table has the option 'component is not filtered with selections' disabled? 😀
If not, for me I would need a bit more screenshots on the details to help you figure this one out. (for me variables as KPI's work as expected so we should be able to figure this one out.)
HI @joos.buijs
I was able to figure this one out
The option, 'component is not filtered with selections' was disabled
It seems like variables are difficult to change when you try to bring it in relation with other columns in an OLAP table due to it being static. This results in the column that I am storing the variable in to have repeated value of the samething
Instead I used a ''formula" and was able to achieve what I was looking for
Thanks
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
