Sunday, November 18, 2012

Getting started with MicroStrategy...

Hi Guys,


If you are new to MicroStrategy... here is how you can get started. Fist of all you must have the MicroStrategy software installed in your machine. To do so you must get the MicroStrategy software.

First step would be to register in the resource site with your corporate account to get full advantage of MicroStrategy and all its services. You can do so by registering it in the below link.

http://community.microstrategy.com/

Then you need to download the software. There are different version of software but the thing is that you would not get a full package version for free. There are two flavors of MicroStrategy tool where one is totally free but you can use only the reporting module without the administration tools.

Unfortunately from 9.4.1 onwards MicroStrategy provides only a evaluation version for one month as a trial.

To get the full package evaluation version fully operational for 30 days you can follow the below link. The current version of the MicroStrategy Release is 9.5.0s

http://www.microstrategy.com/us/free/developers

You can download and install the software in your machine. Installation steps are quite straight forward as simple as any windows installable.

Sunday, January 29, 2012

Excellent Link to learn MicroStrategy Command Manager...

MicroStrategy Command Manager is an application that automates MicroStrategy administrative tasks, improving TCO by allowing you to reduce workload and increase efficiency.
MicroStrategy Command Manager provides a fast and easy way to perform necessary and repetitive tasks on the MicroStrategy platform. Deployable on Windows®, UNIX®, and Linux® the MicroStrategy Command Manager development console provides an interface rich in functionality and intuitive to use script language. Automated scripts require the least possible amount of human attention, helping you optimize employee time and reduce costs. Scripts can be scheduled to run at specific times, even triggered by third party software to increase the value of all products. Common tasks can be combined into a single procedure, which can affect multiple users and objects, eliminating unnecessary work. Below link provides a good documentation for MicroStrategy Command Manager.

Click here to check the Command Manager Scripts documentation

Command Manager Exploration Part - 1

Hi All,

Here are some of the command manager outlines that are useful for the reference. Copy all these scripts and connect to the command manager and execute the scripts one by one and paralelly check this out in the Developer for better clarity.

/* Folder Outlines*/

CREATE FOLDER "Test1" IN "\Public Objects\Reports" DESCRIPTION "Test Folder Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test2" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test3" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

ALTER FOLDER "Test3" IN "\Public Objects\REPORTS\Test1" NAME "Test4" DESCRIPTION "Test FOLDER Created by Reginold _ Edited" LONGDESCRIPTION "Just a learning curve"  HIDDEN  FALSE LOCATION "\Public Objects\REPORTS\Test1" FOR PROJECT "Customer Analysis Module";

LIST ALL PROPERTIES FOR FOLDER "Test1" IN "\Public Objects\REPORTS" FOR PROJECT "Customer Analysis Module";

LIST ALL FOLDERS IN "\Public Objects\REPORTS\Test1" FOR PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer DESC Filter" IN FOLDER  "\Public Objects\REPORTS\Test1\Test4" EXPRESSION "Customer@DESC in (^"Carole Vorndran^",^"Melanie Searles^",^"Monica Neptune^")" DESCRIPTION "FILTER Creation script WITH DESCRIPTION Column" LONGDESCRIPTION "This is my SECOND FILTER creation script" HIDDEN FALSE ON PROJECT  "Customer Analysis Module";

REMOVE FOLDER CONTENT  "\Public Objects\REPORTS\Test1\Test2" IN "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT "Customer Analysis Module";
REMOVE FOLDER CONTENT CASCADE "\Public Objects\REPORTS\Test1\Test4" IN "\Public Objects\REPORTS\Test1\Test4" FROM PROJECT "Customer Analysis Module";
DELETE FILTER  "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" FROM PROJECT  "Customer Analysis Module";

DELETE FOLDER "Test1" IN "\Public Objects\REPORTS" FROM PROJECT "Customer Analysis Module";

/* Filter Outlines*/

CREATE FOLDER "Test1" IN "\Public Objects\Reports" DESCRIPTION "Test Folder Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FOLDER "Test2" IN "\Public Objects\REPORTS\Test1" DESCRIPTION "Test FOLDER Created by Reginold" LONGDESCRIPTION "Just a learning Curve" HIDDEN FALSE FOR PROJECT "Customer Analysis Module";

CREATE FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer ID FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@ID in(1,2,3,4)" DESCRIPTION "Filter Creation Script with ID column" LONGDESCRIPTION "My First Filter Creation Script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

CREATE FILTER "Customer DESC Filter" IN FOLDER  "\Public Objects\REPORTS\Test1\Test2" EXPRESSION "Customer@DESC in (^"Carole Vorndran^",^"Melanie Searles^",^"Monica Neptune^")" DESCRIPTION "FILTER Creation script WITH DESCRIPTION Column" LONGDESCRIPTION "This is my SECOND FILTER creation script" HIDDEN FALSE ON PROJECT  "Customer Analysis Module";

ALTER FILTER "Customer FILTER" IN FOLDER "\Public Objects\REPORTS\Test1" NAME "Customer FILTER _ Edited" EXPRESSION "Customer@ID in(1,2)" DESCRIPTION "First Alter Filter Scripts" LONGDESCRIPTION "Just a Editing script" HIDDEN FALSE ON PROJECT "Customer Analysis Module";

LIST ALL PROPERTIES FOR FILTER "Customer ID FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT "Customer Analysis Module";

LIST ALL FILTERS IN  FOLDER "\Public Objects\REPORTS\Test1" FOR OWNER "Administrator" FOR PROJECT "Customer Analysis Module";

LIST ALL FILTERS IN  FOLDER "\Public Objects\REPORTS\Test1\Test2" FOR OWNER "Administrator" FOR PROJECT "Customer Analysis Module";

DELETE FILTER "Customer DESC FILTER" IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT  "Customer Analysis Module";

DELETE FILTER  "Customer ID FILTER"  IN FOLDER "\Public Objects\REPORTS\Test1\Test2" FROM PROJECT  "Customer Analysis Module";

DELETE FILTER "Customer FILTER _ Edited" IN FOLDER "\Public Objects\REPORTS\Test1" FROM PROJECT  "Customer Analysis Module";

DELETE FOLDER "Test1" IN  "\Public Objects\REPORTS" FROM PROJECT "Customer Analysis Module";

/* User Outlines*/

CREATE USER "remanty" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;
CREATE USER GROUP "USER GROUP Test" DESCRIPTION "My FIRST USER GROUP" LONGDESCRIPTION "Just a learning curve"  MEMBERS "remanty";

CREATE USER "freemonty" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER IN GROUP "User Group Test";

CREATE USER "testuser" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;

ADD USER "testuser" TO GROUP "User Group Test";

CREATE USER GROUP "ALTER USER GROUP" DESCRIPTION "ALTER USER GROUP" LONGDESCRIPTION "USER GROUP FOR the freemonty";

ALTER USER "testuser" NAME "freemonty_reginold" PASSWORD "password"
FULLNAME "Monty Panesar" DESCRIPTION "login for Monty" LONGDESCRIPTION "Edited by reginold"
ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE
PASSWORDEXP NEVER
ENABLED IN GROUP "Alter User Group";


REMOVE USER " freemonty_reginold" FROM GROUP "USER GROUP Test";

LIST ALL PROPERTIES FOR USER "freemonty_reginold";

LIST ALL PROPERTIES FOR USER "freemonty";

LIST ALL PROPERTIES FOR USER "remanty";

LIST ALL PROPERTIES FOR USERS IN GROUP "User Group Test";

LIST ALL PROPERTIES FOR USERS IN GROUP "ALTER USER GROUP";

ALTER USERS IN USER GROUP "User Group Test" PASSWORD "password_1" DESCRIPTION "Changed the Password to password_1" LONGDESCRIPTION "Password change done on user request" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE
CHANGEPWD TRUE PASSWORDEXP IN 365 DAYS PASSWORDEXPFREQ 15 DAYS ENABLED GROUP "User Group Test";


LIST ALL PROPERTIES FOR USERS IN GROUP "User Group Test";

LIST INHERITED PRIVILEGES FOR USER "remanty";

LIST ALL PRIVILEGES FOR USER "remanty";

LIST GRANTED PRIVILEGES FOR USER "remanty";

DELETE USER GROUP "User Group Test";

DELETE USER GROUP "Alter User Group";

DELETE USER "remanty";

DELETE USER "freemonty";

DELETE USER "freemonty_reginold";

/* User Group Outlines*/

CREATE USER GROUP "USER GROUP PARENT" DESCRIPTION "USER GROUP parent" LONGDESCRIPTION "Just a learning curve";

CREATE USER GROUP "USER GROUP PARENT2" DESCRIPTION "USER GROUP parent" LONGDESCRIPTION "Just a learning curve";

CREATE USER GROUP "USER GROUP REGINOLD" DESCRIPTION "user group child" LONGDESCRIPTION "user group child" IN GROUP "USER GROUP PARENT";

CREATE USER GROUP "ALTER USER GROUP" DESCRIPTION "ALTER USER GROUP" LONGDESCRIPTION "USER GROUP FOR the Alter group command";

CREATE USER "Reginold" FULLNAME "Reginold Mano Antony" DESCRIPTION "Created by Reginold password" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "password" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER IN GROUP "USER GROUP REGINOLD";

CREATE USER "Feisal" FULLNAME "Mohammed Feisal" DESCRIPTION "Created by Reginold PASSWORD" LONGDESCRIPTION "Just a Learning Curve" PASSWORD "PASSWORD" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD TRUE PASSWORDEXP NEVER;

ADD USER "Feisal" TO GROUP "user group REGINOLD";

REMOVE USER "Feisal" FROM GROUP  "user group REGINOLD";

ADD USER "Feisal" TO GROUP "ALTER USER GROUP";

ALTER USER GROUP "USER GROUP REGINOLD" NAME "USER GROUP REGINOLD" DESCRIPTION "Alter group practice" LONGDESCRIPTION "Alter group practice Reginold" GROUP "USER GROUP PARENT2";

LIST MEMBERS FOR USER GROUP "USER GROUP REGINOLD";

LIST ALL PROPERTIES FOR USER GROUP "USER GROUP PARENT";

LIST USER GROUPS;

LIST USER GROUPS;

LIST ALL PRIVILEGES FOR USER GROUP "USER GROUP PARENT2";

REMOVE USER GROUP "USER GROUP REGINOLD" FROM GROUP "USER GROUP PARENT2";

DELETE USER GROUP "USER GROUP PARENT2";

DELETE USER GROUP "USER GROUP PARENT";

DELETE USER "Reginold";

DELETE USER "Feisal";

DELETE USER GROUP "user group reginold";

DELETE USER GROUP "alter user group";

/* User Profile Outlines*/

CREATE USER GROUP "Reginold CAM" DESCRIPTION "Reginold's User Group" LONGDESCRIPTION "Specifically for Reginold.";

CREATE USER  "reginolda" FULLNAME "Reginold Mano Antony" DESCRIPTION "login specifically designed for Reginold" LONGDESCRIPTION "password is blank" PASSWORD "" ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER ENABLED IN GROUP "Reginold CAM";

CREATE USER  "delete" FULLNAME "Reginold Mano Antony" DESCRIPTION "login specifically designed for Reginold" LONGDESCRIPTION "password is blank" PASSWORD "" ALLOWCHANGEPWD FALSE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER ENABLED IN GROUP "Reginold CAM";

CREATE USER PROFILE FOR USER "reginolda" IN FOLDER "\Profiles" FOR PROJECT "Customer Analysis Module";

CREATE USER PROFILE FOR USER "delete" IN FOLDER "\Profiles" FOR PROJECT "Customer Analysis Module";

LIST PROFILES FOR USER "reginolda" FOR PROJECT "Customer Analysis Module";
DELETE USER PROFILE "delete" FROM PROJECT "Customer Analysis Module";

/* Update Schema Outline*/

UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "Customer Analysis Module";

/*Server Outlines*/

LIST ALL SERVERS;

LIST ALL PROPERTIES FOR SERVER "REGINOLDA-PC" PORT 34952 LOGIN "administrator" PASSWORD "";

STOP SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";

START SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";

RESTART SERVER IN "REGINOLDA-PC" PORT 34952 LOGIN "Administrator" PASSWORD "";