How to avoid changing the Excel connection string for SSAS Role
I have implemented the Dynamic Security in our BI-SSAS Projekt using a User-Dimension that is updated from Active Directory. I created SSAS-Roles and inside I restrict the users to see only the specified branches.
As Front-End they are using Excel. The problem is that Excel does not use as default the SSAS-Role created so I need to modify the conection string and add the following Property:Extended Properties="Role=PowerUsers" .
How can we use the role created without having to edit the conection string from excel ? Could be this Excel connection string property added as default?
Why doesn't Excel use the right role if you remove Roles= from the connection string? Is the user in question an SSAS admin? Are you 100% sure? If you connect Profiler to SSAS and watch while that user connects it should list the roles the user belongs to. If the roles say *,PowerUsers,Readers then the asterisk means the user is an admin. If you remove him as an admin you won't need to specify Roles on the connection string.
You might also install BIDS Helper and run the Roles Report on your cube. It will expand the security groups in case that user is in a group you weren't aware of.
- What is the equivalent of the "Days" function or number of days between 2 dates in excel 2007?
- How to find and replace with regex in excel
- How to change font color for specific line (row) of Textbox
- How to embed a SVG into a Cell using Aspose.Cells
- How to change Font Color of Dates without changing color of other text or background using VBA for Excel
- Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
- Deleting duplicate header rows
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Overwrite Excel 2016 worksheet data with data from CSV file
- Laravel validator and excel files error
- Need help aligning a table to a column based on similar values in one table field
- Index rows and columns unexpected results
- Ascii Art using VBA
- How to obtain the full-path names of files read with WorkbookConnections
- How can export all part of columns to pdf file with VBA code?
- Difficult to run
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- Export Charts from Excel as images using Python
- Converting 32-bit xll Excel add-in to 64 bit: LNK1561 error
- Changing the Date Format for GROUPED dates in a PIVOT TABLE
- VBA Filter Column Store Unique Values of Another Column
- How do I use checkboxes in an IF-THEN statement in Excel VBA 2010?
- Automatic numbering in Excel with hierarchy
- convert a C# datetime object into Excel date format
- Excel Find and replace using variables
- How to do a row-wise sum in an array formula in Excel?
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- how to use inequality filter in pivotby formula on aggregated values, not table data
- Excel XML Source pane does not have button to add an XML map