Hello friends,
I’m struck on a requirement which could be done using aggregate awareness.I tried googling, designer pdf and also BO forum…but still unclear of the solution
I have 2 dimension and 1 fact table as below
Dimension tabe D1 with columns
Time_id
Day_id
Month
Quarter
Year
Dimension tabe D2 with columns
Day_id
Day
Fact tabe Day_Fact with columns
Fact_id
Day_id
Day
Total
Quantity
My requirement is to build a prompt with LOV’s i.e Day,Month,Quarter,Year as a pick list. When the user selects Day, then the report should be displayed at day level which can be generated from Day_Fact table as it is a detail table at day level, but when the user selects month or quarter or year , the data should be aggregated at the corresponding level.
Do we need to modify the existing Day_Fact table to include Month, Quarrter and Year columns and create 3 more aggregate fact tables as below ?
Day_Fact
Fact_id
Day_Id
Day
Month
Quarter
Year
Total
Quantity
Month_Fact
Fact_id
Month
Quarter
Year
Total
Quantity
Quarter_Fact
Fact_id
Quarter
Year
Total
Quantity
Year_Fact
Fact_id
Year
Total
Quantity
yellos (BOB member since 2009-09-17)