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

Calculations based on the values in the cube

Hi Guys,

I need to create a report where I need to calculate a value based on the data available in the cube and not just the data that is the output of the report.

Is it possible for me to use the data in the table /BIC/<datatarget>00 and perform the calculation using ABAP? If so, how can I display the calculated value on the report and where do I write the code?

THanks,

Doniv

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 17, 2005 at 08:22 PM

    Hi Doniv,

    May be I am not clear about your situation, but the data that comes to the report is from the cube (or Infoprovider)...can you explain a bit more...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2005 at 08:43 PM

    Bhanu,

    But the problem in doing that is, it would still display the age for the corresponding employee in the age column. That should be displayed either.

    All I need is display is the following format

    Department Averageage

    Dept1 40

    Dept2 50

    Overall 45

    The present format when I set the employee to "No Display" is

    Department Averageage

    Dept1 40

    ______30

    ______50

    Dept2 50

    ______35

    ______50

    ______65

    overall 45

    *_____ means a blank row

    Thanks,

    Doniv

    Message was edited by: doniv ramuk

    Message was edited by: doniv ramuk

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi!

      you can use a userexit variable in a query which can be used in a calculated keyfigure and displayed in the report.

      search the forum with userexit you will find many posts answering how to create a user exit variable.including some sample codes for other problems.

      with regards

      ashwin

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.