Aggregation Table Issue

Post Reply
User avatar
jim wood
Site Admin
Posts: 3500
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Aggregation Table Issue

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

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

Post Reply