Prior year data

[Former Member]

Hi Gurus

This may be very easy but I am having hard time in designing my star schema, I need Prior year revenue and this year revenue in 2 seperate column in a report. I am planning to load prior year data once I start loading my cube ( from flat file ) and then will load daily data ( from flat file with same format as History data file ). Will that be ok?

Now shall i put 2 key fig in a cube ? Revenue and Prior year revenue . or Shall I put only revenue?

If only one key fig then what I need to do on the in my query design to get this 2 columns on report ( variable / Resticted key fig) also how can I make sure that I am getting proper time related data , I mean history data in history column and today's data in revenue column?

Pl help me to understand this . I hope i placed the question correctly.

[Former Member · Accepted solution]

Load everything in one key figure, just make sure you have a date characteristic. Afterward in the report you use restricted key figures (2 of them) to create your current year and last year columns. This will actually be quite easy when you get to the report design step.

[Former Member]

Thanks

[Former Member]

1. Your first question: your solution is perfectly fine, but make sure you dont get prior year data in the current load to avoid duplication.

2. You should have oly one key figure and prior year and current year will be distinguished by the fiscal year characteristic which , hope you have in your cube.

3. For prior year , use the content variable "previous fiscal year". Activate this from the content. Use this variable and define a RKF which will give you prior year revenue.

Ravi Thothadri

[Former Member]

Hi Gurus

Thanks for the clarification. Sorry for the delay in reply,I have given points according to details given in the answer.

Thanks again

[dielom]

Hi Kris,

You can do both, but the best aproach is to use only one key figure, and then make two restricted key figures for each year. if you use two KF, next year you cube will be unuseful.

To create the RKF, you may use Business content variables for the year time characteristic. You have one variable for current year and another variable for last year.

Hope this helps.

Regards,

Diego

[Former Member]

Put in only Revenue. When you load prior year data, put in a date from prior year. You can separate current year and prior year as restricted key figures in your queries. If you create two key figures in your cube, you will run into issues and the end of this year!