Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to give the customer to access SSAS Cube's? Expand / Collapse
Author
Message
Posted Thursday, September 13, 2012 11:44 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, March 30, 2014 9:34 PM
Points: 277, Visits: 1,179
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
Posted Monday, October 22, 2012 4:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 4:46 AM
Points: 6, Visits: 37
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
Posted Friday, November 09, 2012 2:13 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:12 PM
Points: 72, Visits: 326
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
Posted Friday, November 09, 2012 3:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
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
Posted Friday, November 09, 2012 4:04 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 24, 2013 12:12 PM
Points: 72, Visits: 326
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
Posted Friday, November 09, 2012 4:38 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
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
Posted Tuesday, November 13, 2012 11:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:30 PM
Points: 46, Visits: 234
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
Posted Friday, February 07, 2014 10:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 6:02 PM
Points: 296, Visits: 1,059
Koen Verbeeck (11/9/2012)
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.


Is there a way to give access to sql authenticated accounts?
Post #1539285
Posted Sunday, February 09, 2014 9:57 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 12,206, Visits: 9,168
No. SSAS works with Windows Authentication.
I'm not 100% sure, but I believe there's a work around where you create local users on the server with the same usernames as your users.
As just the names are passed, it might work. Something worth checking out.




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 #1539578
Posted Thursday, February 13, 2014 12:32 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486


You can use basic or anonymous authentication, but it requires you to configure SSAS for HTTP access, along with providing a windows user for the customer. For anon authentication, windows uses IUSR_GUEST by default or an application pool identity.

Here is how to configure HTTP on IIS 7.0:

http://technet.microsoft.com/en-us/library/gg492140.aspx

Here is everything you ever wanted to know about BI Authentication across all levels of the of the Microsoft BI Continuum:

http://msdn.microsoft.com/en-us/library/dn186184.aspx

Unless you REALLY MUST do any of this, I would go with Koen's suggestion of using traditional SSAS Role grants attached to windows groups.
Post #1541382
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse