Business-Intelligence-MicroStrategy-CommandManager

 view release on metacpan or  search on metacpan

lib/Business/Intelligence/MicroStrategy/CommandManager.pm  view on Meta::CPAN

);

Following is how to create different types of custom groups using expression text.
Notes:
[] are used to define a name of an object; the name can include the full path to the object.
^ is used as the escape character to specify a string constant inside an expression.
{} are used to indicate a pair of join element list qualification.
When it comes to ambiguous objects within an expression, there are two ways to solve it:
	a. To specify the object with its full path
	b. Place all of the ambiguous objects in a single folder and specify this folder in the command using the BREAKAMBIGUITY reserved word.
When specifying the percentage value using Rank<ByValue=False>, please specify a fraction value between 0 and 1 that corresponds to the percentage value. For example, forty percent (40%) should be specified as 0.4.
Examples of different qualitications:
1. Attribute qualification:
	[\Schema Objects\Attributes\Time\Year]@ID IN ("2003, 2004")
	[\Schema Objects\Attributes\Time\Year]@ID =2003
	[\Schema Objects\Attributes\Products\Category]@DESC IN ("Books", "Movies", "Music", "Electronics")
2. Set Qualification
	For Metric Qualifications, you need to specify the output level at which this metric is calculated.
	Three types of functions: 
		Metric Values: [\Public Objects\Metrics\Sales Metrics\Profit] >= 10
		Bottom Rank: Rank([\Public Objects\Metrics\Sales Metrics\Profit]) <=  3
		Top Rank: Rank<ASC=False>([Revenue Contribution to All Products Abs.]) <= 5
		Percent: Rank<ByValue=False>([\Public Objects\Metrics\Sales Metrics\Profit]) <= 0.1
	*Note for Rank function: There are two parameters that control its behavior. ASC and ByValue.
			         When ASC is set to true, the ranking results are sorted in ascending order; when its value is set to false, the ranking results are sorted in descending order.
			         When ByValue is set to true, the ranking results represent their value order; whereas, when ByValue is set to false, the ranking results represent their percentage order.
3. Shortcut to a Report Qualification
	Just specify the report name:
	[Revenue vs. Forecast] or
	[\Public Objects\Reports\Revenue vs. Forecast]
4. Shortcut to a Filter
	Just specify the filter name:
	[Top 5 Customers by Revenue]
	([\Public Objects\Filters\Top 5 Customers by Revenue])
5. Banding Qualification
	You need to specify the output level. In addition, you may want to specify the band names. 

lib/Business/Intelligence/MicroStrategy/CommandManager.pm  view on Meta::CPAN

        MAXNOJOBS                => "number_of_jobs",
        MAXNOCLIENTCONNS         => "number_of_client_conns",
        IDLETIME                 => "number_of_seconds",
        WEBIDLETIME              => "number_of_seconds",
        MAXNOXMLCELLS            => "number_of_xml_cells",
        MAXNOXMLDRILLPATHS       => "number_of_xml_drill_paths",
        MAXMEMXML                => "number_MBytes",
        MAXMEMPDF                => "number_MBytes",
        MAXMEMEXCEL              => "number_MBytes",
        ENABLEWEBTHROTTLING      => "TRUE" | "FALSE",
        MAXMEMUSAGE              => "percentage",
        MINFREEMEM               => "percentage",
        ENABLEMEMALLOC           => "TRUE" | "FALSE",
        MAXALLOCSIZE             => "number_MBytes",
        ENABLEMEMCONTRACT        => "TRUE" | "FALSE",
        MINRESERVEDMEM           => "NUMBER_MBYTES",
        MINRESERVEDMEMPERCENTAGE => "PERCENTAGE",
        MAXVIRTUALADDRSPACE      => "percentage",
        MEMIDLETIME              => "seconds",
        WORKSETDIR               => "folder_path",
        MAXRAMWORKSET            => "number_KBytes"
    );

Optional parameters: ALL PARAMETERS ARE OPTIONAL.

ALTER SERVER CONFIGURATION 
	[DESCRIPTION "<description>"] 
	[MAXCONNECTIONTHREADS <number_of_threads>] 

lib/Business/Intelligence/MicroStrategy/CommandManager.pm  view on Meta::CPAN

	[MAXNOJOBS <number_of_jobs>] 
	[MAXNOCLIENTCONNS <number_of_client_conns>] 
	[IDLETIME <number_of_seconds>] 
	[WEBIDLETIME <number_of_seconds>] 
	[MAXNOXMLCELLS <number_of_xml_cells>] 
	[MAXNOXMLDRILLPATHS <number_of_xml_drill_paths>] 
	[MAXMEMXML number_MBytes] 
	[MAXMEMPDF number_MBytes] 
	[MAXMEMEXCEL number_MBytes] 
	[ENABLEWEBTHROTTLING (TRUE | FALSE)] 
	[MAXMEMUSAGE <percentage>] 
	[MINFREEMEM <percentage>] 
	[ENABLEMEMALLOC (TRUE | FALSE)] 
	[MAXALLOCSIZE <number_MBytes>] 
	[ENABLEMEMCONTRACT (TRUE | FALSE)] 
	[(MINRESERVEDMEM <number_MBytes> | MINRESERVEDMEMPERCENTAGE <percentage>)] 
	[MAXVIRTUALADDRSPACE <percentage>] 
	[MEMIDLETIME <seconds>] 
	[WORKSETDIR "<folder_path>"] 
	[MAXRAMWORKSET <number_KBytes>];

ALTER SERVER CONFIGURATION MAXCONNECTIONTHREADS 5 BACKUPFREQ 0 USEPERFORMANCEMON TRUE USEMSTRSCHEDULER TRUE BALSERVERTHREADS FALSE HISTORYDIR ".\INBOX\dsmith" MAXNOMESSAGES 10 MAXNOJOBS 10000 MAXNOCLIENTCONNS 500 WEBIDLETIME 0 MAXNOXMLCELLS 500000 MA...

=cut

sub alter_server_config {
my $self = shift;

lib/Business/Intelligence/MicroStrategy/CommandManager.pm  view on Meta::CPAN

Following is how to create different types of custom groups using expression text.
Notes:
[] are used to define a name of an object; the name can include the full path to the object.
^ is used as the escape character to specify a string constant inside an expression.
{} are used to indicate a pair of join element list qualification.
When it comes to ambiguous objects within an expression, there are two ways to solve it:
	a. To specify the object with its full path
	b. Place all of the ambiguous objects in a single folder and specify this folder in the command using the BREAKAMBIGUITY reserved word.
When specifying the percentage value using Rank<ByValue=False>, please specify a fraction value between 0 and 1 that corresponds to the percentage value. For example, forty percent (40%) should be specified as 0.4.
Examples of different qualitications:
1. Attribute qualification:
	[\Schema Objects\Attributes\Time\Year]@ID IN ("2003, 2004")
	[\Schema Objects\Attributes\Time\Year]@ID =2003
	[\Schema Objects\Attributes\Products\Category]@DESC IN ("Books", "Movies", "Music", "Electronics")
2. Set Qualification
	For Metric Qualifications, you need to specify the output level at which this metric is calculated.
	Three types of functions: 
		Metric Values: [\Public Objects\Metrics\Sales Metrics\Profit] >= 10
		Bottom Rank: Rank([\Public Objects\Metrics\Sales Metrics\Profit]) <=  3
		Top Rank: Rank<ASC=False>([Revenue Contribution to All Products Abs.]) <= 5
		Percent: Rank<ByValue=False>([\Public Objects\Metrics\Sales Metrics\Profit]) <= 0.1
	*Note for Rank function: There are two parameters that control its behavior. ASC and ByValue.
			         When ASC is set to true, the ranking results are sorted in ascending order; when its value is set to false, the ranking results are sorted in descending order.
			         When ByValue is set to true, the ranking results represent their value order; whereas, when ByValue is set to false, the ranking results represent their percentage order.
3. Shortcut to a Report Qualification
	Just specify the report name:
	[Revenue vs. Forecast] or
	[\Public Objects\Reports\Revenue vs. Forecast]
4. Shortcut to a Filter
	Just specify the filter name:
	[Top 5 Customers by Revenue]
	([\Public Objects\Filters\Top 5 Customers by Revenue])
5. Banding Qualification
	You need to specify the output level. In addition, you may want to specify the band names.