Page 1 of 1

Aggregation Table Issue

Posted: Tue May 11, 2010 3:32 pm
by jim wood

I am trying to setup some aggregation on my tables. I have 4 tables: Actual Summary, Budget Summary, Forecast Summary and Actual Outlet (Outlet is a catalogue or a brochure). As you might have guessed I need to set an aggreation level for actual (We have a version dimension) so that any measure will get data from the summary table when outlet is not included in the report. That's easy enough, the complication is that we don't budget or forecast at outlet level and there will never be a budget outlet or forecast outlet table. Any idea how I would go about setting this up in the logical table fragmentation window?