-
Preset number of Y ticks in advance
Hi, I want to build a line plot in discovery that would have pre-set 5 parts to split into, no matter the data min and max. Meaning, If I have 0 as Mix measure and 100 as Max,…
- Answered
-
Hiding a Column
Hi, Trying to build a simple report. Are you able to simply hide a column in Pyramid like you would an excel document? For example - Where some columns pull through blank i'd like to simply hide.
- Answered
-
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
-
Pyramid 2018 Geospatial Shapes summary
Please see the attached PDF for a summary of all the Geospatial shapes that are available for Pyramid 2018 mapping.
-
How to enable SSL on Pyramid website and forward all HTTP request to HTTPS
To be able to use SSL for Pyramid website it should be installed using the IIS option. Once installed add an SSL bindings as shown below: Right Click on the "Pyramid" site and choose edit…
-
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
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