MicroStrategy

Tool Permissions Prerequisites

Ensure that the Cloudera Octopai Windows NT User has Read Permission to the MicroStrategy *.mmp or backup files folder.

How to Automate Extraction of MMP Files

The MMP files contain the necessary metadata for the analysis by Cloudera Octopai .

Follow these steps to create MMP files:

1. Open the MicroStrategy Object Manager

   

2. Select Project Source and click on Open

   

3. Enter login credentials (with admin user)

   

4. Select Project from the left side panel

   

5. Click on Tools --> Create Package

   

6. Click on Add

   

7. Check Import Folder and Children recursively

   

8. Select one folder and click OK

   

9. Check Return as a container to create XML and click OK

   

10. Check “Add All Used Dependencies,” change the Save in path, rename the target file as necessary, and click on Create XML

    

11. Repeat steps 8-10 for each folder within the project (Normally at least 4 folders per project).

12. Repeat steps 4-11 for each project.

Using the XML file to create an updated package:

Executing the Project Merge executable, projectmerge.exe (Part of MicroStrategy Tools)

Use the user and password that you use in order to log in to the Object Manager.

Enter the following command in a batch file: c:\Users\projectmerge -f\Filename.xml -sp -sup

C:\Users\octopai>projectmerge -fC:\temp\T.xml -sp******** -sup

Setting up MicroStrategy Metadata Source

Metadata Sources are set on the Cloudera Octopai Client :