Category Archives: MicroStrategy

Connect with MicroStrategy 101


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

Best way to connect with bloggers on MicroStrategy 101 would be registration. Rest assured, you are assured 101% privacy. You will not get any spam from me and your information is safe. Currently there are more than 150 registered users. :) To solve your issues/share your ideas you can join the forum too. Unfortunately, currently blog and forum registration are not in sync, and you would need to register separately. I’m working on its integration.

But you can find us on lots of other social networking sites too as follows:

MicroStrategy at linkedin MicroStrategy at twitter MicroStrategy 101 at facebook

Metadata Browser v3.01


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

As promised earlier this year, Senthil Raj – author of the celebrated Object Tracking Tool, has kindly agreed to merge his application with Metadata Browser.

After much coding and testing, time has come to unveil this brand new application, which you will surely find very useful. Click here to download it.

You can also download the manual here.

So, what’s new?

  • Well, there’s obviously the new and more powerful than ever Object Tracker. You can use it both to extract a simple list of objects in your project, and to generate documentation such as format, alias, formula, dimensionality, transformation and condition for metrics; lookup table, forms, child & parent relationships for attributes, etc. It behaves more or less like the Project Documentation Wizard from Desktop, with the huge difference that you can actually run all sorts of analysis on the Excel files generated by Metadata Browser, and you simply can’t do it with the HTML files generated by Desktop.
  • Another upgrade that you requested is the LDAP and NT authentication modes. They are now available at login.
  • Talking about the connection window, Metadata Browser is now capable of reading the most recent username that you have used for a certain project, from the registry. This will make it easier for you to login.

Enjoy!

Few more MicroStrategy interview question


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

Got this from some folder, written long time ago, but forgot to post. Few questions are not complete.

  1. How do you verify the missing data in MSI Web? How do you verify the missing data in Teradata? Difference??
  2. do you know to create subscription in NCS? How will you create a dynamic subscription?
  3. How did you “deploy reports in Pre-prod for UAT”
  4. How did you upgrade to 811 from 801?
  5. End user want to clear cache?
  6. How will you disable access to a user for a particular project?
  7. What’s the use of Scan MD and MD Doctor?
  8. What are Security roles and security filter?
  9. How will you achieve a Transformation like Last YEAR if this information is not sored in the Warehouse?
  10. New Object created and moved?
  11. How did you tune the report as Administrator?
  12. What’s Heterogeneous mapping?
  13. why do you need to use Joint child relationship?
  14. How to drill to another report?
  15. If a Metric should disregard the filter based on common attribute?
  16. Why do you require hierarchy?
  17. What’s logical table size? How can you chnage it? How does it affect the SQL generation?
  18. A table has million rows and another has 200K, whihc table would be having bigger LTS?
  19. How did you create MEtadata and Statistics table?
  20. 3 different strategies to implment Security?
    DB Instance
    Security Filter
    ACL
  21. Any issue faced in User Merge?
  22. How will restrict prompt element display?
  23. User should be able to selection only one prompt at runtime???

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.

BusinessObjects vs. MicroStrategy


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

On the MicroStrategy-website white paper can be downloaded, tells where in 10 pages why Business Objects is beaten in all possible fields of MicroStrategy. As my readers, but certainly the decision not want to leave a competitor and is also intended for the subtle but important details of interest, I have made the following (incomplete course) to compare the features of MicroStrategy and Business Objects.

As mentioned before, I have considered only the features relevant to the SQL generation of meaning. I have also considered that MicroStrategy and Business Objects to build on fundamentally different approaches and some features are therefore not simply comparable. Such radio ions so I left aside.

The plus sign in the table means is that each tool has an important feature that for the other product would be implementable, although certainly, but unfortunately is not available.

Some “little things” that are in my view, just very important and therefore be present at every BI tool should not be missing, but in the current release of Business Objects. This is why I have marked with a minus sign.

And now the scoreboard:

Feature MicroStrategy Business Object
1 Automated Aggregate Awareness +
2 Into account the cardinality in SQL generation (eg Subquery with an M: N relationship) +
3 Dimensional metrics and conditionals +
4 Filtering using HAVING (QUALIFY is missing even in Micro Strategy) +
5 Consolidations; Dynamic Groups +
6 Assembly of the key figures within the database +
7 Joins on operators other than “=” (eg BETWEEN Join for Slowly Changing Dimensions) +
8 A simple way to choose one of the join paths (via contexts) +
9 No examination of the object dependencies when deleting –
10 No SQL-Preview for the prompt reply but before the execution –

MicroStrategy has over so much more powerful means for the rapid generation of high-performance SQL code – and that’s without taking account of VLDB countless settings that exist for the fine-tuning of the SQL query for MicroStrategy!

An important advantage of Business Objects is in my view, only the possibility of any conditions in the join between the tables to use shortcuts.

Based on Google Translator of original article.

No SQL-Preview for the prompt reply but before the execution