Please enable JavaScript to continue!

Pyramid 2018 Blogs

Access great information from Pyramid including Help articles, News, Announcements and Blog Topics on advanced techniques.

TOPICS MEMBERS

Join this category to participate in conversations and receive notifications when new posts are added.

JOIN

Join

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…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 6 days ago
- 13
- 2
- Pyramid 2018 Blogs
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,…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 6 days ago
- 6
- Pyramid 2018 Blogs
Pyramid recommendations for routine content backup
These are the items we Recommend backing up periodically (Preferably Daily but it's up to you) The database repository . If you don't know where it is, browse to HTTP:…
- Danielstaff
- Daniel
- 2 wk ago
- 18
- 2
- Pyramid 2018 Blogs
How to clean up the Pyramid "General" Folder
The following can be run on all Pyramid servers in your installation. When the next major release of Pyramid comes out this process will be automatic for printing files created after it is…
- Danielstaff
- Daniel
- 2 wk ago
- 1 reply
- 21
- 1
- Jared Colton2 wk ago
- Pyramid 2018 Blogs
Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector
Introduction You’re working on an analytic project and have all the data you need, minus some crucial data that you suspect may be available on the internet.…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 1 mth ago
- 37
- 3
- Pyramid 2018 Blogs
Firewall Settings for Pyramid
When Pyramid is installed across multiple servers and there are internal firewalls between them, the following ports must be opened between all servers. All ports are TCP.…
- Danielstaff
- Daniel
- 2 mths ago
- 70
- 2
- Pyramid 2018 Blogs
How to setup a Amazon Load Balancer (classic) to work with Pyramid
The below example shows you how to setup your Amazon Load Balancer(classic) to forward HTTPS traffic to the internal Pyramid web server. As can be seen below two listeners have been setup.…
- Danielstaff
- Daniel
- 2 mths ago
- 44
- 3
- Pyramid 2018 Blogs
Cube design tip
When a Dimension name is identical to an Attribute name, The dimension property ' HierarchyUniqueNameStyle ' should be set to ' IncludeDimentionName '.…
- Yakov Shaul
- Yakov_Shaul
- 2 mths ago
- 42
- 2
- Pyramid 2018 Blogs
Pyramid's Calculation Engine Explained
Pyramid includes a sophisticated, multi-tiered calculation engine designed to handle the full spectrum of calculations often required in solving analytic questions and problems.…
- Ilan Perezstaff
- Ilan_Perez
- 4 mths ago
- 132
- Pyramid 2018 Blogs
Setting up security roles for Analysis Services with Pyramid
Pyramid's security integration with Analysis Services is tight - allowing customers to securely query OLAP cubes or Tabular models and use any data level security definitions that have been included…
- Avi PerezAdmin
- "making the sophisticated simple"
- AviPerez
- 5 mths ago
- 2 replies
- 232
- 3
- Danielstaff5 mths ago
- Pyramid 2018 Blogs
Example of how to authenticate and embed Pyramid content.
Below is a simple example of a web page that displays Pyramid content and authenticates to the Pyramid Embed API in order to create a cookie for authentication.…
- Danielstaff
- Daniel
- 5 mths ago
- 238
- 1
- Pyramid 2018 Blogs
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…
- Danielstaff
- Daniel
- 5 mths ago
- 140
- Pyramid 2018 Blogs
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…
- Danielstaff
- Daniel
- 6 mths ago
- 149
- Pyramid 2018 Blogs
How to create a memory dump
Pyramid support may request a memory dump be sent to them. Please see below how to create the file: 1) Login to the Pyramid server and open the task Manager.…
- Danielstaff
- Daniel
- 6 mths ago
- 121
- Pyramid 2018 Blogs
Pyramid 2018 Geospatial Shapes summary
Please see the attached PDF for a summary of all the Geospatial shapes that are available for Pyramid 2018 mapping.
- Danielstaff
- Daniel
- 6 mths ago
- 5 replies
- 271
- Dave FacklerValued Beta Tester6 mths ago
- Pyramid 2018 Blogs
How to hide SQL databases that a user does not have access to
By default even if a user does not have access to an SQL database they can still view it when logging into SQL Management studio. Therefore the same behaviour will be seen in Pyramid when connecting…
- Danielstaff
- Daniel
- 6 mths ago
- 152
- Pyramid 2018 Blogs
Problems with printing? How to send us detailed diagnostic information.
If you have formatting issues when printing to Word,Power Point, PDF or HTML then sending us the following information can help us understand and fix the issue.…
- Danielstaff
- Daniel
- 6 mths ago
- 152
- 1
- Pyramid 2018 Blogs
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…
- Danielstaff
- Daniel
- 7 mths ago
- 221
- Pyramid 2018 Blogs
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…
- Danielstaff
- Daniel
- 9 mths ago
- 309
- Pyramid 2018 Blogs
How to backup and restore a PostgreSQL database
Before upgrading Pyramid, it is strongly advised to take a backup before hand. If using the built in PostgreSQL for the Pyramid repository database below is how to backup and restore the database if…
- Danielstaff
- Daniel
- 2 wk ago
- 549
- Pyramid 2018 Blogs
Model Definitions, Materialized Content & Data Security
Pyramid 2018 has a powerful modeling tool set that comes complete with a deep security framework that covers both data and content. As a data security platform,…
- Avi PerezAdmin
- "making the sophisticated simple"
- AviPerez
- 10 mths ago
- 1 reply
- 520
- 5
- samuel alma9 mths ago
- Pyramid 2018 Blogs
How to create a Pyramid 2018 website in IIS after an install.
If you have decided to use the IIS option after the Pyramid 2018 installation, you can add the site manually. First, you need to install the following IIS modules :…
- Yakov Shaul
- Yakov_Shaul
- 8 mths ago
- 1 reply
- 522
- Alister Hill3 mths ago
- Pyramid 2018 Blogs
Creating a large IMDB model fails.
When creating a new model to an "IMDB" data source, the model looks like it is created, but it cannot be queried in the green app (errors are shown). When looking at the size of the model it is very…
- Danielstaff
- Daniel
- 10 mths ago
- 274
- Pyramid 2018 Blogs
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.…
- Danielstaff
- Daniel
- 11 mths ago
- 277
- Pyramid 2018 Blogs
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 >…
- Danielstaff
- Daniel
- 11 mths ago
- 554
- Pyramid 2018 Blogs

1 2 Next

Access great information from Pyramid including Help articles, News, Announcements and Blog Topics on advanced techniques.

Members

View members

Recent Tweets

Follow @PyramidAnalytic

Pyramid 2018 Blogs

De-Duplicating Data Sets with Pyramid

De-Duplicating Data Sets with Python

Pyramid recommendations for routine content backup

How to clean up the Pyramid "General" Folder

Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector

Firewall Settings for Pyramid

How to setup a Amazon Load Balancer (classic) to work with Pyramid

Cube design tip

Pyramid's Calculation Engine Explained

Setting up security roles for Analysis Services with Pyramid

Example of how to authenticate and embed Pyramid content.

How to use "Custom Colors" in the "Color" Drop zone to set a specific color to a specific value in a grid.

How to change the default internal Pyramid website port

How to create a memory dump

Pyramid 2018 Geospatial Shapes summary

How to hide SQL databases that a user does not have access to

Problems with printing? How to send us detailed diagnostic information.

After upgrading Pyramid, it is not possible to access Pyramid using the URL host name defined in IIS

Adding a Tabular/Analysis data source that is not located on the same domain that Pyramid 2018 is installed on.

How to backup and restore a PostgreSQL database

Model Definitions, Materialized Content & Data Security

How to create a Pyramid 2018 website in IIS after an install.

Creating a large IMDB model fails.

How to read and use the Pyramid System Logs

Browser Settings for Windows Authentication

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources