September 13, 2012 at 11:44 pm
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?
October 22, 2012 at 4:09 am
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
November 9, 2012 at 2:13 am
Suppose we do not have a sharepoint server to work with. Is there any alternative to access the cube data from within Excel?
November 9, 2012 at 3:55 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 9, 2012 at 4:04 am
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..
November 9, 2012 at 4:38 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 13, 2012 at 11:39 am
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
February 7, 2014 at 10:26 am
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?
February 9, 2014 at 9:57 am
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 13, 2014 at 12:32 pm
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.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply