Donnerstag, 9. August 2012 16:35
Hi. The way it was explained to me, there will be two ways for my olap data to be accessible to power view. One by exporting it to a tabular mode database and then plumbing that db as a datasource to powerview. Or two by making a powerPivot data source and plumbing that source as a data source to powerview.
My guess is that the first will not preserve my ssas security logic coding and roles unless I completely duplicate that logic in the tabular mode db.
Assuming individual credentials can be passed to the olap server regardless of number of hops, will the second option preserve my olap security coding and roles?
Donnerstag, 9. August 2012 17:13
Your guess is correct. You can create a tabular model using a multidimensioinal model as a data source but you would need to implement a security model in the SSAS tabuler model.
Donnerstag, 9. August 2012 17:26thx Luis. Does option 2 preserve this kind of security info?
Donnerstag, 9. August 2012 18:15I have am not familiar enough with option 2. I will see if I can try that later on today.