How to enable Javascript

Blogs

Blogs on application functionality & techniques.

TOPICS MEMBERS

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

JOIN

2020.10 Feature Focus: Flow Grids and Flow Charts
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
- David GordonPyramid Employee
- David_Gordon
- 2 days ago
- 4
- Blogs
2020.10 Feature Focus: Data Catalog - Toolkit (Part 2)
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
- David GordonPyramid Employee
- David_Gordon
- 2 days ago
- 13
- Blogs
2020.10 Feature Focus: Data Catalog – Self-Building Capabilities (Part 1)
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
- David GordonPyramid Employee
- David_Gordon
- 2 days ago
- 24
- Blogs
2020.10 Feature Focus: Ragged Asymmetric Queries
The ragged query feature in Pyramid helps users create highly complex views of data that are extremely difficult to achieve with a standard BI tool. It allows users to easily “laser” out content…
- David GordonPyramid Employee
- David_Gordon
- 2 days ago
- 20
- 2
- Blogs
Calendar Slicer
2020.10 is the latest release from Pyramid Analytics. It extends the functionality introduced in our major 2020 release. This is one in a series of posts that highlights some of the major new…
- David GordonPyramid Employee
- David_Gordon
- 2 days ago
- 20
- 1
- Blogs
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…
- Dvir Buzaglostaff
- Dvir_Buzaglo
- 2 wk ago
- 18
- Blogs
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,…
- Galit BacklundModerator
- Galit_Backlund
- 3 wk ago
- 9
- Blogs
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,…
- Dvir Buzaglostaff
- Dvir_Buzaglo
- 3 wk ago
- 14
- Blogs
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.…
- Dvir Buzaglostaff
- Dvir_Buzaglo
- 13 days ago
- 11
- 1
- Blogs
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…
- Yakov Shaul
- Yakov_Shaul
- 3 wk ago
- 74
- Blogs
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®…
- David GordonPyramid Employee
- David_Gordon
- 3 wk ago
- 35
- 2
- Blogs
Database Write Back
Pyramid is often asked when they will add a "write back" option to the tools. Often such functionality is centered around capturing end-user data input or budgeting and planning applications.…
- Avi PerezAdmin
- "making the sophisticated simple"
- AviPerez
- 3 mths ago
- 4 replies
- 119
- 8
- Jasper Drenth2 days ago
- Blogs
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…
- Avi PerezAdmin
- "making the sophisticated simple"
- AviPerez
- 4 mths ago
- 87
- 1
- Blogs
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…
- David GordonPyramid Employee
- David_Gordon
- 6 mths ago
- 40
- 1
- Blogs
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…
- Yakov Shaul
- Yakov_Shaul
- 7 mths ago
- 180
- Blogs
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…
- Yakov Shaul
- Yakov_Shaul
- 9 mths ago
- 167
- Blogs
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…
- Yakov Shaul
- Yakov_Shaul
- 10 mths ago
- 304
- 3
- Blogs
How to connect Google Sheets to Pyramid
Pyramid can model and blend numerous complex data sources for basic or advanced analysis. The quick tutorial below shows how you can use Pyramid to access and import data stored in a Google Sheet,…
- Ilan Perezstaff
- Ilan_Perez
- 11 mths ago
- 2 replies
- 86
- 3
- Yakov Shaul5 mths ago
- Blogs
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…
- Itamar BirenzweigAdmin
- Itamar_Birenzweig
- 8 mths ago
- 3 replies
- 380
- 11
- Avi PerezAdmin9 mths ago
- Blogs
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…
- Rob CowellPyramid Employee
- Rob_Cowell
- 1 yr ago
- 137
- 1
- Blogs
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
- 1 yr ago
- 92
- 2
- 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 Getz
- Mor_Getz
- 1 yr ago
- 35
- 1
- 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 yr ago
- 113
- 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
- 1 yr ago
- 65
- 2
- 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
- 1 yr ago
- 49
- Blogs

1 2 Next

Blogs on application functionality & techniques.

Members

View members

Recent Tweets

Follow @PyramidAnalytic

Blogs

2020.10 Feature Focus: Flow Grids and Flow Charts

2020.10 Feature Focus: Data Catalog - Toolkit (Part 2)

2020.10 Feature Focus: Data Catalog – Self-Building Capabilities (Part 1)

2020.10 Feature Focus: Ragged Asymmetric Queries

Calendar Slicer

Creating an IMDB Time column in the Model designer

How to create a Week to Date or Parallel Periods list, for a week that starts on Sunday when using a sql data source

Creating a Date Time intervals in Data modeling tool

How to apply Cumulative Function (Percent of Total) of rows/columns in Charts.

Pyramid 2020.10 Issues Addressed

Real self-service BI for SAP BW and HANA for Pyramid Customers

Database Write Back

Improving Windows Authentication and Kerberos Delegation

The seven success factors of time intelligence

Pyramid 2020.02 (Service Pack 2) Addressed Issues

Pyramid 2020.01 (Service Pack 1) Addressed Issues

Pyramid 2020 Addressed Issues

How to connect Google Sheets to Pyramid

Pyramid Usage Model and Analysis

Analysis of streaming data with Kafka.

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

Members

Categories

Tags

Recent Tweets

Home

Tags

Key Resources