Help with feeder

Post Reply
motylfx
Posts: 7
Joined: Fri May 29, 2015 1:49 pm
OLAP Product: cognos tm1
Version: 10.2
Excel Version: 2010

Help with feeder

Post by motylfx »

I have rule in cube1

[measure1] = N: if([measure2]<>0, DB('CUBE2', !dim1,!dim2, measure3 ) + DB('CUBE2', !dim1,!dim2,!dim3, measure4 ) , CONTINUE)

How i should write feeder?
[measure2]=>[measure1] ?

Or i must put feeder in cube2 ? - problem with thist solution is that, in cube2 i have less dimensions, and there is overfeeding:
[measure3] => DB('CUBE1', !dim1,!dim2,'TOTAL', measure1 ) - overfeeding
[measure4] => DB('CUBE1', !dim1,!dim2,'TOTAL', measure1 ) - overfeeding

Sorry for my english
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: Help with feeder

Post by EP_explorer »

it seems
[measure2]=>[measure1]
would work properly
User avatar
qml
MVP
Posts: 1098
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Help with feeder

Post by qml »

For your example [measure2]=>[measure1] would indeed work. Depending on your data there could still be some overfeeding if for measure2 the cube is populated much more densely than measure3 and measure 4.
Kamil Arendt
Post Reply