-
Parse excel doc
I want to parse excel document to lists in Python. Is there a python library which is helpful for this action? And what functions are relevant in that library?
- Answered
-
Python and Excel
What is the best way to read Excel (XLS) files with Python (not CSV files). Is there a built-in package that is supported by default in Python to do this task?
- Answered
-
Adjust difference between slicers in Discover & Present
We are missing "Combined Elements" as a type in the "Present" slicer At this moment we are using the slicer we made in "Discover" and drag the slicer to "Present", but this is a trick,…
- Answered
-
Best method for displaying four measures on the same visual
We have previously upgraded our Pyramid version from 5 to 2020.10. We used to use funnels to show four related measures on multiple reports, however, as we have seen in the help documentation,…
- 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
-
Pyramid 2020.15 Released
Pyramid 2020.15 has been released and includes primarily a collection of functional fixes and important security upgrades. Software The main installer files can be downloaded from the Pyramid…
-
Python
I have a question regarding to python. I want to add the list below into a column and append it to my existing excel file list = [2,3,4,5] Original: After: I have converted my excel to panda ...
- Answered
-
Customisable Linear Regression Line Scatter Chat
Hi we have a scatter chart and we are looking to create a line which is Y (Premiums)= X (Claims) so that anything below the line is a loss and anything above the line is profit.…
- Answered
-
Ranking a measurement linked to more than one dimension
Hello The rank statistical feature returns the rank of a member in the specified list. The list used must be a list or set of elements from the SAME hierarchy as the member in the model.…
- Answered
-
Quickly duplicate a dimension?
Hi i would like to copy a dimension, we could write it into our ETL but if I can do in Discovery or Formulate then it would be cool. In Tableau I would create a calculated field "=DIMENSION_NAME"…
- Answered
-
How to connect Google Sheets to Pyramid
Pyramid can model and blend numerous complex data sources for basic or advanced analysis. The quick tutorial below shows how you can use Pyramid to access and import data stored in a Google Sheet,…
-
How to Generate Process and Thread Dump Files for Analyzing High Memory Usage of Pyramid Serivces
Pyramid services are based on Java and require the server resources (mostly RAM and CPU usage) to be available for better performances. To prevent services from over-consuming the resources,…
-
Showing a comparator "geography type" in a chart
Hi all this is tediously basic i assume, sorry. A line chart shows all items that are in "Geography_Type A" where the user can choose the Type: And what i need to do is have a second…
- Answered
-
Present - Not enough information error, can it be turned off?
In Present, can a panel be modified to display a blank grid instead of providing the error 'Not enough information' when no information for the criteria selected?
- Answered
-
Totals of sets
Hi, It seems that we are not able to show totals whenever we make sets. In the attached example you will see it shows totals from the data that are directly coming from the dimension (black arrow)…
- Answered
-
Custom Maps and Coordinate Systems
If you load a GeoJSON file as a custom map in Pyramid and do not get any shapes displayed, it could be the coordinate system you are using, especially if you converted another file format to GeoJSON.…
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
Adding Countries to recognised countries
Hi Is it possible to add followig as countries? 1) Hong Kong 2) Macau Than you
- Answered
-
Pyramid 2020.14 Released
Pyramid 2020.14 has been released and includes a small collection of key fixes. Software The main installer files can be downloaded from the Pyramid Customer Portal.…
-
Multiple PlaceHolders in a text box - work once then disappear
Hi I have text boxes on a Present, if I add a single Placeholder and use Interaction Manager to associate it with an item then everything is cool and it works.…
- Answered
-
Publication with Portrait and Landscape Pages
Hello, I am creating a publication in Pyramid, and have some discoveries which would be better displayed on a portrait page and others on a landscape page - is it possible to change the orientation…
- Answered
-
Issue when running a model that has JSON nodes that connect to HTTPS data source
ISSUE: When running an ETL that contains references to an HTTPS site the following error may occur: "Failed to read file list: SSLException: No PSK available.…
-
Hiding an item from the legend?
Hi I have a couple of items in a Discovery which are there to support the chart structure but shouldn't be in the legend, can i prevent them from showing?…
- Answered
-
Can you change filter conditions in discoveries be OR rather than AND?
We have a discovery with two different measures and we want to filter and only show rows that where one of the measures is not equal to zero. So the condition would look like this: Measure A !…
- Answered
-
Pyramid 2020.13 Released
Pyramid 2020.13 has been released and includes numerous fixes and a large number of new features (50+) and improvements. Software The main installer files can be downloaded from the Pyramid Customer…
Content aside
Topic actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
BARC 2025 BI and Analytics Survey
Pyramid 2024 LTS Release Notes
Pyramid 2023.15 Release Notes
Pyramid Tip of the Day
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help