Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Connect to SSAS Cubes from MOSS using Excel 2007

  Asked By: Guy    Date: Dec 18    Category: MOSS    Views: 1705

In our Project we need to connect to a SSAS cube from MOSS. We tried using excel 2007 but unless the user is having access to the SSAS instance this is not working. That approach is not preferred as the user will be able to manipulate the cubes through Management Studio if he is having access to the cubes. Is there any other method by which we can connect to the cubes from sharepoint? Can anyone advice?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Josie Barron     Answered On: Dec 18

That's right. And the great thing about using SSAS roles is that it won't matter which vehicle your users are employing to view the data, they will only see data they have rights to see. Ie. It doesn't matter whether they are using Reporting Services, Excel Services, Excel, or PerformancePoint; each user will only see the data they are allowed to see.

A spin-off from this is that you can create one report (doesn't matter whether it is Reporting Services, Excel Services, Excel, PerformancePoint etc.) and when a users asks for that report, they will only see the data they have access to. For example, this means you can create one 'Weekly Sales Report' and each regional office that asks for exactly that report, will only get data for their region/office. And head office can ask for the same report and they will see sales for the entire organisation. This makes report creation/management much much simpler.

 
Didn't find what you were looking for? Find more on Connect to SSAS Cubes from MOSS using Excel 2007 Or get search suggestion and latest updates.




Tagged: