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

BI Report - Need output in Single row | User Exit ? Virtual Charecteristic

Hello,

I am working on updating an Asset Balance report query(which runs on a multiprovider) so that the the result is a value comparison between different Dep.Areas

Assume the data:

Ccd--


Asset
Life

Depr Area
-----KF

10 -


100--


1
10
--


1000

10 -


100--


2
20
--


2000

10 -


100--


3
80
--


8000

(All the KF values are not direct values from the multiprovider)

User enters values for (mandatory variables) at the time of executing the report for: FiscalYear/Period, Ccd, Asset, Depr Area

--> Whatever the value is entered by the user for DeprArea, ( KF(80)-key figure value of Depr Area(80) should be populated as shown below)

**********************************************************************************

If user enters: Ccd - 10, Asset - 100, Depr.Area - 10

The requirement is to get the output as:

Ccd--


Asset
Life

KF
--


KF(80)

10 -


100--


1
1000
----- 8000

*******************************************************************************

If user enters: Ccd - 10, Asset - 100, Depr.Area - 20

The requirement is to get the output as:

Ccd--


Asset
Life

KF
--


KF(80)

10 -


100--


2
2000
----- 8000

*******************************************************************************

-


As per my workaround on this, I am getting the report results as below in two different rows:

If I give the values: Ccd - 10, Asset - 100, Depr.Area - 20

Output I am getting is:

Ccd--


Asset
Life

KF
--


KF(80)

10 -


100--


2
2000
----- ____

10 -


100--


3
____
----- 8000

I want the output when I run my query as below in a single row:

Ccd--


Asset
Life

KF
--


KF(80)

10 -


100--


2
2000
----- 8000

-


To get the output, I am assuming only User Exit / Virtual Char can give the result as expected.

Please advice if there is a way to get the output as I need and please advise the logic that best suits for this.

I am assuming, when I run my query since 2 records are returned, what if I capture the 2 records and process the records in the user exit ( change value of Life(3) to Life(2) using Virtual char )?

Does this logic worksout?

if so what will be the results in my query after processing of the user exit? Output_A(1 row) OR Output_B(2 rows)?

_Output:A:-- 10-- 100 2 2000 --8000

_Output:B:--

10-- 100 2 2000 --8000

10-- 100 2 2000 --8000

Please advice the best workaround or solution to achieve this!!!

Does this user exit effects any other reports?

Thanks

AK

Edited by: AK I on Feb 20, 2009 5:49 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 20, 2009 at 04:55 AM

    The issue is because one of the infoobjects in the query is not common - between the infoproviders being queried for...

    You would have to do an infoset in order to get the putput in a single row or have only common infoobjects in the query...

    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.