How to view Financial Year details in Scorecard

[Former Member]

Hello all ,

We are using SSM 7.5 SP 04. We have built a scorecard with monthly KPIs. The financial year for my client is April to March. So , he wants to see the monthly data and the FY data in the scorecard. But , the timeperiod drop down box shows only 2 options for checking the yearly data ie. Year , Year to date. It is assuming calendar year and the data is coming for Apr to dec of 1 year and jan to march of second year.

It is a compulsory requirement for the client to check the FY data. Is there any setting change to be able to see the FY data from Apr to March ? Also , the client wants to see the data for all the 12 months in the FY year. But only 11 months data is displayed.

Thanks

Vijay

[Bob_McGlynn · Accepted solution]

Vijay,

When you initially build your model in PAS, you set the fiscal calendar. You would have to determine if you wanted the model's calendar would be for the Fiscal Year starting April or the Calendar Year starting in January. Did you set the model fiscal calendar for April?

Regards,

Bob

[Former Member · Accepted solution]

Hello Bob ,

Thanks for your reply. I built a dimensional model using the BICA and imported a BW query. I did not enter any command to set the fiscal calender in the PAS. I thought the data from the BW system would determine it.

If I set the calendar after the data load , can we see the data for the Fiscal year ? The client requires a drop down in the " Set Period " box stating last fiscal year. He wants to compare the performance of the present Fiscal year to the previous .

Thanks

Vijay

[Former Member · Accepted solution]

Hi Vijay,

You need to set the calendar year before any data is loaded into the Model. If data is already loaded, you cannot change the calendar year. In this case, you just need to remove the data, change the fiscal year, and load the data again.

Check the following note for the steps to follow in order to bring data from queries with FISCAL YEAR or FISCAL MONTH characteristics:

https://service.sap.com/sap/support/notes/1325802

Best regards!

Ricardo Vieira