Pages

Friday, August 31, 2012

MicroStrategy Command Manager Stored procedure

//stored procedure to update project configuration.


 String updateProjectCache="";

String connectQuery= ("CONNECT SERVER \"" +
 server + "\" USER \"" + user + "\" PASSWORD \"" + password + "\" PORT 34952;");

execute(connectQuery);

ResultSet projectRS = executeCapture("LIST PROJECTS;" );

 projectRS.moveFirst();

while (!projectRS.isEof() )
{
printOut("Applying Evolv Project Configuration On Project" +                projectRS.getFieldValueString(DisplayPropertyEnum.NAME));
 if (projectRS.getFieldValueString(2).equals("Loaded"))
{
updateProjectCache="ALTER PROJECT CONFIGURATION " + "MAXNOREPORTRESULTROWS 100000 " +
"MAXNOELEMROWS 100000 " + "MAXNOINTRESULTROWS 100000 " +
 "MAXJOBSUSERACCT 1000 " +
 "MAXJOBSUSERSESSION 1000 " +
 "MAXEXECJOBSUSER 1000 " +
"MAXJOBSPROJECT 1000 " +
 "MAXUSERSESSIONSPROJECT 500 " +
 "IN PROJECT \"" +
 projectRS.getFieldValueString(DisplayPropertyEnum.NAME) + "\"; "; execute(updateProjectCache);
}
 projectRS.moveNext();
 }//end of project
execute("DISCONNECT SERVER;");

No comments: