How to pass offset variables to Crystal Enterprise

[Former Member]

Hi,

I have a requirement to show the Annual Pay for this year (current year) and the last year (Previous Pay) in two different columns. In Bex, I can do this by using offset variable (Current Calendar year -1) which brings two rows (one for the current year and one for the previous year. How do I pass this parameter to crystal report and show it in two different columns. Or is there any other way to achieve this functionality? Please let me know.

Thank You,

Madhavi.

[IngoH · Accepted solution]

Hello Madhavi,

in case BW is your source your would use the offset in the BEx query

regards

Ingo Hilgefort

[Former Member · Accepted solution]

Hi Ingo,

Yes, BW is the source and I am using offset in the Bex Query. But when it comes to Crystal report, it is aggegating the 2 year values. Please see above. I would like show them in seperate columns as previous and current. Please let me know if you have any ideas.

Thanks,

Madhavi.

[IngoH · Accepted solution]

Hi,

that is more a question of BEx query design.

you could for example easily create restricted key figures separating the numbers by year

regards

Ingo

[Former Member · Accepted solution]

Yes. I can create a RKF but the years are not static. It always has to be current calendar year and previous year.  I am looking for a work around in Bex without using offset variable.

Regards,

Madhavi.

[IngoH · Accepted solution]

Hi Madhavi,

but that is where the EXIT variables are coming in. you would cover that in the EXIT variables.

Ingo

[Former Member · Accepted solution]

Yes Ingo. I have the offset variable which is a SAP exit variable (Current calendar year-1). When I execute the report (CR enterprise), it is summing two year rows and giving me the aggregated value where as I want values seperately for each year (if you look at the screen shot above). In Bex, it runs fine.

Thanks,

Madhavi.

[IngoH · Accepted solution]

Hi,

as mentioned before that is a query design topic.

you could use two restricted key figures. one that uses the value from the exit variable and one that uses the value with an offset

Ingo

[Former Member · Accepted solution]

Yes Ingo. You are right. I just tried that one and it seems like working. Thank alot for all your time. I really appreciate it.

[abhilash_kumar]

Hi Madhavi,

I don't know what offset variables are, but if you have data for both the years in rows, you can use a Crosstab object to achieve this.

The column of the crosstab will be the Year/Date field and the Measure object will be the Summarize field.

-Abhilash

[Former Member]

Hi Abhilash,

Thank you for the reply. For ex: When you set the offset variable in bex for "-1", if you prompt for 2013, it will bring 2013 and 2012 data in seperate rows.. Please see below.

In Crystal report, it is passing the values but aggregating the 2012 and 2013 values and showing as one value (please see below). Can I use the 'max' and  'min' functionality in CR and seperate the values (write a formula) and show as current in one column and previous in another. If so, could you tell me how?as I am trying to use maximum and it is not working.  I appreciate your time.

Thanks,

Madhavi.