-
Mimic member logic within lists
Hello folks. I have a very handy variable list object which filters a large number of products into the end-user's desired internal product categories. I would like to now compute the percentage…
- Answered
-
Splitting dataset Train Error
I am trying to spilt dataset into a train and test using Python Node and Learn&Predict. I get an error below related to pyramid_eval_out.write. How can it be fixed? Error PyramidException:…
- Answered
-
Identifying Duplicated Elements
Hi all, I have a discover object containing products and their status. I want to identify products where the attribute status is duplicated. i.e. Products where the status has been assigned more than…
- Answered
-
Analyse Further Multiple Measures on 1 Line Chart
If you are using analyse further, is there a way to get 2 measures on the same line chart?
- Answered
-
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?
- Answered
-
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,…
- 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
-
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
-
Colouring different parts of a dynamic text sentence.
As per the above mentioned, is it possible to colour different sections of a sentence that are based entirely on dynamic text - or made in the dynamic text editor?…
- Answered
-
[Publication] Page repeat children of filtered/selected member
Hello, I am wondering if it is possible to filter a Publication and having a page repeater export the children of the filtered member. For example: I would like to export a publication for Europe,…
- Answered
-
Last updated date & time
I remember in BI Office, it was possible to add a text field showing the date and time the source model was last updated. I cannot seem to find this in Pyramid (2018.05.…
- Answered
-
Drill Down in an inner dimension of two nested ones
Dear Pyramid-Team, assuming the following situation: Two dimensions are nested in the rows of a table grid (e.g. Customers as outer dimension and Products as inner dimension).…
- Answered
-
Unit of Measure
Hi! I would like to add a unit to each measure (e.g. "EUR" or "pcs") which can be shown or hidden, depending on the preference - is that possible? Thanks!
- Answered
-
Range List Using Two Date Hierarchies
Hello, I don't think this is possible but thought it's worth a shot asking the question! I have a discovery with filters for TransDate and ClosedDate. The aim is to see open transactions at the end…
- Answered
-
Creating multi-charts
I'm wondering how to combine charts into one plot. Currently, I have a time dimension on the x-axis, and I have two values I want to have on the y-axis (think "desktop minutes" and "mobile minutes"…
- Answered
-
Publish email with attchment
Hi team I created an publication and scheduled it. (The output format is pdf or word - still under review which works best). I want it to be send by email and the document to be attached to the…
- Answered
-
MODEL: Change stored procedure used to access data on SQL Server.
Hello, I have been testing Pyramid. In a model, we can obtain data from a SQL Server from a table or executing a stored procedure. If I want to use another table,…
- Answered
-
Bar chart with multiple measures
Dear all just started working with Pyramid 2018 and I have a question. I want to create a bar chart with dimension: 1 hierarchy values: 3 measures , something like this:…
- Answered
-
Upcoming features in Pyramid 2018?
Hello, We provide a customised solution built on Pyramid software to our clients. We would be very eager to change into using Pyramid 2018 (we've had some stability issues with BI Office and the…
- Answered
-
Automated Export/Extract to SQL Server
This is a unique client request that I am trying to assist with. The need is to export directly from a Pyramid Discovery to a SQL database. My thought was to connect SQL SSIS job and induct a CSV…
- Answered
-
Building Custom Filters
Hello, I am trying to create a custom filter for my queries using the Filter() function that I have read documentation on. I believe this will be useful for what I am trying to use it for.…
- Answered
-
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
How can we have formulae appear in the text and a graph of the same data set appear in same discover.
- Answered
-
Conversations - how to mark as read?
We are using conversations to communicate within our development team. How do we mark it as read?
- Answered
-
Chart Top 5 Along with an Aggregate of the Others
We have charts that display the top 5 countries; How can we aggregate the other countries that are not in the top 5 and display them in an "Others" bucket, as below?
- Answered
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
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