Monthly Archives: June 2010

Extracting Long Description using Command Manager


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy

About two weeks ago!

Received an SOS email from Kiran asking the method to extract the Long Description of Metrics using Command Manager. Not worked on CM much other than some bulk generation of attributes/facts, in past. Search on knowledge base and found the cause. There are predefined CM scripts that would let us do 80% of things that Command Manager can do, but rest 20% (the real gem) is not made available through scripts, but the documentation is available. Make sense as CM is not a widely used tool (though it is very powerful) and its uses are very limited.

Anyways, the script to populate Long Description would be as follows:

GET PROPERTIES (property1, property2, … , propertyN) FROM METRIC “<object_name>” IN FOLDER “<location_path>” FOR PROJECT “<project_name>”

Property Number List

  1. NAME
  2. ID
  3. DESCRIPTION
  4. LOCATION
  5. CREATIONTIME
  6. MODIFICATIONTIME
  7. OWNER
  8. LONGDESCRIPTION
  9. HIDDEN

I couldn’t check the following when I worked on MicroStrategy 9 but as per my friend, Command Manager is integrated with MicroStrategy Web. OR let me put other way, it is very easy to generate the CM manager scripts using MicroStrategy Web SDK, otherwise people would have had to generate/code the Meta data code/SQL. This will make a lot of work related to SDK a lot easy to be integrated into Web as we can make a CM scripts to be executed instead of writing a lenghty code to be executed. Stay tuned, I’m expecting this integration somewhere in Sept and will post about it then.

Field Report


Deprecated: Function get_magic_quotes_gpc() is deprecated in /home1/microoat/public_html/blog/wp-includes/formatting.php on line 3964
MicroStrategy 9,

Last week I’ve attended a Free BI Class organized by MicroStrategy in Toronto, to see what’s new.

The presentation was really well planned – a mix of the usual sales pitch and a nice hands on web and desktop exercises.
Some new (at least to me) things that they’ve been working on are a great looking app for iPhone and some new geographic widgets, so heads up BigDataLabs. The app comes as no surprise, now that Apple no longer supports Flash. It takes advantage of the iPhone controls, including the G-sensor.

As a side note, there was a SAS training on the same floor as the Free BI Class, and the participants seemed to have a lot of fun in there, judging by their laughter. Our MSTR sales guy came with an awesome explanation – “Probably someone said it can be deployed in three months” :)