I am into reporting and dashboard creation platform.
Recently I created one dashboard in Excel 2007 which is connected to SSAS Olap cube 2008 R2.
But I am facing problem with the performance of the report. The report is about sales, margin, forecasting with respect to products.
Although the cube is heavily loaded with all sort of detail data at the level of time-stamp.
But I only need the aggregated view as per week, location and product wise.
Is there any way that is possible to increase the performance of the query.
I tried with perspectives, sub-cubes and certain optimization on MDX query level, but still didn't got any significant change on performance.
Please suggest any better idea.
Thanks.
