I am creating a shell dimension to create a hierarchy. The idea is we want to know how much revenue we make from new accounts. So I have created an account dimension and linked that to the Revenue fact. I also created a Fact linked to the
Date and User dims that will show the date the user was created. By doing this, I was able to create a calculated measure that will show me total revenue, plus the revenue that is only for new players for a specific month:
member NewRev as
exists(DESCENDANTS([User Account].[User Account].[All], [User Account].[User Account].[User Account Key])
, [Date].[Date - Calendar Month].currentmember
, "User Registration")
, [Date].[Date - Calendar Month].[Calendar Month].& on rows
Sorry it is a bit messy, testing at the moment.
What I would like to do is create a shell dimensions so I can create a hierarchy that will show new and returning players as members. It would have an all level, or the user could split the revenue by this dim. I set things up like the Time calculations
shell dim, but am a bit stuck with how to create the mdx so that it will work with any measure.
What would I change to do this?
View Complete Post