-
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
-
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,…
-
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.…
-
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.…
-
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 to create quantities sales report
Hi, I coudn't find answer on my question anyware so just creating new topic... I want to create a report for specific departments and subdepartments which will show me units sales of all product…
- Answered
-
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,…
-
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
-
Where can I find the query text information in the Pyramid repository database?
I'm building a transaction logs dashboard and can get most details from the transactionView table, but I can't find the query text information. Is the query text stored in the Pyramid repository…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help