-
How to change the default internal Pyramid website port
1) Navigate to the below file: "C:\Program Files\Pyramid 2018\config.ini" Find the line "wwwport=8181" and change it to a port of your choosing. Also update the following line to reflect the new…
-
Calculating Moving Averages in Pyramid IMDB
Introduction When looking at trends over time, there is often the need to smooth out the individual values by using a Moving Average (MAv). The MAv smooths out the peaks and troughs,…
-
Union: Adding Attributes to a Node
How do you Map Your Measures? You have numbers accrued in a database or excel for months, but nobody has taken an interest in them. You want to unleash the can of worms, so to speak,…
-
IMDB hangs during install on Linux Centos
We found that in some case when installing Pyramid on Linux Centos, the installer hangs on the IMDB phase. In the current installer 2018.05.642 (5.4) there's a missing switch "-y" that enable the…
-
Fail to get Active Directory users groups
Issue: In the Admin, when assigning Pyramid roles to AD Groups, the role fails to propagate to the user, when the AD group contains special characters, such as "/".…
-
Pyramid 2018.05.4 Released
The May release of Pyramid - build 2018.05.642 - covers numerous bug fixes and several features. Upgrading Instructions and best practice guides on how to run the upgrade can be found here.…
-
How to leverage URL and Email Attributes in Actions
Actions can be used to take advantage of columns that contain website URLs or email addresses. In this sample dataset, I have both features. Actions can be created in the Discover module and in the…
-
De-Duplicating Data Sets with Pyramid
Introduction Following on from my previous blog on de-duplicating records using Python, I was curious to see if I could achieve the same result with some creative use of the standard Pyramid Model…
-
De-Duplicating Data Sets with Python
Introduction There are occasions when it is necessary to de-duplicate records before further transformations are required and before loading into the data model target database server,…
-
Major Updates to Help for PQL and APIs
A major update to help has been published with extensive documentation for both the PQL query language and the application's REST APIs. PQL The new help for PQL includes an overview of the Pyramid…
-
Pyramid 2018.05.3 Released
The March release of Pyramid - build 2018.05.507 - covers several bug fixes and a few small features. Upgrading Instructions and best practice guides on how to run the upgrade can be found here.…
-
Pyramid 2018.05.2 Released
The February release of Pyramid - build 2018.05.425 - covers numerous bug fixes. Upgrading Instructions and best practice guides on how to run the upgrade can be found here.…
-
Pyramid 2018.05.1 Released
The January 2019 release of Pyramid - build 2018.05.220 - includes several new features and numerous fixes. Upgrading Instructions for how to run the upgrade can be found here.…
-
Pyramid 2018.04 Released
August 2018 Release The August release of Pyramid includes over 100 new features and numerous functional upgrades and fixes, designed to make Pyramid’s Analytics OS the leading solution for customers…
-
Pyramid 2018.05 Released
December 2018 Release The December release of Pyramid includes over 50 new and upgraded features and numerous functional upgrades and fixes, designed to make Pyramid’s Analytics OS the leading…
-
How to use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.
1) Create a new formula in the formulations app 2) Create an "IF" statement based on a measure using the "RGB" function and save it. Use an RGB Color picker such as the one here to get the correct…
-
Pyramid 2018.04.460 - Interim Release
This interim release includes a few small feature upgrades and addresses a number of bugs. IMPORTANTLY: This version of Pyramid 2018 is designed to work with the BI Office Converter utility beta…
-
How to hide Microsoft SQL databases that a user does not have access to
By default even if a user does not have access to an Microsoft SQL database they can still view it when logging into SQL Management studio. Therefore the same behavior will be seen in Pyramid when…
-
Pyramid 2018.04.310 - Interim Release
This interim release addresses a number of key bugs. The installation software can be found in the customer portal. Bug Fixes Discovery Fixed an issue where Data labels do not show the correct…
-
After upgrading Pyramid, it is not possible to access Pyramid using the URL host name defined in IIS
ISSUE: After upgrading a Pyramid install that uses IIS, the site is no longer accessible, please check that the following is correct: 1) Open IIS >Double click on the server name(1)>Double Click on…
-
Adding a Tabular/Analysis data source that is not located on the same domain that Pyramid 2018 is installed on.
Case Pyramid 2018 is installed on domain A, and you want to add a tabular server that is running on a server with no domain Solution Usually, this would break the security model of how analysis…
-
Pyramid 2018.03.175 - Interim Release
This interim point release covers several bug fixes. Bug Fixes Model Improved memory usage/size limit when processing a very large In-memory database and model.…
-
How to read and use the Pyramid System Logs
The "System logging Type" that is turned on, is set under Admin>Settings>Logging. In the example below we can see that only the Type "Error" is turned on.…
-
Pyramid 2018.03.156 - Interim Release
This interim release brings a list of bug fixes. Bug Fixes Admin Fixed an issue when loading an upgraded license Support non-ASCII characters in file names when saving exported/printed content Fixed…
-
Browser Settings for Windows Authentication
To configure IE for windows authentication, please do the following: 1. Add your Pyramid's Web site to the list of TRUSTED SITES or Local intranet in the browser through Tools > internet options >…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.11 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
The DataShark Podcast
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help