Aggregation Table Issue

Post Reply
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Aggregation Table Issue

Post by jim wood »

Guys,

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?

Cheers,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply