Skip to main content
User Community
Pyramid
Help
Learning Hub
Support
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Questions & Answers
Explore Pyramid
Product
Events & News
Member Lounge
Latest Activity
Home
Profile
Alex Scott
Pyramid Employee
alex_scott
London
Follow
Joined
09 Aug 2021
21
posts
18
likes received
1
followers
Badges
694
1
1
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: Calculation of a ratio
Jona, on a second review I might have misunderstood your question. The explanation is in English but the P&L table is German. Before I take another guess would you be able to more clearly state the…
Alex Scott
Pyramid Employee
alex_scott
10 days ago
Questions & Answers
Reported - view
Re: Calculation of a ratio
Hi Jona, I think what you are looking for is a context calculation. It is covered in the following section of the help.…
Alex Scott
Pyramid Employee
alex_scott
10 days ago
Questions & Answers
Reported - view
Re: In a Discovery, how to identify records that do not have a corresponding child record
Hi @Robert , There are probably several ways to achieve the required result. One option in Pyramid 2023 or higher is to use the 'text' aggregation function in model then searching the resulting…
Alex Scott
Pyramid Employee
alex_scott
1 mth ago
2
Questions & Answers
Reported - view
Re: How to obtain a value from the same day in the previous year
@Stephen Forster , easiest way is to create a date parameter for the current date. Select the parameter in the formulate then click on the function button for the parameter and add the lag.
Alex Scott
Pyramid Employee
alex_scott
2 mths ago
Questions & Answers
Reported - view
Re: How to define a Design Theme for grids with a single-color background?
I may have misunderstood your question but did you take a look at Grid Quick Styles options. There is a style option for "no background". Link to the Pyramid help file topic https://help.…
Alex Scott
Pyramid Employee
alex_scott
6 mths ago
Questions & Answers
Reported - view
Re: Top 10 By Measure
Hi Len, here is a similar example of qty sold by part number. The filter wizard (filter options on the toolbar) will help with this use case. You can define as a fixed Top 10 or use a parameter to…
Alex Scott
Pyramid Employee
alex_scott
8 mths ago
1
Questions & Answers
Reported - view
Re: SAP blocks usage of ODP (Note 3255746)
In a short summary, Pyramid doesn’t use the ODP APIs and does not extract SAP data. Instead, it DIRECTLY queries SAP BW & SAP HANA. Further information on SAP Note 3255746 in relation to Pyramid can…
Alex Scott
Pyramid Employee
alex_scott
11 mths ago
1
Questions & Answers
Reported - view
Re: Case Statement in model
@Tabitha DeCaprio I am sorry but I don't fully understand what you are trying to achieve. Would you be able to provide a full explanation along with some sample data (please don't share any real data…
Alex Scott
Pyramid Employee
alex_scott
1 yr ago
Questions & Answers
Reported - view
Re: Case Statement in model
If you are creating a custom column the case syntax is... Case([SGBSTDN_TERM_CODE_ADMIT] >="201650" and [SGBSTDN_TERM_CODE_ADMIT] <= "201940","6th Year",…
Alex Scott
Pyramid Employee
alex_scott
1 yr ago
2
Questions & Answers
Reported - view
Re: Is there a way to filter out rows that are only showing inf and -nan(ind)?
If it is the same "IPM Provider Names" that always give the 'inf' or 'nan' result then you can use eliminations to remove the rows. This will hide the problem but not solve it.…
Alex Scott
Pyramid Employee
alex_scott
1 yr ago
1
Questions & Answers
Reported - view
Re: User Login Stats
I suspect it is EPOCH value. The number of milliseconds since the 1/1/1970.
Alex Scott
Pyramid Employee
alex_scott
1 yr ago
2
Questions & Answers
Reported - view
Re: Is there a way to list all assets in the repository with the folder they are in?
This is answered in another Q&A article https://community.pyramidanalytics.com/t/m1hmzy7/how-to-get-the-content-path-from-the-pyramid-repository-in-usage-reporting
Alex Scott
Pyramid Employee
alex_scott
1 yr ago
2
Questions & Answers
Reported - view
Re: Additions to conditional formatting
By default, when adding the color field to the drop zone Pyramid applies a linear continuous dual banded format to the values. If you have outliers in the data or it is non-symmetrical this may not…
Alex Scott
Pyramid Employee
alex_scott
3 yrs ago
Questions & Answers
Reported - view
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Highlights
Product Ideas
Current Product Ideas
Archived Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
Member Lounge
View all topics