dbTalk Databases Forums  

Dynamic Dimension Security

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Dynamic Dimension Security in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hari
 
Posts: n/a

Default Dynamic Dimension Security - 06-20-2006 , 12:12 AM






Hi
i am facing with some problem in implementing dynamic dimension security in
SSAS 2005. I had created a assembly which accepts a userid and returns the
filtered set of members for that user. i had deployed this assembly in SSAS.
Now when i try to browse the cube it is giving me the filtered set as
expected. Now i change the data in the database adding new members and
removing some members for a given user but when browsing the cube data, it is
still showing me the old security not the new one which i had changed. I
tried executing an MDX calling the assembly function then it is showing the
latest changes. I suspect there is come data caching happening at the server
level. But i am not sure how to resolve this.Please help me on this.

Regards
Hari

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.