Hi Gurus,
I am having a system which have a cube created from the FM model. I have a structure hierarchy in that and i want to impliment a security on the reports based on the user level. much appreciated for any help for this
my actual requirement is if a country lead is accessing the cube through report, he needs to see all the measures from that country. If one district manager is accessing the data through reports, he have to see only his measures and can drill down to the levels below him.
I have tried to impliment this usig the cusom views assinged to different user classes and customizing this with customization options. Is it possible this way
Any thoughts on this can be appreciated
Thanks in advance
Yes it is possible with Dimension Views in Dimension for the Managers and Custom Views in User classes. Just follow the instructions in Transformer Help.