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

Can a Calculated key figure be derived from characteristic value?

Hi,

I would like to know whether BW allows to derive a calculated key figure based on a characteristic value. Let us say we have a row like

PLANT-DAY-INVENTORYQTY

and based on my plant value, I want to have another column 'CALCULATEDSCRAP' which is derived from 'PLANT' and INVENTORYQTY (I know this is a crude example, but will do for my need)

Is there any way in BW to get this logic implemented?

Thanks,

Ajay Das

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Feb 21, 2005 at 08:49 AM

    It's a little bit tricky, but I would do it as follows. Add an attribute to plant which is a number (1,2,3...). From this point on onwards, you can use the how-to "How to calculate with attributes...".

    Another workaround might be to work with a combination of restricted and calculated key figures. Make a restricted key figure for each plant and combine it in the calculated key figure. We need more detail on your request to help you more in this path...

    Tom

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2005 at 10:10 AM

    Hi,

    If I understand it right, you want to have some sort of <b>IF</b> statement in your Calculated Key Figures?

    Use Crystal Reports w/c is normally shipped with BW to display your report. Crystal Reports can handle complex logics that are not found on BEX.

    --Jkyle

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Tom,

      I have a very similar problem. In my if logic i compare to dates but I don´t understand what you meen by

      "Therefore I suggested to add an attribute to convert the characteristic in a number and use this number for the if logic."

      For the moment, the condition calculates each field individualy correctly but doesn´t treat them as numbers when aggregating.

      Thanks in advance,

      Victor.

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.