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

Report Calculation

Hello Gurus,

I generated a report on cube will have following infoobjects

1.Fiscal Year,Fiscal Year period are Infoobjects

2.Monthly Revenue, Monthly Booking are Keyfigures

My report <b>variables</b> are Fiscal Year and Fiscal year Period

For Example User will pass Variable values Fiscal year = 2006 and Fiscal Year Period = 10

User Expecting Following report output

<b>Report Output</b>

Monthly Revenue

Last Year Monthly Revenue(In this case 2005 year)

Year to date Revenue(Cube having 2003,2004,2005,2006 total years Revenue)

Monthly Booking

Last Year Monthly Booking(In this case 2005 year)

Year to date Booking(Cube having 2003,2004,2005,2006 total years Booking)

How to calculate following values

1.Last Year Monthly Revenue

2.Year to date Revenue

3.Last Year Monthly Booking

4.Year to date Booking

Gurus your input would be appreciated

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 08:38 PM

    Hi Roy

    This is how do the the calculations using the BEX query designer.

    How to calculate following values

    1.Last Year Monthly Revenue

    Create a restricted key figure, include Monthly Revenue, fiscal year and period, set the fiscal year to your variable and then in the next selection screen right click on your variable and select Variable Offset adn set it to -1. set the period to your period variable.

    2.Year to date Revenue

    Create your restricted key figure, make sure you include fiscal year and period, set fiscal year to your year selection variable and set a value range on fiscal period for between period 1 and your period selection variable.

    3.Last Year Monthly Booking

    repeat the step 1 but substitute monthly booking for revenue

    4.Year to date Booking

    repeat the step 1 but substitute monthly booking for revenue

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The offset on the variable will only effect the rkf in which the restriction is made, so you can have several rkf all using the same var with different offsets with no problems.

      Your current restrictions look fine, but you could be missing some, it could be useful to reconcile the data in the cube to the value your expecting that way you can see all the restrictions on the data.In BI transaction RSA1 display data on the infoprovider you have written the query on, try to reconcile one row against one column, so try to find the Last Yr Monthly Booking Actual against a specific cost centre or for whatever characteristic you have in the rows. the data may have some additional version, value type, currency type, fiscal variant, etc restrictions that you have no accounted for.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 08:48 PM

    Fiscal Year Period = 10 ??? Is it posting period = 10 FYP is 200710 not just 10.

    Do you have posting period available - 0FISCPER3 ??

    Monthly Revenue - Should this display only for user entered year for month 10 ?

    Last Year Monthly Revenue(In this case 2005 year) - 2005 & for month 10 ?

    Year to date Revenue - Is it not YTD - Summed up Revenue for year 2007 - From month 1 to month 10 ?

    Message was edited by:

    Jr Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Fiscal Year(IO) = 2006(User Enter)

      Fiscal Year(IO) = 10(User Enter)

      Monthly Revenue = Should display Monthly Revenue of 2006,Month(10)

      Last Year Monthly Revenue(In this case 2005 year)= Should show 2005, upto month(10)

      Year to date Revenue-Should show summed up from 2003,2004,2005,2006 upto month 10.

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.