Skip to Content
0
Former Member
May 18, 2016 at 06:18 PM

Customer exit or replacement variable

68 Views

Hello Experts,

I have a requirement where we do not have Fiscal Year in the cube and reloading the data even with self update is not an option.

Highest level of data is going till Fiscal Qtr but users requirement is to give Fiscal Year as a prompt.

In this scenario we would like to populate/derive fiscal year from Fisc Qtr,

Another issue is there no range in the prompts, all users are using is single severals so they are running the queries by entering 1/2015 2/2015 ....2/2016 if they are running the data for 2 years..

How can we resolve this issue.

I thought of writing customer exit on Fiscal year by running the query by Fiscal Qtrs but how to populate another variable which is of different type.

I have created variables to derive same type of variable.

Any hints ideas or any other better options to address this issue would be highly appreciated.

Thanks!