-
What is the "AI Driven Value" option?
Hello, I see there's a new option, when right clicking on dimension attribute, labeled "AI Driven Value" How do I use this? I searched the help documentation and the community forums and can't find…
- Answered
-
Text parameter which retrieves date ranges
Hello everyone, Is it possible to map text captions in a parameter to individual list objects. The business context is to enable the formation of date ranges which are either calendar or fiscal in…
- Answered
-
Can R or Python models be easily imported into a Data Model?
Hello, We have existing R and Python models developed in RStudio. Is there a way for us to import these models into a Pyramid Data Model? Thanks, Rob
- Answered
-
PQL for checking if date is null
Trying to find the correct syntax for checking if a date is null in a script formulate. Currently accessing the date via [pyramid_custom_query_t_placement_patient_hsptl].[cl_effective_from_date].…
- Answered
-
Custom user dimension linked to a specific e-mail account
Dear all Irrespective of my attempts, I still need to succeed in creating a dimension of specific users/clients with a particular e-mail account suffix.…
- Answered
-
Sortting on aggregated measure on PostgreSQL
Hey all, I'm looking at trying to find the latest date for user logins in pyramid, using the username dimension and then creating a max formula for date dimension to find the most recent date.…
- Answered
-
How to Upgrade a Pyramid Kubernetes Cluster
Before upgrading your production install of Pyramid, it is imperative that you upgrade a test install of Pyramid based on a copy of your production database.…
-
Cascading parameters
Hello folks. Does Pyramid have the ability to build cascading parameters? I would like to have a text parameter control the output of two independent numeric parameters. Cheers, Dave
- Answered
-
Renaming direct query table does not change underlying name that is used. Correct functionality or a bug?
When renaming a direct query table, the original table name is often used in other areas (security scripts, join statements as shown in attached image).…
- Answered
-
Date filters allow range and null selection
Use case: Users need to be able to select a date range (YTD 2023 for example) and also have the ability to return the rows that have a NULL date. Using the multi select dropdown is not an suitable…
- Answered
-
Pyramid Community Weekly Wrap Up - July 14th
Dear Community, last week I was talking with one of the Users. He mentioned that with the growing activity level in the community, he receives a lot of e-Mails from the Platform.…
-
Splitting dataset Train Error
I am trying to spilt dataset into a train and test using Python Node and Learn&Predict. I get an error below related to pyramid_eval_out.write. How can it be fixed? Error PyramidException:…
- Answered
-
Pyramid Community Weekly Wrap Up - July 6th
Dear Community, slow start to the week for my US Colleagues with two days celebrating, luckily enough no Aliens in sight to battle, just the usual fireworks and BBQ.…
-
Customer Community Activities: Pyramid User Community
Explore Pyramid Data Missions: The Pyramid User Community offers a broad set of features to learn, share and interact with peers from all over the globe.…
-
Send Multiple discovery in single Excel sheet
Hi, I'm working on a publication, in which I have multiple discovery reports. When I try to export to excel, the generated excel creates multiple sheets for each discovery.…
- Answered
-
Customer Community Activities: Pyramid User Groups
Pyramid Innovator User Groups: Pyramid User Groups can be run in a variety of formats. From virtual meetups, through local gatherings to hands-on sessions and workshops.…
-
How to Create a Custom Bin Range in Data Model
The Data Model module includes a Bin algorithm under the Machine Learning section that will generate bins based on standard deviation or percentiles. How do I create my own custom ranges?…
- Answered
-
Identifying Duplicated Elements
Hi all, I have a discover object containing products and their status. I want to identify products where the attribute status is duplicated. i.e. Products where the status has been assigned more than…
- Answered
-
Pyramid Basic Data Sets #1 - Looking for a scorer or a sorcerer? Get analyzing now
More to play outside of our Challenges While we were building the Explore Server and started the monthly Challenges, we thought 'is that enough, or would it be fun to have more data sets to start…
-
Multi-measure pie charts
I have to measures in percentage that add up to 100% and I want to show in one pie chart both of them. I'm using version 2020.27.113 but it doesn't work for me. Could you please explain how to do it?
- Answered
-
Congratulations – Level 3 Certifications: 5x Tigma Tech
Pyramid Certified Level 3 Announcement This week we had the pleasure to certify a whole team of consultants. It is a huge achievement and shows the interest in the certification program.…
-
Pyramid Community Weekly Wrap Up - June 29nd
Bam, first half of the year done. Up here in the northern hemisphere the days are getting shorter again and our colleagues in South Africa are hoping for warmer weather.…
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
Community Newsletter No#3 - 2023
Welcome to our third edition of the Pyramid Community and Education Newsletter! It's been an eventful month: Pyramid 2023 is out, which means we have added a lot of new and updated content in…
-
How to speed up Queries running against an AWS Aurora RDS MySQL database instance?
AWS RDS Aurora MySQL 5.7.12 Query Performance In a recent customer scenario we encountered some unexpected performance issues when connecting to a AWS RDS Aurora MySQL 5.7.12 as data source.…
Welcome to the Pyramid User Community
Pyramid User Community