MicroStrategy - Miscellaneous


Write an ebook that simplify MicroStrategy manuals

Scheduled reports / Scheduled jobs:

We can consider prompts as interactive filters and the normal filters as static one. Effectively both are being translated as conditions in where clause of Report SQL. But static filters can be made interactive using "filter prompts".ie drag the required prompt into the filter.

Please define what you mean by "interactive filter". It's possible in MSTR to filter, to prompt user. Even you can change values after report is run.

Prompts can be used in Freeform SQL reports as in standard MicroStrategy reports. Due to the nature of the Freeform SQL reports, only value prompts and element list prompts can be used.

If i use the full URL in the hyper link place holder , even after targeting the my panelstack ,it is prompting the not taking the values from the selector, but if i go to edit link and if i choose the that report from there and set the prompt answer dynamically, than the selector value is passsing….but by using edit we are able to pass only one value….

one more thing that panel stack is targeted by attribute (ie. by right clicking the attribute and selected use as filter and then in the target list selected that panel statck )

1. Instead of using selectors, use prompts
2. What are we trying to do?
3. Dynamic links (edit links)
5. Do we really need to pass the selectors from parent report to child report?

As for the MicroStrategy Diagnostics and Performance Logging Tool, if you are running a Windows Sever, the System Log could write to Windows Event Viewer File. Enterprise Manager and Statistics is not for logging purposes. It is to be used as a MicroStrategy project to run reports on Data Usage. Health Center, if correctly set up, can pull logs off of a machine for vieiwing on another machine, but there is no way to automate it.

TN 14506 - What is the purpose the columns 'System log' and 'Console log' in the MicroStrategy 8.x Diagnostics and Performance Logging tool in UNIX?

Frequency (how frequent the report is run) versus data period. If the user save the report, then the data period become a fixed data period, so the user have to re-save the report every month (or every week, or every day).

See if the user create dynamic prompts, and would these prompts. The user would need to change the way the prompt behave. If the user can provide the own configuration for the prompt. We put the name of the prompt into the Freeform SQL, but the user provide their own configuration for the prompt.

Prompt generator

The MicroStrategy Listener Services communicates with MicroStrategy Web products and Intelligence Server on port 30172. If you are using the Listener Service, you must make sure port 30172 is allowed to send and receive TCP/IP and UDP requests through the firewall. You cannot change this port number.

By default, MicroStrategy Web and Intelligence Server communicate with each other using port 34952. MicroStrategy Web may use a different port depending on how you deploy it. If you wish to change this, you must change it for both the Web servers and the Intelligence Servers. The port numbers must match on both side.

Preventing users from being able to schedule reports on hourly basis.
Get the statistics from production for scheduling.
Remove HTML and Flash from email subscription
We need to be able to share reports at per facility level.
Right click on the chart. We need to make our outer frame grow to match the height of the MicroStrategy frame
Remove drill down from chart / grid
Make "Express Mode" the default without the JavaScript error.
See if the user can adjust the date prompt. See if the end user can create prompt / dynamic date.

A version of the Function Plug-in Wizard that provides additional open source support for creating function plug-ins is avaiable at http://fpwizard.codeplex.com.

Installation and Configuration Guide
System Administration Guide
Supplemental Reference for System Administration
MSTR Object Management Best Practices.doc

Web SDK Customization (MS_Edu_Web_SDK_Customization.pdf)



Due to the nature of the Freeform SQL reports, only value prompts and element list prompts can be used.
Can we use dynamic prompts / filters with Freeform SQL?


Which file contains the URL that is used for SAML authentication?



  1. What is a connection map? Why would someone want to create a connection map via the SDK? Search SDK documentation for "Creating a New Connection Map", "Connection Map".
  2. When we use the Configuration Wizard (Start menu -> Programs -> MicroStrategy -> Configuration Wizard) to create a server definition, what files does it create on the system? Can we safely copy these files to another Intelligence server?
  3. When you create a metadata repository, by default, it creates a server (3-tier) project source. You can use the Project Sources option in the Configuration Wizard if you need to create multiple project sources or a direct (2-tier) project source. What is the advantages of using multiple project sources?
  4. The server definition is stored in the metadata repository. Where does MicroStrategy store the project sources?
  5. How can I determine if my Intelligence Servers are using the same sever definition?
  6. How to use the Cluster Monitor to cluster a node?
  7. How to enable user affinity clustering? See page 442 of System Administration Guide 9.2.1m. Do we also need to configure user affinity clustering at the load balancer level?
  8. We have two Intelligence Servers, but they are not configured as part of a cluster. The two MicroStrategy Web servers are behind a load balancer. Everything seems to work. Based on your opinion, is there anything wrong with this setup? Occassionally, the user is directed to the project selection page. Do you think that this is caused by this setup?
  9. Does MicroStrategy use UDP? Is UDP mandatory? How does MicroStrategy use UDP?
  10. When do we need to put a project on idle?
  11. Can we perform maintenance on a project when it is unloaded? Can we (the administrator) do anything with a project while it is unloaded?
  12. On production, we have 4 CPUs. How many of these are physical CPUs, and how many of these are logical CPUs?
  13. Review what was previously installed
  14. Review the install.log
  15. Look at the License Manager again to see if Web Reporter, Web Analyst (or MicroStrategy Web) are licensed.
  16. How are DSI created?
  17. Is there a way for us to determine DSI number using either MicroStrategy Desktop or MicroStrategy License Manager?
  18. When installing MicroStrategy, it asks for the intended usage. What are the available options displayed? Production, Development, Testing, Training, Other. What is this information used for?
  19. What are the difference between Project Duplication Wizard and Object Manager? When you we use Project Duplication Wizard and when should we use the Object Manager? Which tool does MicroStrategy recommend? Do MicroStrategy recommend using Project Duplication Wizard rather than Object Manager? What does Project Duplication Wizard do, and what does Object Manager do?
  20. What is the purpose of Project Duplication Wizard? What is the purpose of Object Manager? What is the purpose of Project Merge Wizard?
  21. We can use whatever tool to copy object from one project to another project on a different environment. Does MicroStrategy recommend us to copy object from one project to another project on the same environment, same IServer, same metadata, etc?
  22. In my limited experience, MicroStrategy is not simple. What does it take to effectively run and manage a MicroStrategy installation? Beside professional services, is there a secret sauce? Is there a single book that an administrator can read from front-to-back and understand everything that he need to do? The problem with the Administrator guide is that it is thick, and contains a lot of "if you want to learn more about this go to such and such page", and it is not complete either.
  23. See if we can schedule reports to be run between certain period for certain region. East coast facilities want to get the reports delivered between certain hours. West coast facilities want to get reports delivered between certain hours. MicroStrategy is very one-size-fit-all. Perhaps, we can still use MicroStrategy but we need to avoid using the scheduling component that are part of MicroStrategy, and implement our own scheduling components.
  24. How can we restrict the number of reports per user per time period? In other words, how can we implement quota for each user or facilities?
  25. Can we hide certain columns for certain users? We would have one report, but depending on the role and privileges, users with appropriate privilege can see the column, but user without privilege cannot see the particular column.
  26. When should we use report caching?

What tools do I want?

  • For upgrading, I want a tool to check to see if the history list database got updated successfully. Similarly, I want to check to see if the enterprise manager got successfully upgraded.
  • Related to upgrading, I want a tool to check to see if I am using supported datatypes. MicroStrategy supports a wide variety of data types for each supported warehouse database. If an existing MicroStrategy project containing columns with unsupported data types is upgraded, the data types for those columns are assigned as “reserved,” and proper data types are not assigned in temporary tables. This affects report execution. Before proceeding with the upgrade, you must ensure that all data types assigned in existing projects are supported in the current MicroStrategy version. See the MicroStrategy Project Design Guide for a listing of the supported data types for each database type and additional information about changing to supported data types.
  • How can I make sure that my MicroStrategy environment is well-tuned beside using a typical monitoring tool such as Nagios or IT360, and using Enterprise Manager? Is there tool that check various system settings and VLDB settings?
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License