How to enable Javascript

Discussion Forum - Q&A

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

TOPICS MEMBERS

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

JOIN

0
Pyramid Analytics API
Good Day. I would like to connect Excel to Pyramid and extract a database using the REST API's. Is there any guidance on how to use these APIs?
- Aadhil KhanPartner Certified Level 1
- BI Consultant
- Aadhil_Khan
- 8 days ago
- 6 replies
- 25
- Christian LangmayrAdminyesterday
- Discussion Forum - Q&A
- Answered
- Answered
0
Existing or custom area chart with measure for x axis.
This is quite obscure so not sure if possible, but is it possible to create some sort of stacked area chart where the X-Axis is a rank (so numeric) instead of a dimension (so 1,2,3,4,…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 3 wk ago
- 4 replies
- 24
- Avi PerezAdmin4 days ago
- Discussion Forum - Q&A
1
how to create not a dynamic calculation
Hi, I have a case where I need to make the next calculation: In a table with the columns: week | store name | item name | sales For each item : In each store,…
- Maria Rozenblit
- Maria_Rozenblit
- 1 mth ago
- 4 replies
- 41
- 1
- Maria Rozenblit3 wk ago
- Discussion Forum - Q&A
- Answered
- Answered
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 CampbellTop Contributor
- Nicholas_Campbell
- 1 mth ago
- 6 replies
- 29
- Christian LangmayrAdmin3 wk ago
- Discussion Forum - 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
- alicia_me
- 1 mth ago
- 2 replies
- 20
- alicia_me1 mth ago
- Discussion Forum - 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
- Benjamin_Reed
- 1 mth ago
- 2 replies
- 29
- Benjamin Reed1 mth ago
- Discussion Forum - 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
- Guillermo_Dominguez
- 2 mths ago
- 1 reply
- 15
- Ian MacdonaldAdmin7 days ago
- Discussion Forum - Q&A
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
- 2 mths ago
- 1 reply
- 12
- Ian MacdonaldAdmin7 days ago
- Discussion Forum - Q&A
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
- 2 mths ago
- 4 replies
- 29
- Yakov ShorTop Contributor3 wk ago
- Discussion Forum - Q&A
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
- 3 mths ago
- 3 replies
- 22
- Avi PerezAdmin3 mths ago
- Discussion Forum - 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
- 3 mths ago
- 3 replies
- 39
- Ian MacdonaldAdmin7 days ago
- Discussion Forum - 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
- 3 mths ago
- 1 reply
- 20
- Avi PerezAdmin3 mths ago
- Discussion Forum - 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
- 3 mths ago
- 2 replies
- 24
- Yakov ShorTop Contributor3 mths ago
- Discussion Forum - 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
- 3 mths ago
- 4 replies
- 21
- Robert ClarkTop Contributor3 mths ago
- Discussion Forum - 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
- 4 mths ago
- 1 reply
- 23
- 5
- Natalie-Anne BothaTop Contributor4 wk ago
- Discussion Forum - 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
- 5 mths ago
- 3 replies
- 38
- Ian MacdonaldAdmin5 mths ago
- Discussion Forum - 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
- 5 mths ago
- 3 replies
- 21
- Ian MacdonaldAdmin5 mths ago
- Discussion Forum - 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
- 5 mths ago
- 1 reply
- 26
- 1
- imbarCommunity Team5 mths ago
- Discussion Forum - 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
- 5 mths ago
- 2 replies
- 39
- 2
- Ian MacdonaldAdmin5 mths ago
- Discussion Forum - 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
- 5 mths ago
- 1 reply
- 21
- 1
- Ian MacdonaldAdmin5 mths ago
- Discussion Forum - 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
- 5 mths ago
- 7 replies
- 32
- Ben Burchell5 mths ago
- Discussion Forum - 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
- 6 mths ago
- 2 replies
- 23
- samuel alma6 mths ago
- Discussion Forum - 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
- 6 mths ago
- 2 replies
- 28
- Nicholas CampbellTop Contributor6 mths ago
- Discussion Forum - 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
- 6 mths ago
- 3 replies
- 25
- David GordonCommunity Team6 mths ago
- Discussion Forum - 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
- 6 mths ago
- 4 replies
- 29
- Ben Burchell6 mths ago
- Discussion Forum - Q&A
- Answered
- Answered

1 2 3 4 5 22 Next

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

Members

View members

Recent Tweets

Follow @PyramidAnalytic

Discussion Forum - Q&A

Pyramid Analytics API

Existing or custom area chart with measure for x axis.

how to create not a dynamic calculation

Eliminate visual indicator on eliminate datapoint

Is the Job Spooler available in Viewer version?

Merge separate lines into one single line whilst retaining separated stacked columns

Legend not showing on Matrix grid.

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

Members

Recent Tweets

Home

Key Resources