-
Using same parameter for same model but pointing at different tables
Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…
- Answered
-
Using measure as an attribute
While working on a report I came across this issue: I have a list of accounts/ For each account, I have the number of days in which it was recommended. “Count recommendation date” is a measure that…
- Answered
-
Pyramid Community Weekly Wrap Up - Oct 11th 2024
Dear Community, Reflecting on the past four User Groups, we’re considering how we can improve in 2025. We want to know the best direction for our Webinars and Meetups.…
-
Maps in Pyramid
Hi, I am struggling to create a map at a region level for kenya, there is region level data in the model as you can see in the first snip below, however when I try to use this data to build a map at…
- Answered
-
Congratulations – Level 3 Certified: Joseph Hlongwane - Data Orbis
Pyramid Certified Level 3 Announcement Congratulations to Joseph Hlongwane and to DataOrbis, for adding the fourth fully certified consultant to their team.…
-
Dashboard Gallery: Telecommunications
Dashboard Gallery: Telecommunication Dashboard This dashboard has been built for customer who is working in telecommunication. It shows a maintenance overview about cross the network.…
-
Request for help with upgrade to JDK > 17.0.9 in Pyramid Build
I have installed Pyramid 2023.14.100 (September release) on an internal company server with an NCL license. I noticed that the JDK version of the build is currently 17.0.2.…
- Answered
-
How to use KPIs and Gauges in a Dynamic Way
How to use KPIs and Gauges in a Dynamic Way The Use Case Working with a customer, I recently ran into an interesting use case that required dynamic band values in a KPI and a gauge view.…
-
How to: Create a dynamic set of dates
Question: How to create a dynamic set of dates During a recent discussion we got asked how to create a dynamic set of dates. There are two approaches to the tasks,…
-
Extractions mensuelles
Bonjour, C'est mon tout premier post et je travaille en RH. J'ai une extraction mensuelle d'effectif que je souhaite envoyer chaque mois par mail. Donc par exemple en septembre je souhaite envoyer…
- Answered
-
Pyramid Community Weekly Wrap Up - Oct 4th 2024
Dear Community, Yesterday we had our fourth User Group of this series, 60+ Registrations marked a new all time high for South Africa. This means that more than 300 Users attended the recent Events.…
-
Help needed with Real-time data input and String search
Hello Pyramid Community, I wanted help with 2 items: 1) I am working on building a pyramid dashboard which simulates pricing decision. For this simulation,…
- Answered
-
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 Pyramid 2023.…
-
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
Welcome to the Pyramid User Community
Pyramid User Community