-
How to show URL icons in matrix grid?
Hello, I have a requirement to show URL icons in matrix grid. I am able to show URL's under question as URL after doing MAX of the URL value but i need to show it as URL icons.…
- Answered
-
External IMDB Service Setup
We have been advised to set up the IMDB (in-memory database) service on a separate server for our multi-tenancy architecture. We're looking for detailed documentation or resources that describe how…
- Answered
-
Data Model - summarize column, unique row
Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Answered
-
Model app missing from Explore Pyramid
Hello, I'm trying to work through the Data Modeler certification modules using explore.pyramidanalytics.com however the Model app isn't showing (see image). How do I get it added? Much Thanks, Sarah.
- Answered
-
Geocode Missing error
Hi, I got results on state wise data on discovery. But In presentation I getting geocode missing error in state region on united states country. how to resolve geocode location issue?
- Answered
-
Count of last three months regardless of year
I have two filters year and month for few years where I want to find the count of members for the last three months . For say if am selecting year 2023 in the filter and the month December in the…
- Answered
-
Illustrator
I have a gender pie chart with values male female and unknown where I want to insert icons instead of data labels for male female and other which I want that to be dynamic if the value changes for…
- Answered
-
SAP blocks usage of ODP (Note 3255746)
Can someone at Pyramid confirm the impact of this significant change made by SAP on our continued integration on SAP BW and SAP HANA? Most of our company uses Pyramid for direct analytics on SAP.…
- Answered
-
Concerns about Python Access
Hello, On our Pyramid installation, we're looking to host multiple tenants. However, we've encountered an issue where we can access the host's file system through Pyramid,…
- Answered
-
Date comparison with DateDiff
Currently the date comparison of two dates can only be done with one format “yyyy-MM-dd HH:mm:ss”, but to work with another one the DateDiff function does not work correctly.…
- Answered
-
Rolling average formula
I'm currently trying to create a formula to calculate the 3 week rolling average, the reason we're doing it in formulate rather than through the context calculations is because it will form part of a…
- Answered
-
Using an Excel List or Power BI list to Filter Pyramid Report
Hello, I have a Pyramid dashboard built out that pulls a report every week and I am currently manually removing lines that are not needed by doing a VLOOKUP between the pyramid export and the excel…
- Answered
-
PPT related queries.
1. How to Remove PPT Notes by default? 2. How to Print the PPT with added Guidelines. 3. In Publication cover page I've added the UserEmail() as dynamic text.…
- Answered
-
REPLACE- EMPTY VALUES
In reports when working with values using formulate we are able to replace the null values . In the given scenario we need to replace the empty values .…
- Answered
-
Create a Text Column
How do I create a text column which shows up a dimension in the discover? I am also curious on different methods that can be used to achieve this. Use Case:…
- Answered
-
Font color not working on light blue color background .Ex Font color :#FFFFFF, Background Color:#85CCDB
For example see the attachment: I need all the headings in white Font.
- Answered
-
How to apply borders, based on grouped columns
We tried to apply border, based on vertically grouped column. Specifically, we need to apply the border like the following image. The main column contains three child columns.…
- Answered
-
How to define a common scale for primary and secondary Y-axis?
I have a (stacked) bar chart with two measures - one measure on the primary Y-axis, the other on the secondary y-axis. As these two measures should be comparable (imagine e.g. incoming vs.…
- Answered
-
Calculation based on Date Filter Range
I am looking for a calculation of a value divided by month; however, the number of months is dynamic depending on the overall date range that the user has set.…
- Answered
-
What is the maximum size for a text variable?
Hello, I am seeking information on the maximum allowable size for a text variable within Pyramid Analytics. Currently, I am utilizing a REST API node within a master flow,…
- Answered
-
Case Statement in model
Hello! Wondering if someone could help me with a case statement that i have been unsuccessful with and have tried it many ways... Any help would be greatly appreciated.…
- Answered
-
Local storage of "In Memory" DB
Assuming i want to do a data model and i want to story it locally for speed of access (a bit like Tableau allows you to store the data encapsulated in the report),…
- Answered
-
Filter Selected Date
If user selects one date the data has to retrieved from starting date to till selected date Lets say I have 5 years data for an insurance company where I have applied several filters in the…
- Answered
-
How can I control the Size and Position on a more granular level
Currently, when adding an element to Present, the Size and Position options are set to increments of 10. This does not allow for design flexibility for developers.…
- Answered
Content aside
Category 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