How to setup Pyramid Data Modeler (former Mash Pit)

Before starting to work with Data Modeling (formally Mash Pit), a tabular instance need to be set up in SSAS.

Once the tabular instance is set up, please configure it in BI Office according to below steps:

1. Open the Administrative Console > Data Sources tab

  • If the tabular data source was already added to the Data Source list, please locate it in the list and click on Edit
  • If the tabular data source was not added yet, please click on “Add Data Source”

2. Fill in the details of the tabular instance (if not already added).
Make sure that the data source type is “MS SSAS OLAP 2012 Tabular” and up, and that the Mash Pit check-box is checked.


3. Click on Save then click on Roles (for the tabular data source).
Assign roles to the tabular datasource and Make sure that the “Upload models” check-box is checked for the roles that require access to the Data Modeling functionality.

4. Click on Save & Exit


In BI Office V6.x, Once the configuration in the Administrative Console is complete, a “New Data Model” button should be enabled in BI Office under File > Start

 

In versions older than V6, once the above steps are completed, the “Add Mash-Pit Data Source” button should appear in BI Office under File > New > New bioXL Analysis.

Reference Pyramid Community – New Data Model (Mash Pit) configuration – Data Modeler (formerly Mash Pit) – BI Office

How to disable IE Enhanced Security for Pyramid Installations

Internet Explorer Enhanced Security Configuration is already enabled

To disable IE ESC for all users

  1. Close all instances of Internet Explorer.
  2. Click Start, point to Administrative Tools, and then click Server Manager.
  3. If a User Account Control dialog box appears, click Continue.
  4. Under Security Summary, click Configure IE ESC.
  5. Under Administrators, click Off .
  6. Under Users, click Off .
  7. Click OK.
  8. To enable IE ESC, click On for both Administrators and Users, and then click OK.

How to get Pyramid report or dashboards additional information by querying the database

How to know a Pyramid report in group or public area is referring to whose private user’s dashboard?

We were trying to delete a report from group area, and it use to gives error with dashboard name say “abc” is using the report and hence the report cannot be deleted.

The problem is it doesn’t tell us whose Personal content, is this dashboard “abc” residing in.

By executing following queries on back-end Pyramid database we can get this information:

  1. Find the folder ID of the dashboard using the bellow query:
    select * from content_tbl.Books where Name=’Dashboard_Name’
    Make sure to replace ‘Dashboard_Name’ with ‘abc’
  2. Copy the folder ID and use it in the bellow query to find the name of the folder where the the dashboard is located.
    select * from content_tbl.Folders where FolderID=’Folder_ID’
  3. In the query result, check for the “Name” column for the folder location.

Pyramid Report building basics

Pyramid reports are based on SSAS cubes, which means we have measures and dimensions.

If you have used Excel to show SSAS cube data, then it will be easy to understand Pyramid reports to show SSAS cube data.

To start with in columns go the measure(s) and on rows go the dimensions.

If your requirement needs to have even one or more dimensions in columns then you can do that too.

Pyramid provides slicers, in addition to rows and columns. You can have additional dimensions in slices too. They are just like SSRS report parameters.

Pyramid has parameters in addition to slicers.

Above as i mentioned if you want an dimension in both slicer as well as in row ( or column) we need to create it as an parameter.

We need to create parameters if we want a dimension in both slicer as well as row/column. When we create parameter, just remember to give it different name, since we can’t call it the same thing. We can change the actual caption text to make it more meaningful and user friendly.

Pyramid provides sub-sets for filtering.

Pyramid report has the cube name and any additional info about its structure.

If you want cascading slicers, you have to go to ribbon Query=> in advanced section select cascading prompt and then based on your requirement select single or multi hierarchy.

Let’s say you selected multi. Now it opens up the cascading prompt wizard. Add the dimensions you want to do cascading with. Once finished the related dimensions will be added to slicers in BLUE.

My Pyramid Analytics v5.4 install notes

  • Contact Pyramid and get the ISO file and install documentation.
  • Using any software such as Virtual CloneDrive get the ISO file mounted.
  • Get the domain account for this softare say domainabc/userxyz and add it to Administartor group on the server.
  • Make sure the account you have logged in to the server is Admin to the local machine.
  • Now run the setup as Administrator from 64 folder if the server is 64 bit.
  • Once the setup is complete the deployment wizard will start.
  • Create various accounts – pyramid master account, ssas account, sql server account and provide them to deployment wizard.
  •  NOTE: In the deployment wizard when it asks for the url we SHOULD NOT provide http://. We should just provide the server name or the host name.
  • Once installation is complete login to Admin console using pyramid master account.
  • Now navigate to client licenses tab and click on “Add Client License Pack” to add the various licenses received from Pyramid.
  • Now create appropriate Roles based on say department taxonomy.
  • Then create Profiles based on access rights such as drill or slicing/dicing.
  • Add users and assign them appropriate roles, and if needed assign them as admins.

Pyramid Analytics Deployment / Promotion strategy as per my thoughts

The user creates content (– reports or dashboards) in his own personal content space/area.

If the user is creating dashboards he should preferably use the existing ones (default out-of-the box provided by Blackboard) in Public content space/area.

If the user is creating report he should preferably first check if there are any existing ones default out-of-the box provided by Blackboard in Public content area.

Once the user finishes creating content (– reports or dashboards) in his own personal content space, then the user should move it to Group content space/area in his department folder.

If the department folder doesn’t exists then the user should contact IT and get the department folder created.

Once the business and IT both finalize on the content (– reports or dashboards), it should be move by IT to the Public content area.

The IT should link the above newly published content in the intranet portal, if any exists.

 

NOTE: The above steps hold true if we have only one environment.

If we have Production and QA available, then we can follow following steps:

The user creates content (– reports or dashboards) in his own QA personal content space/area.

If the user is creating dashboards he should preferably use the existing ones (default out-of-the box provided by Blackboard) in Public content space/area.

If the user is creating report he should preferably first check if there are any existing ones default out-of-the box provided by Blackboard in Public content area.

Once the user finishes creating content (– reports or dashboards) in his own personal content space, then the user should move it to QA Group content space/area in his department folder.

If the department folder doesn’t exists then the user should contact IT and get the department folder created.

Once the business and IT both finalize on the content (– reports or dashboards), then the IT should move it to the QA Public content area.

The IT should link the above newly published content it in the QA data warehouse SharePoint site.

Once finalized the content (– reports or dashboards) will be moved by the user (content creator) from QA Public content area to Production Group content area.

When the content will be moved from QA to Production, its Data source needs to be changed.

The IT should move the content from the Production Group content area to the Production Public content area.

 The IT should link the above newly published content in the intranet portal, if any exists.