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.