How to Populate Values in Report for Fields

[Former Member]

Hi Experts,

I have a Report requirement where in I need to Populate values for FROM Period & TO Period based on the user i/p for Quarter variable.

For Eg;

Fiscal year : 2009

Quarter : 3

Mat Year From period ToPeriod QTY

A 2009 07 09 1

B 2009 07 09 22

C 2009 07 09 44

There are no fields FROM Period or TO Period in Cube.I need to populate them in the report directly.

Please give some inputs to goahead.

Thanks

Ravve

Edited by: ravve king on Jun 4, 2009 4:38 PM

Edited by: ravve king on Jun 4, 2009 4:39 PM

[dennis_scoville4 · Accepted solution]

You're going to need to create a User Exit in your query. Here's a link to a helpful document on how to do that:

[Using Customer Exit Variables in BW/BI Reports Part - 1|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20f119d9-922d-2c10-88af-8c016638bd90]

[Former Member]

Hi,

You need to create a customer exit variable where in this takes the input from the Varibale on Quarter and based on that this will get populated.

Siva.

[Former Member]

If it is possible to add two fields in the cube itself, then it will be a better option .U can just map the two fields to Quarter field from the source and hard code the from and to values based on the quarter .

[Former Member]

Hi Siva

could you pls eplain in detail how to write this code in Customer exit and where to pass these from period and to period values.

Thanks

Ravve

Edited by: ravve king on Jun 9, 2009 8:14 AM