Forum Discussion
Global Datasets and Datasources
I'm not using SQL Analysis Services. I wonder if I need to in order to accomplish my goals? My source is claiming that there is some sort of single sign on capability that would pass through to Azure...haven't seen it yet.
My advice would be to implement Analysis Services. If you already have a power pivot model, it can be imported into Analys Services in under a minute. You do need an instance of SQL Server Analysis Services to deploy it on though.
Ultimately, Analysis Services is the way to go.
"Ultimately, Analysis Services is the way to go."
Argh. My role is data architect and I'm designing the warehouse. I didn't anticipate having to get up to speed on the BI side of things. There's more to it than I expected.
BTW, I don't actually need the environment to support row level security....I can implement that myself in a View, for instance, although I do need appropriate user identity.
Well, one could argue that data warehouse is not complete without a semantic model, which is what Analysis Services is. Your end users will most likely need data enhanced with calculations (Variance, Year to Date, etc.) so it is always good to think of it as a complete solution and not just data alone.
I would need to test it but I believe that identity is not passed to SQL Server databases (Azure or not), only to Analysis Services.
I probably need to educate myself on what Analysis Service provides; perhaps it would make it easier for end users to understand and use the data, which has been a concern.
Thanks for your input.