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

Calculated KeyFigure

Hi there,

I want to calculate a key figure using a key figure and an attribute from a dimension .. pretty easy 😊

well the problem is that defining the calculated key figure (query designer) I get listed only the key figure and no attributes (with numeric types) are listed there. why? and how can I do to have this attribute on the list...

Thanks in advance

FedeX

Add comment
10|10000 characters needed characters exceeded

5 Answers

  • Best Answer
    Posted on Aug 01, 2006 at 12:32 PM

    Hi Fedex,

    To be able to get an attribute ket figure, you need to create a formula variable (from the formula builder window). Here specify replacement path as the processing type and select the char and the attr value that you need to pull into the query.

    There is also a How To document with details on this method.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/72f4a790-0201-0010-5b89-a42a32223ffc

    Hope this helps...

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:32 PM
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:32 PM

    Hi Fedex,

    You must use Formula Variable, with Substitution with Attribute. You can create a formaula variable from: Right mouse click on KF tree in column --> New Formula --> New Formula Variable.

    Ciao.

    Riccardo.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:35 PM

    Hi FedeX

    give me your mail id, i will forward you a document for the same.

    regards

    vijaykumar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 12:48 PM

    ThnX

    FedeX

    Message was edited by: FedeX

    Add comment
    10|10000 characters needed characters exceeded