Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-07-13 : 06:52:49
|
| Hi i've developed my ssas cube and i can view it in the designer view but how do i go about deploying it so the end user can see it. Is it deployed to the report services server. anyone got any links they can send me on this.Am a bit confused as to how the end user part works |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 14:13:39
|
| you need to deploy it to analysis server. assuming you've one installed on your sql instance, you can deploy the cube by setting the deployment path to your analysis server in project properties , then right clicking on project and selecting deploy. it might take some time depending on data and amount of aggregations involved. once this is done connect to analysis service engine of your databse using sql management studio and then expand object browser to see your cube. right click and select browse to open cude browser where you can drag and drop dimensions as well as measure and do cube analysis. |
 |
|
|
|
|
|
Viewing SSAA cube