Skip to Content
author's profile photo Former Member
Former Member

Standard unit of conversion

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2005 at 06:04 AM

    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!!.



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.



      Message was edited by: Maverick

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 06:04 AM

    Hi Mav,

    Thanks Mate!!.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 08:25 AM

    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..


    anywat take it easy..

    bye srini

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.