Business Analytics - permission role problem

buchhot

Hi NAV-Pro's!

We use Business Analytics BASIC with NAV 5.0 and SQL-Server 2000 / 2005 in several sister companies.
The system is running and I also have permission defined via SQL-Server Analysis Manager.
It works so far, but everytime I change anything in a cube, the configurator completely deletes the BA database and reates it from scratch, so also the permissions which I defined in the SQL-Server Analysis Manager are gone too.

It can't be that I always have to again define pretty complex security restrictions when I am changing a thing or two in the cubes???

Anyone got a solution to this?
As far as I know I cannot assign security for BA directly in NAV??

Many thanks in advance.

kine

I do not know, but if the security permissions can be scripted, than you can create script which will recreate the permissions and settings. But as I wrote, I have no knowledge right now about that...

buchhot

Hi kine!

Thanks for you reply, I also thought about that but also am not having very deep knowledge about sql server analysis services. Seems that I have to get my knowledge strengthened about this topic but noone that I asked so far could help me out when it comes to business analytics.

Thanks anyway.

If anybody knows a wuick solution sto this I would appreciate this, when I find a solution I will post it too.

kine

I have found this article, may be it will help you how to script the permissions... please, give us the feedback, if you will solve the problem...

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