InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 12:38:13 GMT20http://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxyup.. 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 usersall part of the magicTue, 13 Nov 2012 11:39:12 GMTboxtahttp://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxYes, 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.Fri, 09 Nov 2012 04:38:40 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxWould 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..Fri, 09 Nov 2012 04:04:22 GMTblom0344http://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxSSAS 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.Fri, 09 Nov 2012 03:55:16 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxSuppose we do not have a sharepoint server to work with. Is there any alternative to access the cube data from within Excel?Fri, 09 Nov 2012 02:13:45 GMTblom0344http://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxHi,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.IainMon, 22 Oct 2012 04:09:19 GMTiain.cowdenhttp://www.sqlservercentral.com/Forums/Topic1359050-17-1.aspxAm 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?Thu, 13 Sep 2012 23:44:40 GMTSaravanan_tvr