Connecting Planning Maestro Cubes to Power BI Desktop

Follow

Planning Maestro Cubes are read-only, published views of your data that you can examine and analyze from different angles, like a Rubik’s cube. You can use a Cube to drill down to the smallest details or study the broadest overviews of your data.

Centage’s Analytics Maestro is a plug-in to Microsoft Excel you can use to examine Cubes. You can also use the Power BI Desktop App to review your Cubes. Using Power BI for Cubes enables you to set up your data in Planning Maestro and then use Power BI’s analytics tools to study and analyze it.

This document shows you, a Planning Maestro user, how to set up the Power BI Desktop App to examine Planning Maestro Cubes.

Step 1: Open the latest version of the Power BI Desktop App and select Get Data.

B1a.png

Step 2: On the Get Data page, select SQL Server Analysis Services Database and click Connect.

B1b.jpg

Step 2: Enter https://<<ANALYTICS MAESTRO HTTP SERVER NAME>>/OLAP/msmdpump.dll in the Server field and select the Import radio button. Click OK. Your Analytics Maestro Connection String can be found in Planning Maestro Settings.

B1d.png

Step 3: An Access SQL Server Analysis Services popup appears. Select the Basic tab and enter your Cloudmaestro username and password in the fields provided. Click Save.

B1e.jpg

Step 4: The Navigator page opens and displays the Cubes you can access.

mceclip0.png

Step 5: Select the Cube you want to analyze using Power BI and configure the data by:

  • Selecting the Cube Dimensions you want to analyze.
  • Selecting a Measure (a method for organizing your data in Power BI) from the Fact LM directory.

Step 6: Click one of the buttons below to send the data to the Power BI Desktop App:

  1. To send the Cube to the Power BI Desktop App as it is without making any changes, click Load.
  2. To send the Cube to the Power BI Desktop App with changes, click Transform Data.

B1f.png

Example: If an Account Number Dimension is wrongly classified as a Time Dimension, you can correct this classification by overriding it in Transform Data.

Step 6: The Power BI Desktop App opens. To publish the Cube and examine it, click Publish.

B1g.png

Step 7: When the data is published successfully, a Publishing to Power BI popup appears with a Success! message. Select Open [name of the Cube] in Power BI.

B1i.png

Step 8: The Cube is now available in the Power BI Cloud. Select the name of the Cube to open it and use Power BI tools to analyze it.

B1j.png

1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.