Basic Budget data modelling
Please can you advise me? It is to do with a basic modelling question about budget data? Sorry if it is a silly one but I am a BI novice.
Say I have actual sales revenue and budget sales revenue (coming from my planning system in either BI IP or CO) how is the best way to store this data in BI.
Could I create one infocube with 2 key figures for actual sales revenue an budget sales revenue?
Or should I just create one key figure for sales revenue and then have some kind of flag to point to actual or budget master data? If so how do I do this?
Thanks so much.
Create a keyfigure revenue and in report filter on version values as Actual and budget.