Skip to Content
0

Report-to-Report interface variables

Mar 06, 2017 at 03:35 PM

68

avatar image

Hi Experts,

I have the following requirement:

I need to create a report, which displays all General Ledger accounts for a selected year. It should also be possible to drill-down on line item level.

The problem is that those two are based on two different DataSources – 0FI_GL_6 for General Ledger Transactions Figures and 0FI_GL_4 for direct line items.

Using the new GL DataSources 0FI_GL_14 is not an option.

Anyways, long story short: we decided to implement a report-to-report solution.

I created a simple example with two flat files (the data is completely made up).

First, there is the accounts query:

Now I filter to the data of the year 2014 with “keep value on axis”. Afterwards I right click on an account and jump to the Line Item Query:

At the Line Item Query it shows me the data for the specific account I selected for all years:

So far so good, but here is the issue:

If I filter on the year 2014, I just want him to show me the data from 2012 to 2014.

How can I realize that?

In BW on the Report-to-Report settings (T-Code RSBBS) I selected to delete Calendar year. If I don’t do this it automatically filters the Line Items to 2014 only. However, I want the period 2012 to 2014.

At the field assignments, I already saw that you are able to set a variable:

What should I type in for the field name? How do I have to configure it that it only select the years after the filtered year?

one.png (78.5 kB)
two.png (57.1 kB)
three.png (87.2 kB)
four.png (47.7 kB)
five.png (17.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Taner T. Mar 07, 2017 at 09:40 AM
0

I found a solution for this problem:

You have to define the variable in the Query of the Line Items (in the Query Designer). So that the Line Item Query has a variable that filters the years from the first year (in this case 2012) until the selected year.

When you now jump with your report-to-report interface to the other query it automatically gets the selected year and filters it.

You don't have to anything in the field assignments.

Share
10 |10000 characters needed characters left characters exceeded