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.