Customer exit or replacement variable

[Former Member]

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!

[Former Member · Accepted solution]

Hi Shivani,

Create a formula and under formula variable generate a new one and give it the tittle "Fiscal Year" and mark as available for input, then use it in the formula and make it no visible. Then in user exit create a new variable for Fiscal Quarter taking variable formula value and create an interval from 1 to 4 of year of formula variable.

Regards,

Gorka.

[Former Member · Accepted solution]

Thanks Gorka. I tried that yesterday but when I am feeding the interval value taking the value from formula variable, somehow it is not reading that and running for the entire open period and year field is blank.

Looks like I am missing some important information.

By default formula variable is created with number and if I choose date then it is not letting me enter as Year I need to enter in the date format.

I have added Fiscal year field as well and would like to pass the input field (to the formula variable) to the actual fiscal year. Do you think if this is possible to have inside the query at the drill down level?

Thanks again for taking time.

Shivani

[Former Member · Accepted solution]

Is there a way we can pass the value of fiscal year from the formula variable to fiscal year so that user can run the data for multiple years and compare the data

[Former Member · Accepted solution]

Hi Shivani,

Try this code in user exit.

The variable anno is char 4.

Before you have to créate a mandatory variable of type formula to insert fiscal year (in the example is the ZZ_VALFOR variable).

Regards,

Gorka.

[Former Member · Accepted solution]

Thanks Gorka I could do that but wanted to pass Fiscal year to the actual dimension so that user can use it within the query to slice and dice by year to compare the data.

is there a way. And I am not sure if by formula variable would work for multiple years?

Regards,

Shivani

[surendra_p]

Hi Shivani,

Your Query is You don't have Fiscal year in the cube level but we have Fiscal QTR.

From this Fiscal Year QTR the values like suppose 2016(QTR Value)--201601 or 201602.....,

But for Fiscal Year we have values like YYYYMM So we have only YYYY bur we don't have MM .

From QTR Value we can't populate MM Values because Q1--Have 01 or 02 or 03 Months,Q2----04 or 05 or 06....,Q3,Q4.

we can not decide for month value which value we are going to populate.

But suppose if use passing YYYYQTR Value he wants last year same Quarter value  for this we can populate the values using Customer Exit Variable using Fiscal Year QTR.

Regards

Surendra