-
Actionable Analytics & Custom Workflows
Pyramid’s Custom Workflows provides users with new collaborative options from within the analytics platform for delivering actionable analytics that go beyond classic conversations and annotations.…
-
Pyramid 2020.25 Released
Pyramid 2020.25 (Service Pack 5 for 2020.20) has been released. It includes a collection of fixes for bugs and issues and some new features. Software The main installer files can be downloaded from…
-
How to backup and restore a PostgreSQL database
Before upgrading Pyramid, it is strongly advised to take a backup before hand. If using the built in PostgreSQL for the Pyramid repository database below is how to backup and restore the database if…
-
Publications- One attachment for multiple selections
Hello, I've got this publication that produces a list of open orders by requestor and year, for this year and the previous year only. To get only the years I need,…
- Answered
-
Sankey Chart - Source and Target Same Dimension
Hi I am looking to create a Sankey chart where the source is a month (I want to select a start month using a parameter) and the target is the same month dimension however I want to select an end…
- 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
-
Date Formats in Exported Excel Files
I've had a user complaining that when they export a discovery to Excel, they are unable to filter on date columns- normally in Excel when filtering dates, they are grouped together by year,…
- Answered
-
Creating a test environment from a production repository
The following article will cover PostgresSQL, SQL, And Oracle databases. Postgres When using Postgres as the Pyramid repository, to create a copy of an existing environment,…
-
Dynamic year range on loss triangle
Is it possible using Cube data to calculate the minimum policy year? The client is the main driver (but there are more slicers) and is made up of policies where the policy year comes from in the…
- 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
-
How to clean up the Pyramid "General" Folder
UPDATE: If you are using Pyramid 2020.20 and above, the maintenance tool is now built in to the product. The default path to it is- C:\Program Files\Pyramid\core\maintenance.…
-
Routine Content Backup Recommendations
The following are items we Recommend backing up periodically. (Preferably Daily but it's up to you) The database repository. If you don't know where it is, browse to HTTP:…
-
Logs Locations
Pyramid was created to cater to both enterprise-level and individual users. As a result, it can be divided among several servers, generating various logs that aid in analyzing the system.…
-
Variable List Measure, of a Variable List Measure
Some of our colleagues demo'd a dashboard where they had two parameters, one of which drove the visual i.e. a variable measure. They had 4 groups of measures, profit, reserving, claims and premium.…
- Answered
-
Change path of Discovery in Presentation
There are a lot of duplicates within our Discovery's. While cleaning this up, i stumbled across two of the same Discovery's. Both of them are used in the same presentation.…
- Answered
-
Line Breaks
Hi I've been asked if Pyramid can replicate a report a team currently have. The report has some summary information, and then some comments which the underwriter would input.…
- Answered
-
Parameterised Year To Date
Hi, is it possible to use a parameter to drive Year to Date for current year and previous year? My intention is for the user to select a month e.g. May 2022, this populates two lists.…
- Answered
-
Check when a model was last updated
I am wondering if there is a way to see when a model was last updated, if it hasn't got a schedule on it? I know how to check when a schedule was last completed but this model I'm looking at hasn't…
- Answered
-
Using Keystore Management Tool To Configure LDAPS or Content Migration Wizard in SSL Environments
UPDATE Any SSL certificates must be uploaded through the Pyramid Application and not directly into the Java store. See the help link below on how to do this: https://help.pyramidanalytics.…
-
Pyramid 2020.24 Released
Pyramid 2020.24 (Service Pack 4 for 2020.20) has been released. It includes a sizable collection of fixes for bugs and issues and some behavioral adjustments.…
-
Data Connector Changes in 2020.24
As of version 2020.24, certain data connectors have been removed from the standard installation for various reasons (licensing/paywall). Going forward, these connectors can still be used,…
-
PQL Date Query
I currently have a list that is relying on a parameter in a date format of "Mmm YYYY". This controls two separate formulations that utilise the YTD & lag functions so I can get a YTD and then a prev…
- Answered
-
Custom Groupings
Hi, Is it possible to create custom groups or show a different field name? I know we can produce sets, but this doesn't quite achieve what I would like to see as sets filter the data.…
- 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
-
Changing Filter Type in Analyze Further
Is there an option/ability to change the filter type (drop down, buttons, multi drop down etc) in Analyze Further when adding new dimensions to the 'Filters' Drop Zone?…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community