Hello,
In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports.
I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either.
I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source.
As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated.
Thank you very much,
Annie
To create a model based on an Analysis Services cube, use Report Manager. First create a data source which points to the cube, then click "Generate Model" on the data source properties page. AS models can't be edited. Full details are in Books Online, under "Reporting Services How-To Topics".
If you just want to create a report which uses the same data source as your cube, you do not need a report model project. Instead create a report project, add a new report, and create a report data source which uses the same connection settings as the cube data source.
-Albert
|||Can you tell me how to open up the report manager?|||http://<your server name>/reports|||It doesn't work for http://localhsot/reportssql
No comments:
Post a Comment