-
PQL Dynamic text formatting
Hi, I'm trying to write a PQL for dynamic text, so that when the data value selected in my matrix is equal to or greater than 0 it's formatted as Green.…
- Answered
-
Create general tabs in the My Hub (Home) area
Hello Pyramid, we think the Home or My Hub environment is a great idea. However, we would like this environment to be displayed by default when Pyramid is started.…
- Answered
-
Revoking Admin/User tokens
Referring to the below REST API reference, the admin token generated using REST API seems valid forever, Is there any way to revoke/invalidate the token once generated.…
- Answered
-
Rename an element?
A quick question, and quite possibly something I have overlooked, but, is it possible to do an ad-hoc renaming of specific members within a hierarchy, in a fashion similar to altering the caption…
- Answered
-
Data bar indicators in discovery matrix grids 'didappaear' when all metric values are negative
I have 9 custom metrics presently displayed in a matrix grid. These were all built (to the best of my knowledge) in an identical fashion. I have applied conditional formatting to each of the metrics.…
- Answered
-
Mimic member logic within lists
Hello folks. I have a very handy variable list object which filters a large number of products into the end-user's desired internal product categories. I would like to now compute the percentage…
- Answered
-
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
-
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
-
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
-
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
-
Analyse Further Multiple Measures on 1 Line Chart
If you are using analyse further, is there a way to get 2 measures on the same line chart?
- Answered
-
CSV File Export - Scientific Format
Hi We're exporting queries/pyramid content to S3 (as csv file, via Model) and the measures are always coming out in scientific format (E-). Even when we define the column as Float (directly or by…
- Answered
-
Bell curve graph
hi, the business is looking to use bell curve graphs in Pyramid to depict performance (using MEAN and Std Deviation and normal distribution). We are struggling to make it work, any insights welcome.…
- Answered
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
Data Model - Filter source before Filter
Our Sales data currently consists of roughly 180.000.00 rows. I noticed that when you want to extract sales, for lets say a week, Pyramid waits until all rows on the source have been read.…
- Answered
-
Comment modéliser mes données correctement
Bonjour à tous, je dois réaliser un reporting en fonction de ce fichier excel. Sur des graphiques, je dois afficher le nombre de journées CP en fonction du nombre de journées.…
- Answered
-
Line Banding, different bandings for different classes. Swap dimensions.
Is it possible to have a dimension switch similar to how we deal with measures, so a set of buttons to pick x or y dimension? The reason being I have a report which shows exposure,…
- Answered
-
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item: In each store,…
- Answered
-
Equivalent to SUMPRODUCT in Pyramid
Hi I have to do a weighted average calculation to calculate a market average. In excel I would use sum product where I can't get the numeric value for the %'s and created a weighted average.…
- Answered
-
Multipage Repeater
We have three publications one for Premium, one for Claims & one for Reinsurance. On each of these we have a page repeater to show a page for each class of business for example property, casualty,…
- Answered
-
Displaying two grids as 1
Hi I have two tables that I am placing side by side in a presentation, Table A with values for 6 measures for a Company (C) and Table B with 6 percentage measures for C and 2 aggregate groups,…
- Answered
-
Grid Size and Scrolling
When building grids in Discover, it seems to be divided into two distinct areas for dimensions on the left side and measures on the right. When you have more dimensions than will fit in the left…
- Answered
-
Display "all" in dynamic text when user selects all options in multiselect dropdown
We have a multiselect dropdown slicer that has a lot of values and when a user clicks the All button in the dropdown it is populating the dynamic text with all the options.…
- Answered
-
Additions to conditional formatting
Hi I reckon this should be a simple one. Essentially it's a combination of the logical band with "positive negative" and the continuous linear function. Say I have a range going from -50 to +200.…
- Answered
-
Export/Publish to google spreadsheets
Dear all, we're introducing google workplace in our company and are wondering whether it is possible to export/publish to google docs/spreadsheets directly. Best regards, Olaf
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
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