-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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
-
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…
- Answered
-
Discovery to show Pyramid Content Items
Since we upgraded from 2018 version of Pyramid, opening related content from a model is no longer working (we are now on version 2020.23.117) I need a report that shows all models with created date…
- Answered
-
Context sensitivity in Model (Secondary key)
The reason for this suggestion originates in product construction sets. The way products are constructed and then prepared for export to different international markets results in a many to many…
- Answered
-
Exporting Publication to Powerpoint
Hi, When I export a publication that contains three charts and four pieces of dynamic text into powerpoint, the dynamic text doesn't retain formats and is often different sizes etc.…
- Answered
-
Web Page Illustration
I would like to add an excel document that is saved to OneDrive via a shareable URL to a presentation. Has anyone successfully done this and if so, how did you accomplish this?…
- Answered
-
Best Practices on CSS on Pyramid
Hi everybody, we are using pyramid for it's web embedding capabilities and would love to know everybody's best practices for css on it - do you just theme pyramid visualizations and then rely on…
- Answered
-
Formatting issues on Scatter Graph x-axis
Hi, I can't seem to get the y-axis line to start at the 0 position on the x-axis- this is what I get when the "axis position" is on Zero position. I think this was something that could be changed in…
- Answered
-
chart list for development months
hi I have a chart which is showing months 1 to 60+, i was wondering if its possible to show 1 to 24 then from there going in multiples of 3? so 27 30 33 etc...?
- Answered
-
Filtering discoveries with OR instead of AND
I have been asked for a report to show invoices where the delivery OR the invoice has been sent to a particular country. I have an IMDB model using a sql source,…
- Answered
-
Tooltip not showing in scatter graph
Hi all, As per the above, when I add the assured name to show in the tooltip or label, it only shows as a *. Do you know why this might be? Thanks, Dan
- Answered
-
Grid Size and Scrolling
When building grids in Discover, it seems to be divided into two distinct areas for dimensions on the left side and measures on the right. When you have more dimensions than will fit in the left…
- Answered
-
Select Current Year in a Discovery
Trying to create a discovery to show only sales in the current year but I can't find a way to do it! This discovery will be used as a publication, so I always want it to just show the current year,…
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
Pyramid 2023.12 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help