Connecting Microstategy to CM

In this post I'll show how to use the free Microstrategy Desktop application to expose record destruction information.  As shown below, we'll start this process by launching the application and creating a new Dossier...

2018-02-20_9-34-57.png

Next I want to add some data from Content Manager into this dossier...

2018-02-20_9-36-14.png

Here I'm going to select "Data from URL", so that I can ensure security is respected.  If I were to use Databases, and connect directly to the backend RDBMS, I would be directly accessing record data without any security validation.  Instead, I'll point to the ServiceAPI (which will be configured to honor security).

2018-02-20_9-37-06.png

Now I'll enter the URL to the ServiceAPI record end-point.  For authentication, I'll use Windows (though you may need to configure this in a different manner).  Then I click Finish to complete this step.

2018-02-20_9-52-58.png

Now all of my properties from CM are listed in the datasets pane.... 

2018-02-20_9-45-33.png

Next I'll switch my visualization to a pie chart...

2018-02-20_9-55-03.png

Then I'll add owner as a data element...

2018-02-20_9-56-00.png

Next I'll filter out records which cannot yet be destroyed...

2018-02-20_9-57-40.png

Now I'll create a metric, so that the pie slices are proportional...

2018-02-20_10-06-46.png

I'll configure the metric to be the number of unique ID's for a given owner in the visualization...

2018-02-20_10-08-08.png

Lastly, I'll drag the ownership count into the angle property of the visualization...

2018-02-20_10-10-27.png

Voila!  This is a rather simple example, but it should demonstrate the capabilities.  If you take the same approach shown in my aggregating retention data series, then you can see how to expose ServiceAPI end-points so that your Microstrategy users do not have to construct query parameters.