FEEDING String Rules on Consolidation Cells

[ardi]

Hello,

I have a Reporting Cube ( 10-dimension cube), and I have String Measure that I want to populate with Rules. (I have 3-dimensional Cube with following Dimensions: Cost_Center, Account, Product, Measures, and all three dimensions have a hierarchy. The user enters a String Measure, and there is an action button that cascades the input value all the way down to the hierarchy (or until it finds a cell with a different value, and this works perfect)

I want to display this String measure in the Reporting Cube, so I added a rule, and yes I can add FEEDERS but since I need to FEED all Consolidated Nodes in this cube, it causes some overfeeding. I am currently FEEDING from the 3 Dimensional Cube to 10-Dimensional Cube. But I was hoping I can avoid that. I have other measures in the Reporting cube, which are populated exactly where I need to display my String Measure, but it does not FEED the Consolidation String Cells.

Thank you

[MarenC]

Hi,

any reason you can't do this via a process and incorporate it into your existing action button?

Maren

[jim wood]

Agreed, you should ad it to the button. Trying to feed from a 3 (although I counted 4 including measures) to 10 dimensional cube is always going to result in over feeding unless you have specfic elements witin the non common dimensions to feed too.

[Steve Rowe]

The comments about populating with a TI are probably the most right

If you want to do this with rules then the feeder needs to be in the 10d cube and needs to start from a leaf cell that is populated at the right level, as you suggest in your post.
but
1. You need to put the Feedstrings statement in your rule sheet in order to be able to feed a string cell.
2. Remember feeders only do work at the N / Leaf level of a cube, you can't feed a consolidated cell. A consolidation will only return a ruled value if one of the cells below it is feed and populated, even for stings. (Assuming a zero-suppressed view)

So your rule sheet would be something like this.
Skipcheck;
Feedstrings;

#if statement stops value being populated at all the unfed locations.
['String Value']=S: If (['Source Value']=0 , '' , DB('Other 3d Cube' ,!Dim1, !DIm2, !Dim3));

Feeders;
['Source Value']=> ['String Value'];

This would mean that the string value is populated at both the N and C level though