Hi everyone,
Would love to hear your views on a new dashboard I am designing.
We use Bex queries via oData. I am pulling in five years worth of sales data and a faily high level. For one chart in my dashboard I am breaking out two years worth of Sales Actual - Plan and Prior Year values by month. I have some transformations to do on the data to convert the Calendar Year/Month to a 2 digit field called Month and then I change the month numbers to month names and plot the output.
Should I bring in a second 0data source (which would be the same BEx query but only selecting a narrow subset of data in my Select URL statement) that only contains that two years worth of data I need or would I stick with the one data source and transofrm all the data.
I'm wondering about best practise here in terms of speed/performance in that there is no point in having the system transform the Calendar Year/Month field to a month name if I don't need it.
Thanks for reading this far 🙂
Gill
