Pyramid
Solutions
Learn
Company
Pyramid Analytics
User Community
How to enable Javascript
Sign Up
Login
Home
Pyramid
Blogs
Blogs on functionality & techniques.
TOPICS
MEMBERS
Filter
Newest
Active
Most likes
Clear sort
Most likes
Most replies
Most views
Tags
Clear filter
Search
Join this category to participate in conversations and receive notifications when new posts are added.
JOIN
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 Birenzweig
Admin
Itamar_Birenzweig
1 yr ago
3
replies
465
11
Avi Perez
Admin
1 yr ago
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 Perez
Admin
"making the sophisticated simple"
AviPerez
8 mths ago
4
replies
138
9
Jasper Drenth
5 mths ago
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 Perez
Admin
"making the sophisticated simple"
AviPerez
2 yrs ago
2
replies
768
7
Brandon Kirsch
1 yr ago
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 Perez
staff
Ilan_Perez
1 yr ago
4
replies
106
3
Avi Perez
Admin
3 wk ago
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
2 yrs ago
9
replies
2,938
3
Rafi
1 yr ago
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
1 yr ago
360
3
Blogs
Cube design tip
When a Dimension name is identical to an Attribute name, The dimension property ' HierarchyUniqueNameStyle ' should be set to ' IncludeDimensionName '.…
Yakov Shaul
Yakov_Shaul
1 yr ago
72
3
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 Macdonald
Admin
Principal Technologist
Ian_Macdonald
1 yr ago
136
3
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 Perez
Admin
"making the sophisticated simple"
AviPerez
2 yrs ago
2
replies
315
3
Daniel
staff
2 yrs ago
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 Gordon
Pyramid Employee
David_Gordon
5 mths ago
38
2
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 Gordon
Pyramid Employee
David_Gordon
6 mths ago
39
2
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 Macdonald
Admin
Principal Technologist
Ian_Macdonald
1 yr ago
97
2
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 Macdonald
Admin
Principal Technologist
Ian_Macdonald
1 yr ago
71
2
Blogs
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.…
Daniel
staff
Daniel
2 yrs ago
661
2
Blogs
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.…
Rob Cowell
Pyramid Employee
Rob_Cowell
1 mth ago
14
1
Blogs
2020.10 Feature Focus: Audit Trail Framework
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 Gordon
Pyramid Employee
David_Gordon
5 mths ago
22
1
Blogs
2020.10 Feature Focus: Present Lite
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 Gordon
Pyramid Employee
David_Gordon
5 mths ago
16
1
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 Gordon
Pyramid Employee
David_Gordon
5 mths ago
52
1
Blogs
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 Gordon
Pyramid Employee
David_Gordon
5 mths ago
17
1
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 Buzaglo
staff
Dvir_Buzaglo
5 mths ago
26
1
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 Perez
Admin
"making the sophisticated simple"
AviPerez
10 mths ago
91
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 Gordon
Pyramid Employee
David_Gordon
1 yr ago
44
1
Blogs
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.…
Kristin Oostra
Director, Product Marketing
Kristin_Oostra
1 yr ago
2,367
1
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 Cowell
Pyramid Employee
Rob_Cowell
1 yr ago
177
1
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
40
1
Blogs
1
2
Next
Blogs on functionality & techniques.
Members
View members
Categories
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Recent Tweets
Follow @PyramidAnalytic
Home
Pyramid
Blogs
Product Ideas
Current Product Ideas
Completed Product Ideas
Product Announcements
Tutorial Videos
Technical Solutions
General
Performance
Databases
Security / Web
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Getting Started
Using BI Office
BI Office Installation & Configuration
Troubleshooting
Tags
View all tags
Key Resources
Community Tour
Register for Training Webinars
Newsletters, Events, and Webinars
Learning Resources
Pyramid Tutorial Videos
Pyramid Help
Getting Started with Pyramid
BI Office
BI Office Help