Skip to Content
0
Former Member
Feb 19, 2009 at 09:22 PM

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

29 Views

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