I'm trying to solve the following task:
I have a simple regular dimension e.g. calendar, there are some attributes: datekey (20100117, ...), month (201001, ...), year (2010).
There is a single user definded hierarchy called calendar:
datekey --> month --> year, the attribute relationships are configured accordingly.
There is one role that has only access to month 201001 (dimension data security - allowed memberset) - please be aware that I want to use "Visual Totals" or something simialr.
Now I have to calculate a measure: ([calendar].[calendar]., [Measures].[sales]) / ([calendar].[calendar]., [Measures].[sales])
How do I have to configure the security or calculate the measure that the sum of all months is used and by selecting the year only the Visual Total is shown?
Any hint is appreciated ;-)
View Complete Post