Writing Feeder Rules

Post Reply
Saturn Jay
Posts: 1
Joined: Wed Jul 18, 2012 6:51 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Writing Feeder Rules

Post by Saturn Jay »

I am puzzled as to why I can't seem to get data pushed over to my CostOfQuality2 cube with my rule.

I have the rule in my income cube called "Inc". "Scrap" in my Inc cube is a consolidated element that sums three different scrap accounts (gross scrap, scrap sales, scrap other). I expected the rule to take actual scrap from my Inc cube and load it to "scrap" in my CostOfQuality2 cube but I only get zeroes. I have Skipcheck and Feeders in my rule and no other rules are impactin the CosOfQuality2 cube.

Is there anything wrong with my rule?


['Actual', 'Scrap']=>DB('CostOfQuality2','Actual',!Years,!Depts,!Ledgers,!Plants,!Projects,'Scrap',!Periods);
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Writing Feeder Rules

Post by declanr »

The main problem is that isn't a rule... it is a feeder.

If you post the dimensionality of the 2 cubes and explain which elements you want populating from the other we will be able to explain what your rule should look like.


As a rough hint it will be along the lines of:

['Element']=N: DB('Cube 1',!Dim1, !Dim2....);
Declan Rodger
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Writing Feeder Rules

Post by EvgenyT »

Yes, please provide bit more details.... Will be happy to help

Evgeny
Post Reply