The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
0answers
39 views

How to remove leaf member values?

I have a dimension hierarchy that is related to multiple fact tables with different granularities. In the case of one fact table, it relates to the middle level of a three level hierarchy. When you ...
1
vote
0answers
175 views

How to aggregate calculated measures involving dimension attributes?

The business case is as follows - I have a cube of sales transactions and a dimension of parts. One of the attributes of a part is the current cost, which is non-aggregatable. A user needs to model ...
0
votes
0answers
16 views

Many people, one event, multiple factors - OLAP

Have a modeling problem here... first the back-story... We deal with accident data on our project, 1 vehicle-crash can have multiple people and vehicles involved, and many associated factors across ...
0
votes
0answers
85 views

How do I relate two measure groups that share some dimensions?

I have one measure group uniquely keyed to an invoice line that indicates a part number and a quantity. SOLine Part SoldQty 123 abc 1 456 xyx 3 I have ...