SAP Bex query related issue

[Former Member]

Hi Experts,

Please let me know the procedure to do the below task.

The customer exit variable is built to take system date as input and the out put will be the starting and ending date of the current year.

When i excute the query,I don't see any variable input screen because I don't need it. The Query will process the input into the variable in the backend and we will see the query results only for the current year 2012.

Now I want  to design two KFs for "Total Spend Current Year" and "Total Spend Previous Year".  the available  base Keyfigure is ZCSAPAID (CASS Paid Amount ).

Thanks in advance,

Seenu..

[former_member223480 · Accepted solution]

Hi Seenu

In the Time dimension do you have the year as a selection? It is much easier If you have it, then check if you have any Customer exit Variable with current year. If you don't have then you need to build it by yourself (search the forum for it).

For the first KF add the ZCSAPAID in columns, right click on it - edit... search on the left side in the dimensions the Year variable add it on the right side in the detail area, ok and is ready.

Copy paste the the KF change the name in the properties pane. Right click on it - edit... on the details area right click on the variable - restrict and on chosen selections you will have the variable right click set offset give -1 ok,ok,ok and is ready.

Thank you

Yiannis

[Former Member · Accepted solution]

Thank you  Ravi..

[Former Member · Accepted solution]

Thank you  Yiannis..

[ravi_chandra3 · Accepted solution]

Hi seenu ,

Is your issue resolved ...

Regards,
RaviChandra

[Former Member · Accepted solution]

Yes.... Ravi..

Regards,

Seenu

[ravi_chandra3]

Hi

Just create the 2 selection and restrict the first selection with current year and another selection with previous selection(with the help of offset variable ). u can have predefined varaible for current year why to write the customer exit unneccasarry. That will degrade the query performance.

Regards,
RaviChandra