I am having a dimension date. The hierarchy that i have built in it is as follows
I have built a hierarchy in the above manner. I would like to hide week and day levels in the hierarchy.
I cannot remove them from the hierarchy as i have other calculations based on them. I donot want the users to see these levels at all.
I have tried using Perspective. But the problem is when i try connecting from a third party application like Performance Point Server, i cannot use the perspective at all.
Can you please let me know how do you handle this in SSAS 2005?