Skip to Content
0
Former Member
Oct 18, 2005 at 08:56 PM

Standard unit of conversion

45 Views

HI all,

here is the Scenario:

In a Basic cube

I have a two chars.. say product2 and product1

Product1 is an attribute of product2

standard conversion factor(KF of type FLTP) is also an attribute of product2

All the key figures that come into the cube are in cases. In order to see them in standard unit of measure, a formula variable of type replacement is created. with Product2 as the char, and the replacement path is attribute value of standard conversion factor. And then a calculated KF is created which multiplies the original sales with this formula variable to derive the standard unit of measure. Till here everything works fine on the Basic cube.

Now there is another virtual cube sitting on top of this cube. Which just pulls Product1 but not the product2. when they run reports on this virtual cube, they see all the sales in cases.

Requirement: So now they want to see the sale figures in standard units. Basically they want to recreate the same effect that is in place in the Basic cube changing the cases into standard units.

How can this be achieved?

these are a few things i tried:

I added standard conversion factor as an attribute to the product1 and tried to recreate the same creating the formula variable and calculated KF(which i was sure wouldnt work). But when i'm runing a report, i dont see any values for the calculated KF, but when i include regular KF, i see them and all are in cases.

I know thats not a good explanation, but i tried my best to make it understandable. Pls dont hesitate to nail me down if you dont understand or lost track of the problem.

Thanks in Advance, any help is appreciated and fully rewarded.

Thanks,

Mav.