Skip to Main Content
Mobile Menu

Frequently Asked Questions

Find answers to common questions, tips and troubleshooting about Pyramid Analytics. Use the Ctrl+F keys to search for text on this page or find information in one of these categories:

Access Questions | Tool Features | Data Questions | Report Questions | Troubleshooting

Access Questions

How do I request access for Pyramid?

Follow the instructions on the Request Access page, or use the Request Access button in the left hand navigation, to request access to the data warehouse, which includes both myInsights and Pyramid Analytics.

Are there different access levels in Pyramid Analytics?

Yes. By default, users are provided with “Consumer” access that allows them to run, print, save and export reports.  Analyst licenses are required for use with the Group Content feature and allow for more advanced features of the tool.  Contact the Help Desk to request a different level access.

How will I know which license I have?

Your license is shown on the Account screen located in the BackStage area.”

Tool Features

What is the BackStage?

The Backstage is the common interface screen seen when logging into Pyramid. This form houses the common screens and functions that users will access such as online help, opening a report or dashboard, creating new reports and dashboards, as well as organizing them.  The form displays the user, license and version details and offers the ability to change the color scheme.

All users who login to Pyramid Analytics using the link in the left hand navigation of the website, will see this screen immediately.   If a report is accessed via the commonly-used list of reports, then users will need to click on the down arrow in the upper right hand corner to access the menu that leads to the BackStage area.

Does opening a report mean Pyramid has run the report?

Yes. If you need to make changes to the report, such as changing the term, then once the change is made you will need to re-run the report by clicking the “Pyramid” icon in the upper right corner of the screen, or press F2 on the keyboard if the report doesn’t automatically update.

Why do I see the red circle with a line through it when I first open a book or report?

A preview image of the report is normally shown here after the report has been accessed.  You will see this image if you have not run the report before. Once you’ve run a report, you will see a thumbnail preview image of the report.

Why don’t I see the selection panel when I first open a report?

The default view for the Consumer license in Pyramid Analytics is the “Viewer Workspace”, which collapses the right hand panels.  When you open a report from a link in the report directory or an email, it opens in the “Lite Workspace.  You’ll need to click the Maximize arrow to expand the ribbon, then select the Analytic Workspace option to open all of the right hand panels at once.”

How do I rerun my report if I make a change?

Click on the multi-colored icon that looks like pyramids in the upper right hand corner of the screen in Pyramid, or press F2 on your keyboard.

How do I get to my ribbon from the default view?

Click the small grey caret shaped arrow in the Quick Access toolbar, which is at the top left hand side of screen.

Where can I find the name of the report once I have opened it?

Expand the Reporting Tree Panel by clicking on the Reports button on the left edge of the report panel, if it’s collapsed, then drag the edge of the reporting tree panel to expand so you can see the full name of the report.  The open report is lightly highlighted.

Why is the name of the report different on the tab from the one shown at the top of the report?

The name of the report and the title of the report are not the same. The title is dynamically updated as selections are made when the report is run which is helpful for understanding what data is currently displayed in the report. The name of the report is what you use to find the report in the book.

How can I reset my report if I get messed up and want to go back to the original view?

Select the Home tab in the Ribbon Panel. Click on the bottom half of the Query Reset button and choose Report Reset. If you accidentally select the Query Reset option instead of Report Reset don’t panic, you can still use the Report Reset option to return the report to its original state.

How can I go back to a previous state of my report?

Use the back arrow in the “Quick Access Tool Bar.”  Watch this video on how to reset your report [LINK]  Be sure not to use the Back button in your browser as this button will take you out of Pyramid entirely.

Data Questions

Why do the totals for each row not match the sum for some of the columns?

A student can be counted more than once for some measurements.  For example, when counting the number of distinct (i.e., unduplicated) students, a student with a double major would be counted once in each major, but only once at the University level.

What does distinct data mean?

Each line listed indicates uniqueness from all of the other rows in the list.  For example, a student with a triple major in biology, chemistry, and accountancy will be counted thrice at the plan level (once in each major), thrice at the department level (once in each department), but only twice at the college level (once in the College of Arts and Sciences and once in the College of Business and Economics), and only once at the University level.

What does dicing mean? How would I use it?

Dicing is a feature offered in the right-click context menu that allows the user to pick specific values of multiple dimensions to examine it from different viewpoints in order to understand it better. Which item you’re filtering by is determined by what you selected on the report. Pyramid will take that element to filter by, moving it to the Subsets area in the Selections Panel, while putting the selected hierarchy in its place.

How do I know my data is valid?

That depends on the report and who requested it because of how they framed their question.  First, check the Data Dictionary website to evaluate the meaning of the parameters or measures shown on the report.  You may need to contact the report owner, data steward or the department for which it was originally created which can be found in the Data Dictionary.  If you still need assistance, contact Institutional Research at or the Help Desk at

How do I find out what the report fields mean?

You can find report field definitions in the Data Dictionary.

Report Questions

How did the reports shown on the Report Directory get chosen?

The reports you see in the list today were identified by the Business Intelligence team and the Institutional Research team as the most impactful and most frequently used or accessed. This report directory is expected to be a dynamic list meaning that it will evolve and change over time to meet the needs of the campus.

How do I get a report listed in the report directory?

Please submit your request to for review or routing to the appropriate resources.

I don’t see or can’t find a report with the data that I need. What do I do?

To find a report that will meet your data needs, begin with the list of Commonly-Used Student Data Reports located on the Data Warehouse homepage.

If you do not see a report that meets your needs, login to Pyramid Analytics and view the reports listed in the Public Content domain or use the Search option listed in the left hand navigation of the Backstage.

If you do not find a report in Pyramid Analytics, try logging into myInsights to see if a report is located there.  You can also email to see if there is a report that meets your needs. 

Are the reports that you see in Main Student data the same in Pyramid tool as reporting?

No.  There are technological differences between these two systems.  MyInsights uses a relational database and is published to SharePoint.  Pyramid uses Analysis Services, commonly referred to as “the cube”and is a proprietary product.  Certain aspects of each technology allow, or limit, the tool in which the report is developed.  Not every tool works for every question.

How do I refresh the data in a report?

You can refresh the data by changing a filter or one of the options in the Selections Panel, then clicking the multi-colored Pyramid icon in the top right hand corner of your browser, or by pressing the F2 button on your keyboard.

Why do I get this Silverlight popup?

Pyramid requires Microsoft Silverlight be installed in order to allow the tool to function the way it does.  If prompted for allowing access or increasing memory storage, select to allow the access.  If prompted to install this plugin, please go ahead and install it.

Is there a difference in quick export functionality using Chrome vs. Firefox; Mac vs. Windows?

No. However, some users have noticed that their keyboard is disabled running Pyramid Analytics using the Chrome browser on a Mac.  This is a known issue in Silverlight with Chrome, so you’ll need to switch browsers for that function.

Why do I see so many reports after I modified and saved just one?

Pyramid does not allow you to save a single report when using Save As.  Instead you must save the entire report book and modify that book accordingly; unwanted reports can be removed from the opened report book using the right-click context menu in the reporting tree panel.

Version 5.x of Pyramid allows a report to be copied from one book to another with the use of the right-click context menu when the book is open.  A report must be copied into an existing book.”

What if I don’t want all of these reports when I save a book in my personal content? What do I do?

After saving the book, unwanted reports can be removed from the opened report book using the right-click context menu in the reporting tree panel.

My Ribbon Panel went away, how do I get it back?

Click the caret shaped down arrow which resides in the Quick Access toolbar at the top of the screen.

What does Query reset button do?

Nothing good. The Query Reset option is not something that average reporting users will need. This feature clears the current query and selections on the current report tab. This “resets” the reporting session and loads up the initial default query again. Most likely you’ll do this accidentally when trying to perform a Report Reset.  Recovery can be accomplished by clicking the Backwards arrow in the Quick Access menu at the top of the page.  A Report Reset will reset the current report to its previously saved state and is a commonly used function. Report Reset can be used to recover the original report after clicking on the Query Reset button.

If I have more than a 1,000 rows while doing my drill/sort to get class list, do I need to resubmit before I export to Excel?

Yes, you will need to increase the number of rows that will be brought back, click Resubmit, then check the resulting number of rows against the number you started with. Once you see you have all the rows, then use the Excel button to the left to export the data.

How can I determine if I have gotten all of my rows during my drill/sort?

Check your numbers against the number in the report to determine if you have allowed for enough rows to be returned.

When the report is saved outside of Pyramid will the data continue to be refreshed?

If you export the data into an Excel spreadsheet, or any other format outside of Pyramid, it will be static.

The data is updated every night from PeopleSoft, so when you re-run any report within the Pyramid tool, including those in your Personal Content folder, you will have the most recent data in the data warehouse.

When I send a link to someone and they then make changes to the report at their end, does that affect the report format in my Personal Content folder? That is, if someone revises and saves a report that I send out via email link, does the 'remote save' affect the original personal report?

No, your personal report is not affected. Changes are only allowed to reports based on the software license and role you have been granted on the server. Everyone can make changes to a report but those changes can only be saved when someone saves that report to their Personal Content or the Group folder they’ve been given access to. Your report is not affected.

Troubleshooting Questions

Internet Explorer cannot display the webpage

There is a known issue with older versions of Internet Explorer, such as IE 8 or IE 9,  that causes connectivity issues.  You can make changes to your Internet Explorer to make this work, or alternatively, you can change to a different browser, such as Firefox, and you will no longer have this issue.

  1. From Internet Explorer, click on Tools>Internet Options
  2. Click on the Advanced tab
  3. Scroll all the way to the bottom of the Settings area, revealing the last options under Security.
  4. Select the option to Use TLS 1.2 (it will be unselected in older versions of IE)
  5. Click Apply.
  6. Click OK.
  7. Retry the web page and the page should load.

Should I trust the Microsoft Silverlight application that enables copying the link to the Silverlight clipboard? ( I wasn't able to copy and paste the link without first accepting the Silverlight application)

Yes. Yes, you did the right thing by allowing the Silverlight application access to your computer. It’s Microsoft’s version of Adobe Flash and is what allows the right-click context menu to work in a browser, along with other software features.

How can I contact someone for assistance?

If you have a “how to” or data question about reporting in general, the data warehouse, myInsights or Pyramid Analytics, please email

If you’re having trouble accessing the site, need help installing software or need immediate assistance, contact the Help Desk at 208-426-4357, or chat.