Please enable JavaScript to continue!

Pyramid 2018 Blogs

Access great information from Pyramid including Help articles, News 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

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,…
- Ian MacdonaldAdmin
- Principal Technologist
- Ian_Macdonald
- 8 days ago
- 26
- 1
- Pyramid 2018 Blogs
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,…
- Mor GetzModerator
- Mor_Getz
- 11 days ago
- 9
- 1
- Pyramid 2018 Blogs
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…
- Jason Pickerstaff
- Jason_Picker
- 1 mth ago
- 54
- Pyramid 2018 Blogs
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
- 2 mths ago
- 37
- 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
- 2 mths ago
- 15
- 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
- 3 mths ago
- 64
- 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
- 4 mths ago
- 49
- 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
- 6 mths ago
- 146
- 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
- 7 mths ago
- 2 replies
- 247
- 3
- Danielstaff7 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
- 7 mths ago
- 257
- 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
- 7 mths ago
- 150
- 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
- 8 mths ago
- 5 replies
- 295
- Dave FacklerValued Beta Tester8 mths ago
- 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
- 11 mths ago
- 312
- 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
- 1 yr ago
- 1 reply
- 542
- 5
- samuel alma11 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
- 10 mths ago
- 1 reply
- 550
- Alister Hill5 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
- 1 yr ago
- 277
- Pyramid 2018 Blogs
How to fully uninstall Pyramid 2018 when the installer fails
If your installer fails, or if you have uninstalled Pyramid 2018 but some components were not removed, do the following: Uninstall the application properly from windows.…
- Danielstaff
- Daniel
- 7 mths ago
- 504
- 2
- Pyramid 2018 Blogs
Embedded Analytics with Pyramid
Pyramid makes embedding analytic content into 3rd party applications as easy as two lines of HTML code. The video above demonstrates how easy this is to achieve.…
- Yakov Shaul
- Yakov_Shaul
- 1 yr ago
- 8 replies
- 2,743
- 3
- Danielstaff7 mths ago
- Pyramid 2018 Blogs
Directly Query MongoDB with Pyramid
MongoDB is one of the preeminent unstructured data stores. Pyramid users can easily query MongoDB data without extracting it or writing complex scripts to “flatten” the data first.…
- Yakov Shaul
- Yakov_Shaul
- 1 yr ago
- 350
- Pyramid 2018 Blogs
Data Visualization Tutorial
One of the key drivers in the Pyramid 2018 design was the data visualization engine and the flexibility it affords to users in visualizing data for analytics through a huge number of combinations…
- Ilan Perezstaff
- Ilan_Perez
- 1 yr ago
- 676
- Pyramid 2018 Blogs
Querying Unstructured Data with Pyramid
The lack of effective methods for how to analytically use unstructured data is a common problem that we often hear from our customers. Getting the data in,…
- Avi PerezAdmin
- "making the sophisticated simple"
- AviPerez
- 1 yr ago
- 429
- Pyramid 2018 Blogs
How to upgrade Pyramid 2018 to the latest version
Backup the underlying Pyramid 2018 content database Download the latest installer from https://www.pyramidanalytics.com/download Run the downloaded installer on all Pyramid 2018 Machines in the…
- Danielstaff
- Daniel
- 9 mths ago
- 551
- Pyramid 2018 Blogs
PYRAMID 2018.01 - Known issues
NOTE: A hotfix release with solutions to these and other problems was released. Please check the customer portal for the newer version. Mapping Issue The mapping may stop working and/ or an error is…
- Danielstaff
- Daniel
- 1 yr ago
- 627
- Pyramid 2018 Blogs
How to change the website port for Pyramid 2018
In this article, we will explain how you can change the web site port from the default 8181 to a port of your choice. This article assumes that you are using a local Postgres instance for the…
- Guy LaviModerator
- Guy_Lavi
- 1 yr ago
- 592
- 1
- Pyramid 2018 Blogs
How to update your licence when moving your Pyramid 2018 install to a new server
NOTE : Relevant for version .81 The Pyramid 2018 license is tied to the machine key which is unique to each server/computer. Therefore when moving a Pyramid 2018 install to a new server it will be…
- Danielstaff
- Daniel
- 1 yr ago
- 499
- Pyramid 2018 Blogs

1 2 Next

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

Members

View members

Recent Tweets

Follow @PyramidAnalytic

Pyramid 2018 Blogs

Calculating Moving Averages in Pyramid IMDB

Union: Adding Attributes to a Node

How to leverage URL and Email Attributes in Actions

De-Duplicating Data Sets with Pyramid

De-Duplicating Data Sets with Python

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

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.

Pyramid 2018 Geospatial Shapes summary

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

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 fully uninstall Pyramid 2018 when the installer fails

Embedded Analytics with Pyramid

Directly Query MongoDB with Pyramid

Data Visualization Tutorial

Querying Unstructured Data with Pyramid

How to upgrade Pyramid 2018 to the latest version

PYRAMID 2018.01 - Known issues

How to change the website port for Pyramid 2018

How to update your licence when moving your Pyramid 2018 install to a new server

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources