Day 6 of The OLAP Sprint

Question

Day 6 of The OLAP Sprint

Simon E Doubt

SSCarpal Tunnel

Points: 4191
More actions
November 14, 2012 at 9:17 pm

#265430

Comments posted to this topic are about the item Day 6 of The OLAP Sprint

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ken SSCoach Points: 17191 More actions · Answer 1

Nice post on SSAS security. That is a part of SSAS (and most products for that matter) that is not reviewed enough in my opinion.

I have used many of the same methods that you are using to define roles except I am doing it in a production environment and using actual AD account names versus local Windows user names. Downside there is that I cannot create roles based on groups unless I create a Windows group and put the AD accounts in there or there is an AD group with the users in it already that I can then use in my role. Where there is a will there is a way!

Have you tried using perspectives in SSAS as well? Also, did you attend any sessions on SSAS partitions and aggregations?

Simon E Doubt SSCarpal Tunnel Points: 4191 More actions · Answer 2

KWymore (11/15/2012)
Nice post on SSAS security. That is a part of SSAS (and most products for that matter) that is not reviewed enough in my opinion.
I have used many of the same methods that you are using to define roles except I am doing it in a production environment and using actual AD account names versus local Windows user names. Downside there is that I cannot create roles based on groups unless I create a Windows group and put the AD accounts in there or there is an AD group with the users in it already that I can then use in my role. Where there is a will there is a way!
Have you tried using perspectives in SSAS as well? Also, did you attend any sessions on SSAS partitions and aggregations?

I haven't had the chance to experiment with perspectives yet, but am definitely keen. Same for partitions and aggregations - I was in some sessions where they covered them (both of the full day pre-conference seminars - Brian and Devin Knight, and Pete Myers), but haven't jumped in just yet. Right now I'm in the process of migrating my prototype onto a dev box on our network, so I can schedule some show-and-tells!

Ken SSCoach Points: 17191 More actions · Answer 3

Excellent. Think you will continue posting your findings or was the blog just for this sprint?

Simon E Doubt SSCarpal Tunnel Points: 4191 More actions · Answer 4

KWymore (11/15/2012)
Excellent. Think you will continue posting your findings or was the blog just for this sprint?

I'd definitely like to continue in some capacity. Hopefully there is executive sponsorship for the project in house and I can move forward.