Populate quarter with 0FISCPER

[Former Member]

Hello Everyone,

We have 0FISCPER and 0FISCVARNT in the provider. The requirement is to have just the fiscal year as the selection criteria and have quarters displayed in the rows below the fiscal year.

2006 | 2005

Q1 | Q2 | Q3 |Q4 | Q1 | Q2 | Q3 |Q4

Is this possible in the first case and if so how? Is it possible to generate quarters without MONTH and YEAR. Please let me know asap, all replies would be appreciable. If need further clarification let me know.

Note: The user needs to enter the fiscal year in the selection field i.e. 2006 and in the report they should be able to see the year and quarters under the year.

Thanks,

[Former Member · Accepted solution]

Hi,

If you want a variable that accepts an year, then you must have 0FISCYEAR or 0CALYEAR in the cube.

once you have them in the cube, Create a user entry variable on one of these year characteristics (which ever you include in the cube). From this variable, determine the fiscal periods for the 8 columns (for the quarters) using customer exit variables.

Hope this helps.

[Former Member · Accepted solution]

AJ,

You are saying that my requirement wouldn't be possible with just 0FISCPER atleast from the reporting perspective keeping aside the backend development. I need 0FISCYEAR or 0CALYEAR from which I could derive the year and have customer exit variable for QUARTER.

Please confirm.

Thanks,

[Former Member · Accepted solution]

you can derive 0FISCYEAR from 0FISCPER. The system does the automatic time conversion for you. Just map 0FISCPER(source field) to 0FISCYEAR (target field).

And moreover your requirement is pretty much possible with ur scenario .. thats a very common req.

[Former Member · Accepted solution]

Hi,

If you want an year to be inputted by user (as you mentioned in the note above), then you must have the calyear or fiscyear included in the query (may be in a in a hidden structure), just to be able to invoke the variable to accept the user input. Subsequently, oyu use that value to create quarters in an exit.

But, if your users agree to input a fiscal period in the variable selection screen (a single value or a range), then it is much simpler. Using the fisc period value inputted, you determine the quarters in customer exit variable(s).

Hope this helps.

[Former Member]

You can derive fiscal year from fiscalyear/period in ur update rules and calenderyear/quarter from some date field (like posting date or doc date). That way you have both the year and the quarter breakup in ur cube. Place it accordingly in ur query.