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-Addicted
SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)SSC-Addicted (430 reputation)

Group: General Forum Members
Points: 430 Visits: 1349
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 (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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-Enthusiastic
SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)

Group: General Forum Members
Points: 154 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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27773 Visits: 13268
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-Enthusiastic
SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)SSC-Enthusiastic (154 reputation)

Group: General Forum Members
Points: 154 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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27773 Visits: 13268
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 Journeyman
SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)SSC Journeyman (98 reputation)

Group: General Forum Members
Points: 98 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
SSC-Addicted
SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)

Group: General Forum Members
Points: 497 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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27773 Visits: 13268
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
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2496 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