-
“Guided” Analytics using Pyramid
Use Guided Actions to create customized navigation elements “Guided actions” are a convenient and effective means of extending the classic flow of analytics.…
-
Smart report bursting with triggers and repeaters
As described in my previous blog post, bursting static analytic reports to recipients is still a very common “real-world” requirement—and it’s still a headache for many BI developers and…
-
Upgrading a Pyramid Oracle repository
This article only applies to older installations of Pyramid (prior to version 2020.28) that use an Oracle Repository database or those that have been upgraded subsequently from a pre-2020.…
-
Time Intelligence: How date lists and ranges accelerate insights
This is the fifth blog in the series on how Pyramid brings time intelligence into analytics. In my previous blogs, I demonstrated how Pyramid provides automatic date parameters to interrogate…
-
Pareto Analysis: Using the 80/20 Rule
In this second post on my three-part series on contextual calculations, I examine how Pyramid can quickly create business calculations like Pareto with just a few clicks.…
-
Time intelligence: Date-time groupings for better visibility
This is the second blog in the series on how Pyramid brings time intelligence into analytics. In my previous blog post, I introduced the concept of grouping amounts in data periods by adding date…
-
Data-driven dynamic tooltips that add even more context to Pyramid dashboards and reports
In analytics and BI applications, a tooltip can be an invaluable mechanism to display informational text when hovering a mouse cursor over a graphical item on a screen, dashboard, or report.…
-
Maintaining Data Models
Data modeling is now central to all business analytic processes as companies embrace the “Decision Intelligence” paradigm. Delivering advanced data modeling options in a self-service framework is…
-
Custom Data Connectors
Pyramid provides administrators the ability to self-configure connectors for almost any JDBC data source, providing users access to these data sources.…
-
How to build an “analytics lake” using Cross Model Mapping
Analysts building dashboards reach an impasse when attempting to combine visualizations from different data models (for example, a sales analysis from an SAP-based data model and marketing KPIs from…
-
2020.10 Feature Focus: Content Migration Tools
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…
-
Calculating differences without code
In part 3 of my blog series on contextual calculations (see part one and part two), I cover the powerful ability to calculate differences between current and previous row values for a metric and…
-
2020.10 Feature Focus Datavard Glue: SAP ERP Data Modeling
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…
-
Troubleshooting User Setup and Access Issues
Administrators occasionally need to check complicated settings and security structures for users. Sometimes the easiest and most reliable way to do so is to simply log in as that user.…
-
Persisting Visualization Colors
Pyramid’s persistent color feature maintains the same color in all visualizations for selected data elements, even after slicing or removing items from a chart.…
-
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,…
-
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,…
-
Multi-Factor Authentication
Multi-Factor Authentication Pyramid’s built-in multi-factor authentication (MFA) option adds a rock-solid layer of security to your BI application if your authentication provider does not offer it.…
-
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…
-
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…
-
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,…
-
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…
-
Comprehensive forecasting with Pyramid
Forecasting is a machine learning technique that uses historical data as inputs to determine expected future trends. Forecasting forms the basis for developing business strategies that include…
-
Fine tune your forecasts with advanced controls
In a previous blog, I discussed Pyramid’s unique forecasting capabilities, which give users the ability to choose from among eight algorithms to produce forecasts within existing reports and…
-
Forecasting with Python and Pyramid
Forecasting is an indispensable requirement for any modern organization looking to gain a competitive edge. To do it well, today’s companies need the flexibility to adjust algorithms and define…
Blog Articles on functionality & techniques.