-
Congratulations – Level 3 Certified: Joseph Rajkumar - KASH TECH
Pyramid Certified Level 3 Announcement Congratulations to Joseph Rajkumar and to KASH TECH, the next partner to join the growing list of fully certified consulting partners.…
-
Tip of the Day - How to Replace Nulls with Zeros
How to Replace Nulls with Zeros This tip will walk you through how to manipulate a column within Model, to replace NULLS with Zeros, using the convert and replace nodes within a data flow.…
-
Help needed with Box plot on Discover
Hi Pyramid Community, I was building a box plot to be used in a dashboard. However, for one of the attributes, the box plot seemed very off compared to the data points.…
- Answered
-
Enabling Python Functionality on Servers with Limited Internet Access
Installing Pyramid with limited internet access may prevent Python from being installed. To ensure Pyramid installs Python correctly, please allow access to the following URLs: For Windows: https:…
-
Congratulations – Level 3 Certified: Ajay Sampath - Tigma Tech
Pyramid Certified Level 3 Announcement Make that 10 (ten) certified Consultants at our partner Tigma Tech - this is currently the largest number of fully certified consultants in a single Consultancy.…
-
How Pyramid Determines the Maximum Number of Rows in Reports and Queries
In Pyramid Analytics, managing data queries efficiently is critical for system performance and memory usage. Understanding Query Limit Settings The below settings are located in the Admin Console…
-
Conditional formatting in tabular grid
I have a RAG column that has the values - Green, Yellow, Red. I want to replace these words in my tabular grid discovery with a green circle, when its Green, yellow circle, when Yellow,…
- Answered
-
Is there a way to get the current logged in user?
I want to retrieve the current logged in user. The API Gets details for the current user. (pyramidanalytics.com) returns "devservicerw" as the current user,…
- Answered
-
Pyramid Community Weekly Wrap Up - Sept 27th 2024
Dear Community, its User Group Season. Last week London, and this Tuesday started with our Israeli Users. Great attendance and more than 50 Users attending in parallel growing to an impressive size.…
-
Schedule Model Refreshes for a window of time
Hello, Is it possible to schedule a model refresh every M - F between 8 AM and 6 PM every 15 mins ? I know I can setup multiple schedules one every Mon every 15 mins,…
- Answered
-
Congratulations – Level 3 Certified: Charlotte Norris - Snap Analytics
Pyramid Certified Level 3 Announcement Each addition to the growing group of fully certified Consultants shows that our Partners invest in Pyramid and our Customers are asking for their service.…
-
PeriodstoDate (MDX) for InMemory (PQL) List
Hello Community, Is there any way to create a PeriodstoDate List for a InMemory Datamodell? It seems that InMemory Modell List's work only with PQL Code (look pic.1) pic.…
- Answered
-
Replace no values with -, N/A, or no data
Hi! I've read the two threads on replace null with 0 and @Moshe Yossef 's thread on a join that looks like it has no data but the ifnull doesn't work because of no data in the fact table.…
- Answered
-
Discrepancy Between Displayed Rows in Visualization and Row Limit
Hi PA Team! When using a visualization with a large table (e.g., containing millions of rows), there is a discrepancy between the number of displayed rows and the established limit (e.g.…
- Answered
-
Limitation on the Number of Items in the Favorites List
Hello PA Team! Problem Description: When adding more than 20 items to the favorites list, items beyond the 20th are not displayed in the list. Steps to Reproduce: Open the favorites list.…
- Answered
-
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.…
-
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
-
Leveraging Filters, Lists, Measures, etc.
I have three tables: kris_base, risks_base, and kris_risks_bridge. From my Risks_base, in a matrix, I'm pulling in the Risk Category field that gives me a listing of Risks.…
- Answered
-
Top 10 By Measure
Hi I am trying to resolve the following use case: I have a table in my DW that contains the a list of tables, their size in GB, dates and schema. I need to create a Discover that will show me the top…
- Answered
-
Pyramid Community Weekly Wrap Up - Sept 20th 2024
Dear Community, a busy week. Over in London meeting real users at real events. Virtual simply can't beat the atmosphere and interaction in a room. Best place to meet are our User Groups,…
-
Tip of the Day - Time Calculation Wizard
How to use the Time Calculation Wizard Time calculation wizard in Discover is designed to help users quickly and easily generate a variety of date time calculations to be used in your analysis,…
-
Dashboard Gallery: Bourbon Selection
Dashboard Gallery: Burbon Selection Selecting the right Bourbon can be a fun but also a very expensive process. Why not let a Business Intelligence Dashboard help you in the process.…
-
Pyramid 2023.14 Released
Pyramid 2023.14, a service pack for Pyramid 2023, has been released. It includes fixes with a few minor features. Importantly, it includes the final preview of API 3.…
-
API3 breaking changes
With the release of 2023.14, API3 Beta is in its final preview release, ahead of its production release in the next subsequent version. In 2023.14, some changes were made to functions, itemized below,…
-
Preparations for our User Group London
Nothing is more exiting than an empty room before you start an event. Virtual just can't give you the same thrill. Will anybody turn up. What is the No Show Rate (highest rates are in New York,…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help