-
Cumulative Rate Changes
Hi all, I am trying to replicate the example seen in the picture. As you can see, with each different year the rate % changes. I want to be able to track the cumulative change from a given year…
- Answered
-
Discovery Data Catalog Export
Hello folks. Is it possible to export the data catalog from a discovery object in a format which is not .pdf? I see I can export the data catalog from a data model object as a json file,…
- Answered
-
Pyramid Usage Model and Analysis
Using Pyramid to analyze itself. The following document describes how to build a data model using Pyramid’s database repository as a data source to be able to analyze content usage and performance…
-
How to calculate 90 percentile based on category
I need to calculate 90 percentile in one of my discovery (there is no option in model). Since there is no direct way to have 90 percentile, instead I am trying using standard deviation (1.…
- Answered
-
Pyramid Explore #1 - Are you awake? The CoffeeShop Edition
Welcome to the first Pyramid Explore Mission In our initial Pyramid Explore Mission we are going to look at product data that has been made available by Starbucks. The Model you find at explore.…
-
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
Making a population pyramid chart - specify total for %, and reverse axis direction
Hi all, i need to be able to create these charts. Percent of total, in agebands split by sex, displayed as a bar chart with one of the sexes using an inverted x-axis.…
- Answered
-
Count of positive values in sub query
hi all, Can you please help me to reproduce the metric from PBI DAX calculation in PQL? the story is the following - at any time dynamically we need to have counted positive values within internal…
- Answered
-
best practice for Publication size / amount of pages
Dear community, do you any experience to share when it comes to larger publication objects ? We plan to set up a publication (for PowerPoint output) which may have up to 80 - 100 (!…
- Answered
-
What is initial user when changing provider from DB to AD?
What should be the initial user when we change provider from DB to AD? I tried the name of the Enterprise Users created on Pyramid, but it doesn't work.
- Answered
-
Table of Contents UI
Hi, When I export a dashboard which includes a table of contents from the dynamic text feature, the contents list isn't included. Are there any settings which need to be selected to include this?…
- Answered
-
Date slicers- show months in chronological order
I am wondering if there is something we need to do differently with the 2020 version of Pyramid compared to 2018, to make date slicers list months in the proper order?…
- Answered
-
Dynamic Text - Getting max used columns data
Hi all, As per the attached pic and above mentioned. Is it possible in the dynamic text editor to get the column number of the highlighted section, baring in mind that when changing filters the…
- Answered
-
Cumulative context but to exclude specific status measures (unable to reproduce solution)
Hello, Background: We use Pyramid 2020.13.100 against a SSAS datasource. I'm trying to make the graph above, my assumption is that I should be able to do that if I'm able to make the accompanying…
- Answered
-
Line Graph: Continuous X-Axis
I have values on my x axis: 0,5,20,50,100,250,500,750,1000,1500 and they are represented as discrete points, equally spaced. Is there a way to make them continuous?…
- Answered
-
Embedded Analytics with Pyramid
Pyramid makes embedding analytic content into 3rd party applications as easy as two lines of HTML code. The video above demonstrates how easy this is to achieve.…
-
Row background color is not exporting same in excel
Hello, Is there any way to export the same color format layout from the pyramid report to excel file. At this point, I can see just the header colors are exporting correctly and that to different…
- Answered
-
Show an average of the selected members of a filter.
Hi, I would like to be able to show the average of some measures I have calculated. My scenario is as follows: I have some measures shown in a line graph over time.…
- Answered
-
Data Label Formatting on Average Measurements
Hi, I've created a discovery which has two axis. The first axis (bar) to show quantity and the second axis (line) to show percentage of sales. What we would like to do is show another line on the…
- Answered
-
Group By option for grids
I have this report that shows allocation details for sales invoices, and I'm having a problem with transactions that cancel each other out; when we reverse a transaction in our system,…
- Answered
-
Measures/Dimensions caption translation
Hi all, I have this issue: I work for an italian company and all our database objects captions are in italian. I would like to translate the labels in english since we now have an USA company branch.…
- Answered
-
Adding a custom map
Hi i've converted a Mapinfo TAB file to Geojson format using an online service and uploaded the .geojson file to Pyramid, I can pick that custom map as a property for the relevant dimension in a…
- Answered
-
Discover - Viewer - Descriptions
Is it possible for users with the viewer license to see any of the metadata associated with Discover? I'd like the viewers to at least see the description text.…
- Answered
-
Custom tooltips, how?
Hi all I'm reading this: https://help.pyramidanalytics.com/Content/Root/MainClient/apps/Present/Present%20Pro/functions/CustomTooltips.htm?Highlight=tooltips Because I need to have control over the…
- Answered
-
Notification for failure of scheduled model refresh?
Is there any way to send a notification when a schedule model refresh fails?
- Answered
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
Pyramid 2023.11 Release Notes
Pyramid Tip of the Day
Discontinued OS Support for EOL Systems
The DataShark Podcast
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help