Pages

Monday, April 8, 2013

MicroStrategy Command manager scripts

Create User:
CREATE USER "xxx"     PASSWORD "" FULLNAME "xxxx"     PASSWORDEXP NEVER;

Create Group:
CREATE USER GROUP "xxx_group" IN GROUP "MicroStrategy Groups";
ALTER USER GROUP "xxx_group" GROUP "";

Add User In group:
ADD USER "xxx"                TO GROUP "xxx_group";

Create Security Filter:
CREATE SECURITY FILTER "xxxx" IN PROJECT "project" EXPRESSION  "category@ID=27";


No comments: