Is it possible to dynamically make an OLAP table component column visible / invisible based on a variable? Also, is it possible to make a KPI component visible/invisible based on the same variable?
The objective is to use one Analysis but limit certain data from being displayed for different end-customers? I know I can filter component by the customer name but I haven't found any mention in the ONLINE HELP on dynamic visibility of components.
Hi @david.stefa13,
For what you exactly want to do (making an OLAP column invisible or an KPI component invisible) is sadly not possible.
However, you can as you mentioned use variables, such as end-customer groups, to make CASE WHEN statements which can control what data to show based on the end-customer's wishes.
I would advise to make multiple analyses (you can copy paste sheets) and control per analysis level permissions which end-user may access it. This way you can tailer each analysis to each end-user without the risk that other end-users may see unwanted data. This way you also easily split data streams without having the risk of breaking your one analysis because of all the conditional rules you would write.
If you still prefer to use the CASE WHEN statements or FILTERS, Let me know.
Kind regards,
Sverre Klein
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
