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

Counter Key Figure

Hi All,

I have a scenario where I need to <b>count the number of records</b> in the InfoCube data with one particular characteristic value (e.g. count records where CLEARING_AREA = 'CLRAR'). I have defined a key figure, which would always hold the value of 1. This constant of 1 comes from the Source System and is directly assigned to this KF.

I have defined this KF with Aggregation and Exception Aggregation values as 'Summation' but I guess the <b>type of KF I give is incorrect - with 'Number' and 'Integer', I am unable to do a summation</b> on this KF in the query designer; whereas I notice that with a payment amount KF with type 'Amount', I am able to do a summation in the Query Designer.

I have already <b>referred to an earlier post: Counter Key Figure, but it doesn't tell anything about the type of the KF to be given.

Request you to please help me out with this.

Thanks and Regards,

Vidya.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 06:14 AM

    hi vidya

    check this link it may help u how to create a counter

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7e58e690-0201-0010-fd85-a2f29a41c7af

    regards

    abiram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 10:12 AM

    Thanks for your reply abi ram.

    In the document, in step 5, when I drag that 'Counter' variable into the formula box, it displays two open-close brackets after the KF name, like:

    <b>'Counter'( )</b>

    If I leave the brackets empty or try to delete them, it gives a syntax error in formula. If I give any value in the brackets, that value is merely displayed on the query result, without any summation.

    Does anyone have any clue what these brackets are all about?

    Thanks and Regards,

    Vidya.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 10:26 AM

    Hi,

    weird.. what do you mean exactly by "unable to do a summation in the QDesigner"??

    your counter should perfectly work...

    let us know...

    Olivier.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 06:09 AM

    Hi Olivier..

    By 'not able to do summation in the Query Designer', I mean that when I drag the Counter variable into the formula box, those open-close brackets appears to the right of the Counter field: 'Counter'( ). It neither allows me to delete the brackets nor to leave them empty. If I give any value in them, it merely displays that same value in the report; e.g. if I give 2 within the brackets, it merely displays 2 in the report, without any summation.

    I could not figure out why those brackets appeared. I deleted the Key Figure and created a new one. Now I am able to do the summation on this new KF without any problems. Those brackets also don't appear for this new KF in the formula box. The mystery remains unsolved...

    Thanks and Regards,

    Vidya.

    Add a comment
    10|10000 characters needed characters exceeded

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.