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 |