User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Create post
Q&A
Latest Activity
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
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
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Got stuck with a report? Start a discussion or help others to move forward.
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Status
Answered
Unanswered
Tags
Search
Follow
0
Eliminate visual indicator on eliminate datapoint
Hi is it possible to eliminate a visual indicator on a data point? I have a report which shows by Quarter , i only want to show Q1 to Q3, and eliminate Q4,…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
7 mths ago
6
replies
47
Last reply
Christian Langmayr
Admin
6 mths ago
Q&A
Answered
Answered
0
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?
alicia_me
Customer
alicia_me
7 mths ago
2
replies
32
Last reply
alicia_me
Customer
7 mths ago
Q&A
Answered
Answered
0
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.…
Benjamin Reed
Customer
Benjamin_Reed
updated
7 mths ago
2
replies
50
Last reply
Benjamin Reed
Customer
7 mths ago
Q&A
Answered
Answered
0
Legend not showing on Matrix grid.
How can I show a legend in a matrix grid? mine doesn't show up even when I turn it on. I would also like the legend to show the break points between colors (it's a band).
Guillermo Dominguez
Customer
Guillermo_Dominguez
8 mths ago
1
reply
22
Last reply
Ian Macdonald
Admin
6 mths ago
Q&A
Answered
Answered
0
Changing positioning of data labels in point graphs
Is it possible to change the position of data labels in point graphs? It seems possible to do with line graphs, but the positioning feature disappears when doing a line graph.…
Guillermo Dominguez
Customer
Guillermo_Dominguez
8 mths ago
1
reply
27
Last reply
Ian Macdonald
Admin
6 mths ago
Q&A
Answered
Answered
0
How to create a report without live connection?
Hi We are looking at creating some reports (in publish) that we would only want to refresh once a week. In this way we are trying to find a way to create some type of saved report that would save…
Yakov Shor
Top Contributor
Yakov_Shor
8 mths ago
4
replies
48
Last reply
Yakov Shor
Top Contributor
7 mths ago
Q&A
Answered
Answered
0
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.
Holger Beyer
Customer
Holger_Beyer
9 mths ago
3
replies
39
Last reply
Avi Perez
Admin
9 mths ago
Q&A
Answered
Answered
0
Percentage points change
Hi We are looking at a solution to create point percentage change column. In the given example we would like to create a measure that can be calculated on percentages,…
Yakov Shor
Top Contributor
Yakov_Shor
updated
9 mths ago
3
replies
49
Last reply
Ian Macdonald
Admin
6 mths ago
Q&A
Answered
Answered
0
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.…
Yakov Shor
Top Contributor
Yakov_Shor
9 mths ago
1
reply
44
Last reply
Avi Perez
Admin
9 mths ago
Q&A
Answered
Answered
0
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…
Yakov Shor
Top Contributor
Yakov_Shor
9 mths ago
2
replies
36
Last reply
Yakov Shor
Top Contributor
9 mths ago
Q&A
Answered
Answered
3
Box shadow effect
Box shadow for illustrate component: How can it be done ?
Rivka Saalkind
Certification In Progress
Rivka_Saalkind
updated
6 mths ago
12
3
Q&A
0
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,…
Robert Clark
Top Contributor
Robert_Clark
updated
10 mths ago
4
replies
32
Last reply
Robert Clark
Top Contributor
9 mths ago
Q&A
Answered
Answered
5
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?
Angeline
User Certified Level 1
angeline
10 mths ago
1
reply
35
5
Last reply
Natalie-Anne Botha
Top Contributor
7 mths ago
Q&A
Answered
Answered
0
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.…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
11 mths ago
3
replies
51
Last reply
Ian Macdonald
Admin
11 mths ago
Q&A
Answered
Answered
0
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,…
Sophie durrant
Top Contributor
Sophie_durrant
11 mths ago
3
replies
29
Last reply
Ian Macdonald
Admin
11 mths ago
Q&A
Answered
Answered
1
Date Members in formulas
When I create a Date with a formula, using several functions, Pyramid seems to work fine: When using common date functions with the created dates, everything looks correct to me: Also,…
Federico Riera
Customer
Federico_Riera
11 mths ago
1
reply
40
1
Last reply
imbar
Community Team
11 mths ago
Q&A
Answered
Answered
2
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,…
Sophie durrant
Top Contributor
Sophie_durrant
11 mths ago
2
replies
58
2
Last reply
Ian Macdonald
Admin
11 mths ago
Q&A
Answered
Answered
1
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,…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
11 mths ago
1
reply
24
1
Last reply
Ian Macdonald
Admin
11 mths ago
Q&A
Answered
Answered
0
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…
Ben Burchell
Customer
Ben_Burchell
1 yr ago
7
replies
47
Last reply
Ben Burchell
Customer
11 mths ago
Q&A
Answered
Answered
0
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.…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
updated
1 yr ago
2
replies
31
Last reply
samuel alma
1 yr ago
Q&A
Answered
Answered
0
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.…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
2
replies
40
Last reply
Nicholas Campbell
Top Contributor
1 yr ago
Q&A
Answered
Answered
0
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…
Sophie durrant
Top Contributor
Sophie_durrant
1 yr ago
3
replies
36
Last reply
David Gordon
Community Team
1 yr ago
Q&A
Answered
Answered
0
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.…
Ben Burchell
Customer
Ben_Burchell
1 yr ago
4
replies
41
Last reply
Ben Burchell
Customer
1 yr ago
Q&A
Answered
Answered
0
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…
Dan Sharman
Customer
Dan_Sharman
1 yr ago
5
replies
52
Last reply
Dan Sharman
Customer
1 yr ago
Q&A
Answered
Answered
0
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…
Nicholas Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
5
replies
46
Last reply
Ian Macdonald
Admin
11 mths ago
Q&A
Answered
Answered
1
2
3
4
5
25
Next
Ask a new question
Got stuck with a report? Start a discussion or help others to move forward.
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Learning Live Archive
Pyramid Dashboard Gallery
Tech Blogs
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
SAP
Security
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help