Hide Master Data when its Nav. Attributes are Used in Q.
I have a situation which I wonder if any of you have solved it.
It's master data SSN, which contains attributes like Names, addresses of an individual, etc.
On queries where we do not want users to see SSN, but they can see names and addresses, I was able to do that by setting the property of SSN (which appears in the Navigational Block without me coding for it because its attributes were used) to not display, so that users <u>cannot</u> drill down on SSN.
However, there is still a little hole, that is you can still Right click at SSN in the Nav. Block and you will see a list of SSNs displayed. I do not know how to turn off that feature. I have tried the Microsoft Excel way to Protect the Worksheet, but then, the query cannot be refreshed in that case.
At the moment, we look for a cheap and easy way to get around this situation because we need to release these reports soon.
If any of you have solved this situation before or have any lights, I'd appreciate it to hear back from you.
If I undersstood, correctly, simple you need report on Address and names ( attributes of SSN) but you donot want to allow to display SSN in any case. So Make these attributes as navigational attributes and enable them at the cube , so that you can create report only with Address and names.
Anil Kumar Sharma .P