How to give the customer to access SSAS Cube's?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » How to give the customer to access SSAS...

How to give the customer to access SSAS Cube's?

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanan_tvr

Posted Thursday, September 13, 2012 11:44 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Am a beginning stage of SSAS , Based on the sample requirements, I have created the Cubes and dimensions, Now the results are coming in browser, now what mode we are deliver the cubes to Client?

IN SSRS we are deploying and adopting in to Software UI... like that we have anything to SSAS?

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1359050

iain.cowden

Posted Monday, October 22, 2012 4:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 18, 2013 2:57 AM
Points: 6, Visits: 22

Hi,

The most common utilisation of Cubes is to suface data via reporting services (report builder) or via excel. This is then most commonly served to the client via an MS Sharepoint Server, as this can provide a secure audited data connection.

Iain

Post #1375321

blom0344

Posted Friday, November 09, 2012 2:13 AM

Valued Member

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:10 AM
Points: 67, Visits: 316

Suppose we do not have a sharepoint server to work with. Is there any alternative to access the cube data from within Excel?

Post #1382888

Koen Verbeeck

Posted Friday, November 09, 2012 3:55 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

SSAS works with Windows Authentication.
You just need to add a role to the SSAS cube that gives the users (or their groups) read permissions on the cube.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1382931

blom0344

Posted Friday, November 09, 2012 4:04 AM

Valued Member

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:10 AM
Points: 67, Visits: 316

Would that effectively work as a single-sign-on mechanism? We are accustomed to ask our customers to create an AD group , add users to this and allow this group access to our BI products. This works flawlessly with IBM Cognos as we can link the cognos namespace to the required AD domain at a customer site..

Post #1382937

Koen Verbeeck

Posted Friday, November 09, 2012 4:38 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364, Visits: 6,462

Yes, it should work. Create an AD group, add the users and add this group to a SSAS role. Give the role the appropriate permissions.

It's possible that Excel gives a few warnings when connecting to a datasource, but this shouldn't be a big deal.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1382955

boxta

Posted Tuesday, November 13, 2012 11:39 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, March 04, 2013 7:00 PM
Points: 43, Visits: 219

yup.. definitely works with excel...everything is through AD.. just make sure you create a new role and assign appropriate permission to your group or individual users...

the users would not need to re log in at all when they connect to the cube...

you can even limit part of the cube to a sub set of users

all part of the magic

Post #1384222

« Prev Topic | Next Topic »

Permissions