Reg: ABAP code for customer exit variable

[Former Member]

Hi Team,

I have a requirement to create a report based on an multiprovider 'TEST'.

Based on the input selection of Period; I need to define a Keyfigure X which will be a count of value available for that Period in one cube involved in the MProvider. E.g.: If for period 12, the value = 1 in the cube; then this keyfigure will give the count as 1 in the output of the report.

The second KF Y values are available in the second infocube directly: ibut should be displayed based on the value of the KF 'X' with logic as if X > 0 ; then the values should be read from the second infocube in the report. & if X <= 0; no values should be displayed.

Please help me with the ABAP code to be used in the query level.

Thanks & Regards

Sneha

[Former Member · Accepted solution]

Hi Sneha,

I would suggest the following

1.Please change the design the cube and include a key figure Zcount that would be incremented for each record.

Now as per the first requirement you need to get the count for a Input Period from First cube

This would be very simple to implement , all you have to do is restrict this KF with the Input characteristic/variable and also the First Infocube.

2.You can also use exception aggreation counter to address this requirement . Even in this case you need to include a dummy key figure in the cube and the exception characteristic would be the period in the Infocube.

But performance would be on downside when compared to the first one.

3.The second requirement is quite simple

Create a formula KF as follows

(KF1 > 0)*KF2 .

KF1 > 0 is a logical operation and it would always return 1 on success and 0 otherwise.

Hope this helps,

Regards,

James Harold.