Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
Latest Activity
Home
Profile
Ian Macdonald
Admin
Ian_Macdonald
Senior Director of Product
UK
Follow
Joined
Fri Oct 14 14:58:14 UTC 2016
996
posts
321
likes received
13
followers
Badges
17
3
Company
Pyramid Analytics
Country
United Kingdom
Latest Posts
Re: legend location
Hi anonymous client, You can place the legend where you want it in Discover and when brought into the Present canvas, the Discover renders as you defined it with the Legend where you put it.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: total filter but without the dimension in discovery.
Hi Nick, Create a Dynamic List of your References, filtered by the Premium being greater than 200. You could parameterise this to allow dynamic changing of the filtering value if you want.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
1
Questions & Answers
Reported - view
Re: Percentage points change
Hi Yakov, you can achieve this easily using the Quick Calcs in Discover. Click on the "+" icon in the vertical column of icons to the left of the Grid canvas.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Changing positioning of data labels in point graphs
Hi Guillermo, Please post a screenshot of what you are experiencing, with what you require clearly explained using the example as a base. We can then investigate more closely. Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Legend not showing on Matrix grid.
Hi Guillermo, I'm not quite sure what you are referring to. Here is my grid, with my Sales measure background defined by the value of Margin, the colours of which are shown in the Legend.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: Pyramid Analytics API
Hi Aadhil, There is extensive documentation of our REST API online. Many entries have example code in a variety of languages. Take a tour through the available functions to see if it will support…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: PDF / Document files as a Data Source in Modeller
Hi Richard, You can do this already through the Python Source Block in Model. Generally, we would be looking for tables of data in the PDF for loading into a DB for analysis.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Reported - view
Re: How to create a report without live connection?
Hi Yakov, Why not just schedule the Publish report for weekly execution and post the output to the bulletin board? Users can then simply view / download it off the bulletin board when they need to.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Questions & Answers
Accepted
Reported - view
Re: How to enable SSL on Pyramid website and forward all HTTP request to HTTPS
Hi Robin, Check out our Help for instructions on how to configure NGINX for use with Pyramid in a Linux environment. Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
1 yr ago
Security
Reported - view
Re: Merge separate lines into one single line whilst retaining separated stacked columns
Hi Ben, Unfortunately, using Claim Type in the Color Drop Zone will always split the measures into the different values of Claim Type, so you will always get a line for each claim Type showing the…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
1
Questions & Answers
Reported - view
Re: Publications- One attachment for multiple selections
Exporting to Excel does not replicate the layout of the page, rather it outputs each analytic view on its own sheet. Thus in the example above, yes, the grids for 2021 and 2022 will appear on…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
1
Questions & Answers
Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update? If not, I'll close out this question and mark it as Answered. Cheers, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Publications- One attachment for multiple selections
Hi Sophie, Publish is behaving exactly as expected and designed. With two slicers attached to the Publication, it will generate a report for each unique combination of slicer values, i.e.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Funny you should mention that, we're currently preparing for SOC II certification. Part of the audit is that every employee has to have taken product training through the LMS. So I have go do it..…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Equivalent to SUMPRODUCT in Pyramid
Hi Nick, There are two ways of doing this, depending on your model structure. 1. Using two flat dimensions We need to get the list of shops for each type, for each shop calculate profit*ratio,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
3
Questions & Answers
Reported - view
Re: Date Formats in Exported Excel Files
Hi Sophie, When working with dates in calculations in IMDB or other SQL database based model, Pyramid makes use of a SQL Date type field that represents dates as an number (usually the number of…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Multipage Repeater
Hi Nick, You mean like this? https://community.pyramidanalytics.com/t/60h5as0/repeater-selection If so, vote for it and we'll assess the feasibility. Hope that helps. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Sankey Chart - Source and Target Same Dimension
Hi Nick, Any update on how you want this chart to look? Or shall I close this item? Thanks, Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, While you can certainly use multi level Hierarchies as parameters, currently the Hierarchy Tree in the drop down widget visualisation is not supported for Parameters.…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, OK, making some assumptions here: 1. When you say "Cube" data you are referring to SSAS OLAP or Tabular cubes; 2. You want to display the Range to be dynamic based on the first and last year…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, Have you also tried the "Show Empties" button on the Query Toolbar? This will force rows and/or columns to be displayed even when there is no data within them: Hope that helps,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Dynamic year range on loss triangle
Hi Ben Or indeed the ending year if there have been no claims or premiums? Or does it not matter at the start and end, only the inner range? There are numerous ways to approach this,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Dynamic year range on loss triangle
Hi Ben, It's not clear from your description what the desired output should be. Do you want the years between the start and end years where there is no data filled in with zeros or do you want the…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Change path of Discovery in Presentation
Hi Angeline, I don't believe there is a way to do this. Ian
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
Re: Variable List Measure, of a Variable List Measure
Hi Nicholas, You're nearly there! Create a Global Parameter set as discrete options and add the text and returning value you need: Create a dynamic list,…
Ian Macdonald
Admin
Senior Director of Product
Ian_Macdonald
2 yrs ago
Questions & Answers
Reported - view
1
10
11
12
13
14
21
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
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
View all topics