-
Pyramid Usage Model and Analysis
Using Pyramid to analyze itself. The following document describes how to build a data model using Pyramid’s database repository as a data source to be able to analyze content usage and performance…
-
Analysis of streaming data with Kafka.
Introduction What if I don’t want to, or can’t wait for data to appear in a datawarehouse before I can analyse it? There obvious use cases like IoT, but every organisation can benefit from…
-
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,…
-
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,…
-
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.…
-
Cube design tip
When a Dimension name is identical to an Attribute name, The dimension property 'HierarchyUniqueNameStyle' should be set to 'IncludeDimensionName'. Currently, without this property set to 'include...…
-
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.…
-
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…
-
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 Geospatial Shapes summary
Please see the attached PDF for a summary of all the Geospatial shapes that are available for Pyramid 2018 mapping.
-
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…
-
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,…
-
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.…
-
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.…
-
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…
-
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,…
-
Installed Pyramid 2018 on an off-line machine? here is how you should proceed...
If there is no internet access on the server/computer where Pyramid 2018 has been installed, you can register in the customer portal for a community license.…
-
Getting Started with Pyramid
In our first session, we will cover the basic getting started workflow from Quick Model, to Discover and finally Present. These examples are simple and designed to acquaint you with the product.…
Blog Articles on functionality & techniques.