SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Saravanan_tvr
Saravanan_tvr
SSC Eights!
SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)SSC Eights! (860 reputation)

Group: General Forum Members
Points: 860 Visits: 1354
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”
iain.cowden
iain.cowden
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 60
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
blom0344
blom0344
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 330
Suppose we do not have a sharepoint server to work with. Is there any alternative to access the cube data from within Excel?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59441 Visits: 13297
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
blom0344
blom0344
SSC-Addicted
SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)SSC-Addicted (426 reputation)

Group: General Forum Members
Points: 426 Visits: 330
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..
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59441 Visits: 13297
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
boxta
boxta
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 238
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
sunny.tjk
sunny.tjk
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1009 Visits: 1344
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?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)SSC Guru (59K reputation)

Group: General Forum Members
Points: 59441 Visits: 13297
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
sneumersky
sneumersky
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3118 Visits: 487
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search