Hi,

I am trying to implement 'Security Fact Table ' approach in SQL Server
2000 / AS 2000.& SP4

I need to do implement 'security fact table approach ' as a pilot /
proof of concept to show that it works.

I found the following article useful and followed exactly the same
steps as described in the

http://www.mosha.com/msolap/samples/...20security.zip

http://www.mosha.com/msolap/samples/...20security.zip


I am getting errors in the following MDX script as shown in the
attachment. (the same problem with Microsoft support solution too ...)

I have followed exactly the same steps described in the above download
131 Dynamic Security dwickert Script.doc document (Technique #2
Security Cube: Page 6 ).

I also tried the Microsoft Support webcast

http://support.microsoft.com/kb/828343

but the problem is same. AS 2000 is not allowing my MDX query to save .
There is a syntax error.

that reads ....error occurred while processing security for the cube
........

Please help.

Thanks

Bhanukiran.K