Search found 4 matches

by rmjohnston
Mon Apr 06, 2015 7:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process to Allocate Account Balances
Replies: 3
Views: 4995

TI Process to Allocate Account Balances

My team is trying to determine the best way to write a TI process or processes to allocation specific location and account balances in our forecast cube. We are using TM1 10.2.2.2. We have cxreated a cube that provides the allocation percentages from 6 months of actual allocations. The problem we ar...
by rmjohnston
Tue May 14, 2013 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatically Expand Active Form Two Levels
Replies: 11
Views: 12112

Re: Automatically Expand Active Form Two Levels

Thank you both Declanr and Christopher. It works perfectly.

I updating the already dynamic subsets to expand to the levels needed. I don't know why I couldn't get that statement to record the way it needed to be for the levels desired.

Thank you both again.
by rmjohnston
Mon May 13, 2013 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatically Expand Active Form Two Levels
Replies: 11
Views: 12112

Automatically Expand Active Form Two Levels

I have created an TM1 Active Form in Excel 2007 using TM1 9.5.1 that uses a subset of Industry Groups in the rows position. This expands the Industry Group to list the Customers. The Customers have location codes as the next level. To automatically expand the Active Form so it is listing all Custome...
by rmjohnston
Tue Oct 18, 2011 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset creation using TI
Replies: 2
Views: 2784

Dynamic subset creation using TI

We have created many many subsets to provide alternate roll-up of locations not identified in the location dimension. Currently the subsets use dynamic MDX and are based on attribute values. However, when a new attribute value is created, I have to manually add a new subset and manually add the new ...