Hi All,
We have a requirement in our project that the user wants to see Cost Trend analysis over two members of Date dimension. Excel is being used as a client tool. Here is the sample report/graph user wants to see
January Feb March Apr
forecast Forecast forecast forecast
DATE-1 58 59 53,2 52.5
DATE-2 58 56 56 56
%CostMovement 0% -0.2% 5.5% 6.9%
in the above i will get costmovement based on some cal on forecasted cost measure for the two date dimension memebers. (user can select any two date dimension members)
Will it be possible to achieve this functionality through excel?
and one more query, will it be possibel to show the data from two cubes in single row of excel?