MicroStrategy - Administration

mstr

What is the name of the log file for the Configuration Wizard?

MACfgWiz

What is the location of the Activate.xml file?

 %Program Files%\Common Files\MicroStrategy

How can we manually request the activation code using the activate.xml file?

The activate.xml file must be upload to https://licensing.microstrategy.com/. This will ask you to provide a username and password. This is the same credential that you use to access the support portal. Click on "Activate a Server Installation" to upload the file. After the file is uploaded, you will receive the email with the activation code. The activation code is also display on the screen so you can copy it and use it to activate the server.

What does DSI abbreviate for?

DSI: Designated System Information

What is the maximum memory limit?

For 32-bit Windows: 4GB. For 64-bit Windows XP: 128GB. For Windows Server 2008 R2 Datacenter: 2TB. Refer to http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778%28v=vs.85%29.aspx for details

How can I see the diagram for the corporate hierarchy?

This question has nothing to do with Administration, but I put it here for now. The corporate hierarchy was implemented as attributes, and you can arrange attributes into a hierarchy. Drill down on the project -> Schema Object -> Hierarchies. Double click on Organization.

What is the TN for cross site scripting XSS?

http://community.microstrategy.com/t5/Web/TN37643-New-security-feature-introduced-in-MicroStrategy-Web-9-0/ta-p/187857

How to hide an object?

Using Desktop, Right click on the object and select Properties, and then uncheck the Hidden check box. This will hide the object from Desktop, but will not hide it from MSTR Web. To hide an object from MSTR Web, using the Desktop, right click on the object, select Properties, click on Security (on the left), and then change the permission to Denied All on the right.

How to display hidden objects (while logged in as administrator so that I can move things around)?

Click on Tool -> Desktop Preferences -> Desktop -> Browsing -> Display hidden objects (bottom right)

This will display the objects that were marked hidden using the Hidden check box. To get the object to show up in MSTR Web, using Desktop, right click on the object, select Properties, click on Security (on the left), and change the permission to appropriate permission on the right.

If you see the message "The name is not in use for a subkey or named value", what does it mean?

You need to Run MicroStrategy Desktop as administrator. Just right click on MicroStrategy Desktop and select "Run As Administrator".

How can I determine the versions of the iServer / How can I determine if there was any patch applied to the iServer?

C:\Program Files (x86)\Common Files\MicroStrategy\mstr.hist

The license manager also seems to report this information.

For MicroStrategy Web (Tomcat) where is the configuration file for logging?

webapps\MicroStrategy\WEB-INF\xml\logging.properties

After using the MicroStrategy Connectivity Wizard to configure a DSN, what file is used to keep the username and password that was used to establish the connection?

The information is stored in the Windows Registry. It can be found under the HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node*\ODBC\ODBC.INI\[DSN NAME].

How to hide a device?

  1. Launch MicroStrategy Desktop
  2. Sign into appropriate project source (double click on appropriate project source)
  3. Drill down on Administration -> Delivery Managers -> Devices
  4. Right click on the device and select Properties -> Security
  5. Change the setting for the Everyone user to "Denied All"

This way your non-administrative users will not be able to see the device in Desktop or Web. You can always unhide it by changing the security later.

How to delete a delivery device that is being used by a number of addresses?

  1. Launch MicroStrategy Desktop
  2. Sign into appropriate project source (double click on appropriate project source)
  3. Drill down on Administration -> Delivery Managers -> Contacts
  4. Right click on the right pane and choose View -> Details
  5. Right click on the right pane and choose View Options
  6. Make sure that the check box next to Device Name is selected and click OK
  7. Right click on the right pane and choose List View or Expand All
  8. Review the list of addresses. Delete any addresses with the device to be deleted in the Device Name column
  9. Drill down on Administration -> Delivery Managers -> Devices
  10. Right click on the device that you want to delete and select Delete

If we have a number of scheduled reports, and we want the system to process them as quickly as possible, what are the settings that we need to change?

  1. the number of warehouse database connections

How to change the number of warehouse database connections?

  1. Launch MicroStrategy Desktop
  2. Log into appropriate project source
  3. Drill down on Administration -> Configuration Managers -> Database Instances
  4. On the right side, right click on appropriate database instance and select Edit
  5. Click on Job Prioritization
  6. MicroStrategy allows you to create rules which would decide on how to prioritize the jobs (put the jobs into buckets: High, Medium, and Low). If this is your first time working with job prioritization, just change the numbers at the bottom section of this dialog and click OK. By default, if you do not have any rules, the job will be put into the Low prioritization bucket. If you wish to create rules, click on New.

From the perspective of having to support a lot of concurrent users, what are the important settings?

  1. the number of warehouse database connections
  2. the number of network threads (Configure MicroStrategy Intelligence Server -> Server Definition -> General -> Client-Server Communication -> Number of network threads
  3. the maximum pool size in MicroStrategy Web Admin interface (Go to MicroStrategy Web Admin interface, click on the Modify button next to the appropriate server connection, and change the value for Maximum pool size)

We also have to make sure that we set appropriate limits for the users (number of entry to be store in the history list, the number of allowable scheduled reports)

Should we keep the database connections open?

Database connections are cached and then eventually timeout. "Connection lifetime" and "Connection Idle Timeout" are options under the Database Connection Caching section in the MicroStrategy Intelligence Server that control the amount of time that connections remain open and inactive connections remain cached, respectively. TN 5598 describes the use of those settings quite well. In general, you should not need to keep the connections from your scheduled jobs open. Database connection caching is most useful when you have multiple users executing reports against a warehouse. See TN5598

How to unlock the metadata?

Use the command manager:

UNLOCK CONFIGURATION FORCE

How to delete a zombie project?

We had a situation where the IServer crashed or was rebooted while we were doing a migration. When the IServer came back online, however, we could not delete a project. To delete this project, MicroStrategy Tech Support instruct us:

DELETE FROM DSSMDOBJLOCK WHERE OBJECT_ID = '<GUID of incomplete project>'

We then had to establish a 2-tier connection to delete the project, and then we have to restart the IServer.

What is the difference between a 2-tier project source and a 3-tier project source?

A 2-tier project source is a direct project source, meaning it involves the client (Desktop) which communicate directly to the metadatabase. The Intelligence Server is not involved in a 2-tier project source. When the client communicate with the Intelligence Server, the project source is a 3-tier project source.

How can we create a project source?

  1. Launch Project Source Manager: launch Desktop / Developer and then go to Tools -> Project Source Manager
  2. Click on the Add button
  3. Provide appropriate name for the project source
  4. If we want to create a 3-tier project source, in the Connection mode drop-down list, select Server and type the name or IP address of the server into the Server name box. If we want to create a 2-tier project source, we must first create appropriate DSN using steps mentioned elsewhere on this page or other pages on this wiki, and then on this screen, we have to select Direct for the Connection mode drop-down list, and then select appropriate DSN, and provide appropriate credential (this credential is the database credential for accessing the metadata database schema).

How to make a 2-tier project visible on MSTR Web?

Only 3-tier prrojects can be viewed on MSTR Web. If you want to make your 2-tier project visible on MSTR Web, you must convert it to a 3-tier project (Make sure that your project source is in 3-Tier). Just Right click the project source and select the option Modify project source. Under connection mode you have two options:

  • Direct (this is 2-tier)
  • Server (this is 3 tier which can be viewed from the web)

Change the option accordingly. Also make sure that the status of the project is loaded from the I server administration menu (Administration —> Projects —> Right click project and select project status). See http://community.microstrategy.com/t5/Environment-Installation/Tutorial-project-and-My-First-Project-NOT-show-up-on-the-web/td-p/16587

How to delete a project?

Just right click on the project and select Delete.

How can we delete a project that is not loaded?

  1. Establish a 2-tier project source
  2. Use Desktop / Developer to connect to the 2-tier project source
  3. Click on the name of the project and press the DELETE key on the keyboard, or right click on the project and select the Delete option

How can we use the MicroStrategy Web Preferences screen?

  1. Log onto MicroStrategy Web: /MicroStrategy/servlet/mstrWeb
  2. Click on the appropriate project
  3. At the top, click on Preferences.
  4. If we wish to change preferences for the user account that we used to log into MicroStrategy Web in step one, click on User Preferences on the left hand side. Otherwise, click on Project Defaults in the left hand side.
  5. Click on the appropriate link on the left hand side, and make appropriate changes on the right hand side
  6. At the bottom or the top, there is a drop-down list that allow us to specify whether we want to make this change effective only for this project or for all projects. Select the appropriate option.
  7. Click on the Save or Apply button

How can we limit the number of reports a user can subscribe to?

Project Configuration > Governing Rules > Default > Subscriptions.

How can we disable report caches?

See http://community.microstrategy.com/t5/Server/TN4159-How-can-a-MicroStrategy-Intelligence-Server-Administrator/ta-p/165662

How can we create a new schedule?

  1. Under Administration > Schedule Manager, right-click in the right-hand window and select New > Schedule.
  2. In the Schedule Wizard, name the new schedule (e.g., "Delete History List messages"), and select Next.
  3. Select the Schedule type: Event-Triggered. Select next.
  4. Define the start date as Today, and the end date as "No end date."
  5. In Events Selection, click on the "Events" button on the right-hand side. The Event Viewer window will appear.
  6. In the Event viewer window, select File > New.
  7. Name the new Event (e.g., "My Delete History List Event"). Select File > Exit.
  8. In the "Schedule Wizard - Event Select" window, select the newly created Event from the list of Events that will trigger this schedule.
  9. Select Next.
  10. Select Finish.

The new Schedule will be listed under Administrator > Schedule Manager. MSTR is a "one size fit all" solution. It is not very friendly for certain SaaS application. The interface that is used to create a schedule for administration tasks is the same interface used to create a schedule for the end-user. The end users will see the newly created schedule unless you take steps to hide it.

How can we create an event-based schedule?

See the How can we create a new schedule entry elsewhere on this page.

How can we trigger an event?

  1. In MicroStrategy Desktop, select Administration > Events
  2. Right-click on the previously created Event, and select Trigger

How can we schedule administration task?

  1. Create a schedule as mentioned elsewhere on this page
  2. In MicroStrategy Desktop, select Administration > Scheduling > Schedule Administration Tasks.
  3. In Available Projects, select the project from which the history list message will be deleted
  4. Under Choose One of the following Actions, select Delete History List messages
  5. Select the Newly created Schedule from the list of Schedules
  6. Leave the default setting for Lifetime (Days) at 0. A value of 0 (the default) means that all messages will be deleted regardless of their creation time. If 10 is entered, the system will delete all the messages that are more than 10 days old and keep those that are less than 10 days old.
  7. Under status, select All.
  8. In User/Group, double-click on the "…" button to pull up the Add Members window
  9. From All Groups, select the Everyone Group
  10. Select OK.

How can we enable document cache?

  1. Launch Desktop / Developer
  2. Connect to appropriate project source
  3. Right click on appropriate project and select Project Configuration
  4. Drill down on Caching > Result caches > Creation

How can I create a DSN for Microsoft Access?

  1. Locate the mdb file and remove the readonly bit.
  2. Open a Windows command prompt
  3. Go to C:\Windows\SysWOW64
  4. Run odbcad32
  5. Click on the System DSN tab
  6. Click on the Add button
  7. Select "Microsoft Access"
  8. Click on the Select button and select appropriate mdb file
  9. Click on the Advance button
  10. Click on ExtendedAnsiSQL and change its value to 1 and hit Enter
  11. Click on the Advance button
  12. Click on MaxBufferSize, change its value to 8192 and hit Enter
  13. Click the OK button until all ODBC dialogs are closed
  14. Click on the Windows Start menu and run regedit to change appropriate setting as mention in TN20459

How to manually publish Intelligence Cubes?

  1. Launch Desktop
  2. Connect to the appropriate project source
  3. Drill down on the appropriate project
  4. Drill down on Public Objects -> Reports and select the folder that contains the report
  5. Click on the Search / Find icon on the top toolbar
  6. Click on the Object Types tab
  7. Click on the check box next to Intelligence Cubes
  8. Click on the Find Now button
  9. Double click on the the appropriate item in the search result area. This will run the cube report, and publish the cube
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License