User Community

How to enable Javascript

Q&A

Latest Activity

Got stuck with a report? Start a discussion or help others to move forward.

TOPICS MEMBERS

Filter
Newest
Active
Popular
Status
- Answered
- Unanswered
Tags

Join this category to participate in conversations and receive notifications when new posts are added

JOIN

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
- Guillermo_Dominguez
- 4 mths ago
- 1reply
- 22
- Last replyIan MacdonaldAdmin2 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 ShorTop Contributor
- Yakov_Shor
- 4 mths ago
- 4replies
- 34
- Last replyYakov ShorTop Contributor2 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
- Holger_Beyer
- 5 mths ago
- 3replies
- 28
- Last replyAvi PerezAdmin5 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 ShorTop Contributor
- Yakov_Shor
- updated 5 mths ago
- 3replies
- 42
- Last replyIan MacdonaldAdmin2 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 ShorTop Contributor
- Yakov_Shor
- 5 mths ago
- 1reply
- 27
- Last replyAvi PerezAdmin5 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 ShorTop Contributor
- Yakov_Shor
- 5 mths ago
- 2replies
- 27
- Last replyYakov ShorTop Contributor5 mths ago
- Q&A
- Answered
- Answered

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 ClarkTop Contributor
- Robert_Clark
- updated 5 mths ago
- 4replies
- 23
- Last replyRobert ClarkTop Contributor5 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?
- AngelineUser Certified Level 2
- angeline
- 6 mths ago
- 1reply
- 26
- 5
- Last replyNatalie-Anne BothaTop Contributor3 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 CampbellTop Contributor
- Nicholas_Campbell
- 7 mths ago
- 3replies
- 42
- Last replyIan MacdonaldAdmin7 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 durrantTop Contributor
- Sophie_durrant
- 7 mths ago
- 3replies
- 23
- Last replyIan MacdonaldAdmin7 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
- Federico_Riera
- 7 mths ago
- 1reply
- 28
- 1
- Last replyimbarCommunity Team7 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 durrantTop Contributor
- Sophie_durrant
- 7 mths ago
- 2replies
- 42
- 2
- Last replyIan MacdonaldAdmin7 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 CampbellTop Contributor
- Nicholas_Campbell
- 7 mths ago
- 1reply
- 22
- 1
- Last replyIan MacdonaldAdmin7 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
- Ben_Burchell
- 8 mths ago
- 7replies
- 34
- Last replyBen Burchell7 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 CampbellTop Contributor
- Nicholas_Campbell
- updated 8 mths ago
- 2replies
- 25
- Last replysamuel alma8 mths 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 CampbellTop Contributor
- Nicholas_Campbell
- 8 mths ago
- 2replies
- 29
- Last replyNicholas CampbellTop Contributor8 mths 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 durrantTop Contributor
- Sophie_durrant
- 8 mths ago
- 3replies
- 26
- Last replyDavid GordonCommunity Team8 mths 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
- Ben_Burchell
- 8 mths ago
- 4replies
- 30
- Last replyBen Burchell8 mths 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 SharmanTop Contributor
- Dan_Sharman
- 8 mths ago
- 5replies
- 42
- Last replyDan SharmanTop Contributor8 mths 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 CampbellTop Contributor
- Nicholas_Campbell
- 9 mths ago
- 5replies
- 36
- Last replyIan MacdonaldAdmin7 mths ago
- Q&A
- Answered
- Answered

1
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,…
- Satveer Kaur
- Satveer_Kaur
- 9 mths ago
- 1reply
- 36
- 1
- Last replyIan MacdonaldAdmin8 mths ago
- Q&A
- Answered
- Answered

2
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?…
- Dan SharmanTop Contributor
- Dan_Sharman
- 9 mths ago
- 1reply
- 17
- 2
- Last replyIan MacdonaldAdmin8 mths ago
- Q&A
- Answered
- Answered

0
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.…
- Ben Burchell
- Ben_Burchell
- 9 mths ago
- 3replies
- 28
- Last replyIan MacdonaldAdmin8 mths ago
- Q&A
- Answered
- Answered

0
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.…
- AngelineUser Certified Level 2
- angeline
- 9 mths ago
- 1reply
- 28
- Last replyIan MacdonaldAdmin8 mths ago
- Q&A
- Answered
- Answered

0
Why are my totals not also colored?
I have a simple table in which a couple measures are colored by a calculated value (which compares the measure shown to a reference measure ). The distinct rows for each member of the dimension work…
- Philip Augur
- Philip_Augur
- 10 mths ago
- 2replies
- 20
- Last replyPhilip Augur10 mths ago
- Q&A
- Answered
- Answered

1 2 3 4 5 23 Next

Got stuck with a report? Start a discussion or help others to move forward.

Members

View all members

Recent Tweets

Follow @PyramidAnalytic

Welcome to the community!

User Community

Q&A

Changing positioning of data labels in point graphs

How to create a report without live connection?

sort or filter on subtotals

Percentage points change

Combining two discovery tables in present

Unified slicer for two separate parameters

Is there a way to move a CMS repository to different database vendor?

Replace a current template in a presentation

Equivalent to SUMPRODUCT in Pyramid

Publications- One attachment for multiple selections

Date Members in formulas

Date Formats in Exported Excel Files

Multipage Repeater

Dynamic year range on loss triangle

Line Breaks

Variable List Measure, of a Variable List Measure

Check when a model was last updated

Parameterised Year To Date

PQL Date Query

Sankey Chart - Source and Target Same Dimension

Displaying two grids as 1

Changing Filter Type in Analyze Further

Custom Groupings

Change path of Discovery in Presentation

Why are my totals not also colored?

Members

Recent Tweets

Home

Key Resources