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
Help with feeder
-
- 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
it seems
[measure2]=>[measure1]
would work properly
[measure2]=>[measure1]
would work properly
- 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
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