SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Day 6 of The OLAP Sprint


Day 6 of The OLAP Sprint

Author
Message
Simon E Doubt
Simon E Doubt
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1653 Visits: 895
Comments posted to this topic are about the item Day 6 of The OLAP Sprint
Ken Wymore
Ken Wymore
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7907 Visits: 2418
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
Simon E Doubt
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1653 Visits: 895
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 Wymore
Ken Wymore
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7907 Visits: 2418
Excellent. Think you will continue posting your findings or was the blog just for this sprint?
Simon E Doubt
Simon E Doubt
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1653 Visits: 895
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search