-
Community Tips: How to launch an Idea
How do I use the Pyramid Analytics Idea Forum? 1. Check for existing Ideas or Solutions: Sometimes your Idea has already been proposed by someone else, or even been solved in the Product.…
-
Pyramid Analytics User Community Guidelines
Welcome to the Pyramid Analytics User Community! From all of us at Pyramid Analytics, we're happy to have you here! What is the Pyramid Analytics User Community?…
-
Community Tips: Viewing, Editing your Profile and Account Settings
Viewing and Editing your Public Profile: Your profile in the Pyramid Community is your Business Card and Showcase to other users. This article will take you through the various options in your…
-
Community Tips: Direct Messaging in the Community
Using Direct Messages in the Community Using a direct message is an easy way to follow up on a question, or comment on an article or going deeper without being too public.…
-
Community Tips: How to ask a question on the Community
Question How do I post a question or start a discussion on the Pyramid Community? Answer To ask the community for an opinion or help you with a topic, all you have to do is to navigate to the…
-
Replace a current template in a presentation
We have changed our Master Pages/template and we would like to update all our existing presentations. Is there a way to edit/replace a current theme in a presentation?
- Answered
-
Is the Job Spooler available in Viewer version?
Some of our users have been moved to Viewer licenses. They have reported not being able to find the Job Spooler icon now. Is the Job Spooler functionality available in Viewer?
- Answered
-
Merge separate lines into one single line whilst retaining separated stacked columns
Hi there, For some context, the 'Gross Incurred Claim' measure refers to the stacked columns whilst the 'Rolling Average 12 Gross Incurred Claim' refers to the four separate dashed splines.…
- Answered
-
Find Difference between two dates
Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?
- Answered
-
Is there a way to move a CMS repository to different database vendor?
Hello, We want to move the CMS repository to a different database. We have them in Postgres and want to move them to SQL Server. Is there a way to port from one database to the other? Thanks,…
- Answered
-
sort or filter on subtotals
Hi, Im not able to sort or filter for the subtotals in dark green, to identify the largest quantity, moreover, I also did not manage to filter out the TOP5.
- Answered
-
Combining two discovery tables in present
Hi We have two tables which we are trying to merge. The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.…
- Answered
-
Unified slicer for two separate parameters
Hi We're building a dashboard which includes two main charts. The top one is sales data and the second is market share. Each one of them is attached to parameter (marked) which allows to switch…
- Answered
-
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:…
Welcome to the Pyramid User Community
Pyramid User Community