-
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
-
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
-
interactions across column charts
Hi community. I have highlight-type interactions between two column charts, both of which feature measures from the same table (one is "value" and the other is "cost").…
- 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
-
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
-
[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
-
What are the best practices with the new migration capability?
Hello, We are trying to use the migration utility to promote content from development to production. However, we are getting duplicate content suffixed with a number e.g.…
- 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
-
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
-
Multi-factor Authentication
Is there a way to enable multi-factor authentication (MFA)? If not directly through Pyramid, is there third party tools to provide something like this?…
- 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
-
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
-
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
-
How to get the Content Path from the Pyramid Repository in Usage Reporting
In the usage report that I built based on Transaction logs in Pyramid, I am not able to get the 'Path' for my dashboard or report objects. Is there a way to get a path field for the content?
- 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
-
Trellis - why the 4 column limit?
Hi I love the trellis charts but is there a practical reason for the 4 column limit? 5 would be excellent, after that maybe some diminishing returns, but for flexibility of design options why not go…
- Answered
-
Partial Replacement of Data
Hi All - Is there any way you can delete a filtered set of records from the InMemory db? I need to replace only the last weeks data with every run since these records are altered in the source data.…
- Answered
-
Include Latest Analysis Services Client Libraries in the WCS role
Hi, We have recently deployed a new multi server Pyramid 2020 solution. As a part of this, we installed the windows connector service on its own Windows Server 2019 Server.…
- Answered
-
how to create nest folder view in configuration section
Hi, May i ask your help how to achieve nested folder structure in Pyramid model development from the snapshot provided the second screenshot is taken as reference from different BI application.…
- Answered
-
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
-
Rotate table header text?
Hi all I have a nice simple Matrix grid table, the header texts are all quite long, we cant avoid that, and they're required. I've been trying to see how to rotate the text in this manner (these are…
- Answered
-
Partial Model Update in IMDB
Suppose I have a single IMDB model, which feeds of different sources. These sources may not be available in the same time, or may not update in the same time.…
- Answered
Got stuck with a report? Start a discussion or help others to move forward.