Hi Experts
I need to display Pivot table type report in sharepoint 2007, the approach I taken is -
- Create a Cube in Sql analysis Services 2005, process it, deploy it.
- Use OLAP Browser (Strategy Companion Analyser, evaluation version) to create Pivot table report using measures and dimensions created by cube.
- This gives me URL of the report.
- In sharepoint 2007, use page viewer web part to display that report using URL from step above.
The Problem
==========
OLAP Browser are expensive to buy, is there any other way I can achieve the same results, ie - using Reporting Services or Excel or something else.
Does reporting services has the ability to use Cube, or can you connect SQL server 2005 directly to create similar look and feel reports?
Thanks
Start Free Trial
