Aggregation Question

[Thejuan]

Im very new to this!

I have a situation similar to this example

My Fact table is an OrderItem table

ItemId, OrderId, ItemSoldFor


I have a dimension that is OrderType
OrderId, Type

The dimension is obviously for a group of Items (ie an Order)

When i do this the aggregration of sales is alot bigger than it should be?

 

[justins57]

Typically, what happens is you aggregate the data in the Fact Table. When it gets to the Cube Aggregations it is much larger than it should be. To avoid this, don't pre-aggregate the data in the Fact Table. Also, in the cube the data will be aggregated over multiple dimensions. You may need to refine your query to return data for the lowest levels in these dimensions to get the data to look right.

hth,

Justin

 

[Relloc]

Thejuan have jou found a sultuion I have the same problem with budgets that should be a month level but not on a DAY level