MicroStrategy SDK 7

Ad-Hoc Reporting:

Description:

This application demonstrates how a report can be constructed very easily from an arbitrary list of attributes, metrics and elements. It also shows how to add a metric qualification on the report.

After connecting to a project, users are provided with a list of all attributes and metrics in the project. A user can click on any single attribute, to view the elements of this attribute. A user could construct a report by choosing any of these objects.

When adding a metric qualification on the report, a user can choose to qualify the value, rank or percentile of any existing metrics, calculated at any attribute level.

Usage:

1. Choose the data source you want to connect in the Data Source Name drop down box, and click Connect.

2. A login form appears. Type in your login and password in the text box or check Use trusted security check box. Then click Login.

3. Choose a project from the Project drop down box, change your login/password if it is different from the login/password of the data source.

4. You are now returned to the main form. You can browse in the left plane. Click on the + icon of an attribute to retrieve the list of elements of this attribute. From the left plane, choose the attributes, metrics or elements that you want to include in your report. Click >> to move them to the right plane.

5. If you want to add a metric qualification to your report, check the Add Metric qualification check box.

6. Click Execute.

· If you did not check Add Metric qualification check box, you now see the report result grid.

· If you did check Add Metric qualification check box, you are prompted with a Metric Qualification form.

7. Choose a metric on the Metric drop down box. Choose an attribute on which level this metric would be calculated. You can then select the option of qualifying on its value, rank or percentile. Choose an operator from the Choose an operator drop down box and type in the value in the Specify a value box(es).

8. Click Apply to apply the defined metric qualification to the report.

9. The report result grid appears.

Excel Add-In:

Description:

The Excel Add-In sample shows you how to access the MicroStrategy environment and run reports through the Microsoft Excel interface.

This VBA application allows you to connect to an existing MicroStrategy 7.0 project and retrieve a list of all reports in this project. You can choose to run any report and view the report grid in the Excel work sheet.

Usage:

1. Double click on file Doexladd.xla in your Windows Explorer to open this application directly. Click Enable Macros if such a window appears. You can also open Microsoft Excel. Go to Tools Add ins…, and browse to find the Doexladd.xla in your machine. Check the option Microstrategy 7.0 Add in. You will see a Microstrategy 7.0 SDK menu appears on the menu bar.

2. Click Microstrategy 7.0 SDK menu. Choose the item Select project…. A Select a project form appears.

3. Choose in the left plane List of registered projects a data source that you want to connect to. Provide the login/password. Click Connect.

4. A list of project appears if you selected a 3 Tier data source. Provide the login/password for the project and click Connect again. The Select a project form is not visible.

5. Click on a cell in the excel work sheet where you want the report to start.

6. Go back to the Microstrategy 7.0 SDK. Choose Run Report. A Select a report form appears. (You can still choose Select Project… item if you decide to connect to another project.)

7. Wait while the report in the project loads. Choose a report that you want to run. The report is in alphabetical order by its name. The Path text field shows the location of the report.

8. Select a report in the available report list and click Run.

9. The report result grid appears on the work sheet, starting from the cell that you previously selected.

Hello World (VB):

Description:

This simple(one-button-click) application shows the basics of how to execute a report in VB. It connects to the SDK_Demo datasource, logs in as administrator, executes an existing SDK Sample Report and shows the data part of the result set.

Usage:

Click Execute button. The result grid appears.

Hello World (VC):

Description:

This simple(one-button-click) application shows the basics of how to execute a report in VB. It connects to the SDK_Demo datasource, logs in as administrator, executes an existing SDK Sample Report and shows the data part of the result set.

Usage:

Click Execute buttion. The result grid appears.

MiniAgent:

Description:

This VB Sample application demonstrates a basic set of features that can be executed through the MSTR 7.0 Base API.

Working through this sample, users can learn how to connect to a project, browse objects, search for objects of a certain name, obtain filter expressions from a filter object, obtain template layout information from a template object, obtain report template and filter information from a report definition object. Furthermore, users can execute a report definition object while controlling or observing the stages of the execution. Users can also inspect the SQL statements that were executed and see the execution result grid.

Usage:

1. Click Enum Data Sources. A list of registered data source appears.

2. Select the data source you want to connect to and click Login. A login form appears.

3. Provide the login credentials to log in the data source in the login form and click Login. You return to the main form.

4. Choose a project you want to connect to in the Projects under Data Source list box. Click Get Session. Again, the login form appears.

5. Provide project login credentials if they are different from previous. Click Login.

6. If you have successfully created a session, the form extends to show the Part II Basic Object Access plane.

7. You can browse a folder object in the Children plane by clicking on the up arrow button to go to its parent folder. Or, click on the down arrow button to get the items that are contained in the selected folder.

• If you selected a Filter object, click Filter Info to see the filter expression of the selected filter.
• If you selected a template object, click Template Info to see the template units on the selected template.
• If you selected a report definition object, click Report Info to see the filter and template information of the selected report definition.
• If you selected a report definition object, you can also execute this report. Click New instance. The plane extends to show Part III Report Execution. Choose which stage you want the report to be executed in the Actions drop down box and click Execute. Meanwhile, you can view the state of the report execution at the State: text field.
• If View SQL is enabled, you can view the executed SQL for this report.

If View Grid is enabled, you can view the executed result of this report.