Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oepirobo
Starting Member
36 Posts |
 Posted - 2005-03-29 : 14:13:16
|
| I've seen that Analysis Services only handles Widnows security, this means that all my users need to have distinct accounts in a windows domain so I can filter the cube data accordingly. If I work like this then my clients can use the PivotTable utilities they like so much in Excel.Now I have a cube that I must expose through a website and this website only uses forms authentication. Windows security is a no no for my client so it's not an option. I told them that if there's no windows security then there can't be any PivotTable functionality and they seem to be OK with this.Now that we have the background here comes my question: If I decide to use Reporting Services to show the cube data I will have to use MDX. Do these MDX queries limit the data that my user will see or do they bring all the data allowed for the impersonated user and simply create a predefined initial way of viewing the data? |
|
|
|
|
|
MDX Queries