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.