Pulling data from a certain part of a hierarchy

[hpansar]

Hello everyone,

Im trying to create a RULE that will do the following:

Cube A (Source Cube):
View
Version
OrderType (Initial Order, Repeat)
ProductHierarchy (Total Parts, PartsLevel 1, PartsLevel 2, PartsLevel 3)
Account (Total Sales)
Month

Cube B (Target Cube):
View
Version
ProductCategory (Total PartsLevel)
Account (Total Sales, Total Sales at PartsLevel 2)
Month

Basically, what I need to do is take the Total Sales from Cube A and have the RULE look at the ProductHierarchy dimension level 2 and pull just the sales for that level. So if the Total Product is $300 in Total Sales, I need to take the $100 from level 2 and put it into Cube B.

thanks so much for your help

Hiten

[jim wood]

Have you checked the reference guide for rule functions regarding element information. I think you'll find one there for element level. If you have trouble with having 2 cubes, think about creating a lookup cube with the dimension in. Put the level in there. I'm sure get the idea,

Jim.

[lotsaram]

In addition to the pointers from Jim you might want to have a look at the request for assistance guidelines and in particular explaining what work you have actually done yourself to solve the problem and the approaches you have tried or are considering trying.