TM1 Forum

Hey All,

I am trying to write a inter-cube rule and feeder in TM1 v9.1.2. I can't them to work. Here is what I am trying to do:

I am pulling data from a statistically cube and a financial cube to make a customer profitability cube. I can't get the rule to work for the statistics that brings in consolidated information into N elements of the AAG Customer Profitability cube.

Some background:

AAG Customer Profitability cube is going to pull in the numbers (Disp Units for this example) from the Unit Record cube.

The Unit Record cube has three dimensions that are exactly the same Disp Term, Haul Term, and Drop Term. This is for networking purposes. The CoCost dimension is also exactly the same as the previously mentioned dimensions.

The Months dimension has the days of the week (e.g. 010110, 010210...) as N elements that roll up to the month (Jan-10).
The Forecast Months dimension has the Month (e.g. Jan-10) as the N element.

There similar situation for the Customer Accounts and Forecast Customer Accounts dimensions. The Customer Accounts has thousands of accounts as the N elements and the Forecast Customer Accounts dimension has only 20 N elements that are consolidations in the Customer Accounts cube.

AAG Customer Profitability dimensions:
Forecast Months (Jan-10)
CoCost (Cost centers)
version (Actual)
Financials_M (only 2 elements:US$ or CD$)
Forecast Customer Accounts (Joe's trucking)
Profitability Data (Disp Units, etc)

Unit Record dimensions:
Disp Term (same as Cocost)
Haul Term (same as Cocost will pull consolidated total company level )
Drop Term (same as Cocost will pull consolidated total company level )
Customer Accounts (several hundred elements that roll up to Joe's trucking)
Job_Codes (Total)
Plant Codes (Total)
Load Type (Dispatched)
Month
Data (Units)

Here is the rule in the AAG Customer Profitability cube:
['Disp Units' ] = DB('Unit Record',!Cocost , 'ASHI Consolidated', 'ASHI Consolidated', !Forecast Customer Accounts, 'Total', 'Total', 'Dispatched', !Forecast Months, 'Units');

and feeder in the Unit Record cube:
['Haul Term':'Total Company','Drop Term':'Total Company','Plant Codes':'Total Plant Codes','Dispatched','Units' ] =>DB('AAG Customer Profitability', !Month, !Disp Term, 'Actual', 'US$', !Customer Accounts, 'Disp Units');

I get data in the Customer Profitability cube but when I suppress zeros there are "no values available". I tried putting the N: in front of the I get the same thing and also no numbers in the consolidated elements.

I know there has to be some easy explanation for this but I have been looking at it for too long to see it.

Help please

The problem is likely to be the use of days in one cube and months in the other.
Feeders always _apply_ to N level elements only. You can write an explicit feeder from (eg) ['Jan',...], and the rules engine will interpret that as a shorthand for all the ultimate descendants of Jan ie the days.
Your best bet is to build an attribute which links the base elements of the days to the month, then use that to feed. Some recommend ELPAR, but bear in mind that TM1 does not control the sequence of multiple parents. Using attributes is more controllable.
(This used not to be in the docs, being one of the Gnostic secrets you had to learn via an excruciating ceremony. I believe it is now covered in the Rules Guide.)