| Author |
Topic |
|
sandesh.ravi
Posting Yak Master
110 Posts |
 Posted - 2011-09-22 : 12:31:49
|
| I am new to SSAS. I have created a SSAS cube and deployed in the server.I just wanted to know how can a user access the cube at the client machine. can it be accessed in web or any other method?Thanks in advance,SandeshThanks,Sandesh |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-22 : 13:28:32
|
| yep. you can open sql management studio chose connection type as ANalysis Services then give your server name where cube is deployed. then expand databases and expand cubes and you should see the deployed cube. you can right click and select browse to open cube in browser.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-09-23 : 04:14:22
|
| In addition to that, How can business users access the cube through their web browser? They would not have sql management studio in their machine. is there a way to access the cube through a link or something?Thanks,Sandesh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-23 : 05:24:10
|
| they can access cube through different browser sofwares like ProClarity,Panorama,Excel or even sql reporting services. Dunno which one your users are using------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-09-23 : 05:51:26
|
| Could you tell me the procedure to access it from SQL reporting service?Thanks,Sandesh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-23 : 05:58:59
|
| you need to create a datasource to connect to your cube (analysis service database. then you need to create a dataset to use a MDX query to retrieve required data from cube . then you can use the fields in dataset in your report by designing containers (table,matrix etc) and assigning dataset fields to textboxes inside them------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-09-23 : 09:05:47
|
| Currently we have a web application for reports. The reports are build in report builder. So is it possible to access the cube data from that application. SO that the users would browse the cube through that web application?Thanks,Sandesh |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-23 : 10:30:45
|
| no idea on that. is it .net application?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sandesh.ravi
Posting Yak Master
110 Posts |
Posted - 2011-09-23 : 11:17:52
|
| Yes. it is vb.net application.Thanks,Sandesh |
|
|
|
|
Accessing SSAS cubes