TM1 Forum

Hi,

I have one dimension product, that has an attribute "Product Group" and one additional dimension "Product Group". I have 2 cubes - one for sales data (based on Product dimension) and one for product P&L which is based on "Product Group" dimension. I would like to write a rule that would retrieve the values from sales cube to my Product PL cube for specific PL line (like Revenue) grouped by Product Group. Is there a way to write a DB function that sums all the elements that have specific attribute value or is the only way to do it to have one dimension and add product group as consolidated elements of my product dimension and then reference it with standard DB functionality?

I wish the rules language might be extended to include more MDX functionality but at present you can't do what you are asking. The only solution is to build product group hierarchies and pull the colsolidated value through with a DB() reference.

No reason why you wouldn't still have a product and product group dimension in the sales cube provided it gave users some kind of benefit.