-
Dynamic Scaling of Analytics with Pyramid on Kubernetes
Pyramid’s multi-tiered service architecture is a perfect fit for Kubernetes-based container deployment, allowing distinct services to scale and shrink dynamically to match demand.…
-
Hybrid Data Connectivity via Pulse
With increased cloud choices, and distributed servers, it is common for many organizations to have a BI server in the cloud, remote data sources, and end-users in different locations,…
-
Gaining control of your data with Master Flows
Data preparation processes (ETL) frequently require workflow capabilities to conditionally trigger other processes and send notifications (email, text, etc.) when a task has completed.…
-
Faster processing and reduced resource consumption with incremental data refreshing
It’s very common for organizations to possess large datasets that only require periodic updates on a smaller subset of the data. In other words, only new data or data that has been recently updated…
-
How dynamic KPIs provide better views into constantly changing datasets
KPIs play a crucial role by providing an instant and intuitive graphic view of a business’s key performance metrics. In order to effectively create KPIs,…
-
Embedding with native HTML5
Companies increasingly need to include analytical content into their own applications and workflows, instead of having to access a separate application.…
-
Custom Maps and Coordinate Systems
If you load a GeoJSON file as a custom map in Pyramid and do not get any shapes displayed, it could be the coordinate system you are using, especially if you converted another file format to GeoJSON.…
-
Pyramid 2020.13 Issues Addressed
The following list enumerates all the main bug fixes and minor functional upgrades added to the 2020.13 version. Click here to see the full Pyramid 2020.13 release announcement.…
-
How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.
The "Percent of Total" calculation is a context calculation that is designed to factor the "shape" of the query in determining the scope of the calculation.…
-
Creating an IMDB Time column in the Model designer
In the current version of Pyramid (2020.10), the Time type column is not supported when creating an IMDB model. As a result, it will appear in a Discovery report but it will not be possible to…
-
Real self-service BI for SAP BW and HANA for Pyramid Customers
Pyramid is certified by SAP to interoperate with SAP BW/4HANA. Pyramid is pending certification by SAP to interoperate with SAP HANA. Pyramid also became an official member of the SAP® PartnerEdge®…
-
How to create a Week to Date or Parallel Periods list, for a week that starts on Sunday when using a sql data source
Week to Date, using a specific date: 1. Create a new List in Formulate 2. Drag ‘Week to Date’ into the canvas, choose a date under Pick a Member: 3. Set the Day of the week to start from 7,…
-
Creating a Date Time intervals in Data modeling tool
When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00). To do this,…
-
Pyramid 2020.10 Issues Addressed
Back to Pyramid 2020.10 release announcement The following list enumerates all the main bug fixes and small features added to the 2020.10 version. Application Fixes and Features Model Fixed an issue…
-
Improving Windows Authentication and Kerberos Delegation
As of version 2020.04.011, Pyramid will offer new settings to streamline Windows Authentication SSO implementations. This will offer the benefit of Win Auth and Kerberos delegation where and when…
-
The seven success factors of time intelligence
Date-time analysis is a central pillar of modern analytics. Every business needs to track progress over periods of time, and more importantly, compare and evaluate that progress between two time…
-
Pyramid 2020.02 (Service Pack 2) Addressed Issues
Pyramid 2020.02 (Service Pack 2) release announcement Bug Fixes Admin Fixed an issue where adding users from a CSV file caused duplication Fixed an issue where the Save Shareable Content for a…
-
Pyramid 2020.01 (Service Pack 1) Addressed Issues
Pyramid 2020.01.121 (Service Pack 1) release announcement Bug Fixes Admin Fixed a logging issue related to long MDX field names Fixed an issue where the number of licenses seen in the admin console…
-
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.…
-
Pyramid 2020 Addressed Issues
Pyramid 2020 release announcement Bug Fixes Admin Fixed an issue where a Tenant cannot be deleted Fixed an issue where the data sources Tenant shows as "Unknown" Fixed an issue where the Content…
-
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...…
-
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…
Blog Articles on functionality & techniques.