Standard unit of conversion

[Former Member]

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.

[Former Member]

Hi guys

this forum is a solution provider to the SAP Developers Ok not a points game or like a simulatiion games ,

posting the closed tickets again and again ...its not good as a Sapient..

ok

anywat take it easy..

bye srini

[Former Member]

I perfectly agree, but i dont think thats the same with Dinesh though.

[Former Member]

Hi Guys,

Try to understannd Mr Dinesh' pain.

We <b>really</b> do not get any benift from the points in this site. But it gives some sort of self satisfaction.IF the people are getting solution, but , if they are not assigning the points to the helped persons, gives lot of pain to tha person who really helped .

Surely you will come to know this one, <b>once you started the giving the replies</b> to the problems.

Hey guys, Even though the site is used to help others, why should an expert(like Dinesh) will help you? He is using his valuable time to slove your questions(obviously you will be paid for that, not to Dinesh)

If the peple like Dinesh(people out of SAP) are stopping help others, Lots(80 % ) of questions may become unanswered. Even though it is answered by SAP people , you may get it lately.

Hey Srinivas,

Before making comment on others, try to understand the value he has gievn to this site. It is very bad to see that you started participation in this forum by making a bad comment on a very good expert.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Mav,

Thanks Mate!!.

Bye

Dinesh

[Former Member]

Hi Mav,

Would you mind allocating points in your previous posts and also close them. There are lots of open posts under your user id. Unless you allocate points there will not be many people forthcoming to help you. Remember assigning points is the way to say Thanks in SDN!!.

Bye

Dinesh

[Former Member]

I would love to allocate points my dear friend, i know how to say thanks, but the system aint allowing mt to assign. when the system allows, i would. And moreover most of my questions werent completed answered, so i dont think i would close them. Anyway thanks for ur advise friend.

new update i did assign points, the sys did allow me.

cheers,

Mav

Message was edited by: Maverick