I haven't see a clear example of how to setup the following for efficient aggregations:
Example 1:
If I have a Hierarchy like:
Year->Month->Day
Its clear how to setup the attribute relationships as long as the Month members are all unique. Can I somehow include an Attribute like WeekendIndicator? Weekend certainly isn't unique, but it would seem there should be a way to roll this up and include it in the attribute relationships.
Example 2:
In many of my dimensions, I have Hierarchies whose Name member is not unique, but there is an Id value that is unique. I want to build the relationships using the Ids since I know the aggregations will be good...the problem is, that a program querying the data would use the IDs, but a person writing a report would want to use the Name attributes. Is there a way to link the two together so that the non-unique name members are tied to the Id fields. The User Defined Hierarchy define on names works fine from a UI perspective, but I want to make sure I have aggregations as well.
For example, if I have a Campaign dimension, and users frequently want to navigate these for rollups:
Account -> MarketingProgram->MarketingCampaign
The fact is an Order
The Program and Campaign names can be anything, but their IDs are enforced to be unique. How do I manage these together?
Example 3:
And finally, if I want to do rollups with the following types of attributes
AccountStatus->AccountCategory->Account
I can't build an attribute relationship for this since Account Category does not imply Account Status since all accounts of a certain category are not guaranteed to be within an Account Status. How do I efficiently build aggregations for this type of hierarchy? The User Defined Hierarchy allows the customer to navigate it, but the aggregations don't allow it.
Thanks for any insight!
Example 1
Create a new attribute WeekeendIndicator and use it to filter the time dimension.
Example 2
One way to resolve this by adding the name and id in a view or Data Source View as a calculated value, e.g.
Market Development Fund (1)
Market Development Fund (2)
Market Development Fund (3)
Example 3
If the hierarchy is enforced (or a strong hierarchy) such as the time dimension, then aggregations can roll up.
Hope this helps.
|||That's a solution , but not quite what I want to do.
Example 1 -> Is there a way to pre-aggregate this information with attribute relationships?
Example 2 -> I know I can generate unique names, but is there a way to "pair" attributes together so I can leverage the Ids for the aggregation but see the names elsewhere
Example 3 -> The issue is the hierarchy is not enforced, so is there no option for attribute relationships of any kind, is there another way I should model this?
Freakyuno wrote: