-
Stop distribution of when 'Finished with Errors'
When a publication finishes with errored queries, the report is still distributed - this causes confusion for end users as it appears there is missing data.…
- Answered
-
PQL Custum Measure: modify value before passing to aggregation
How can one create a custom measure that involves modifying a column before passing it to an aggregation function? For a example, consider calculating the average of squares of a column.…
- Answered
-
Colorizing in Discover does not work as expected
Dear all, a client of mine tries to colorize the budget deviation with itself as shown in the attached video. When he colorizes "all" then it works perfectly as well as when he colorizes only the…
- Answered
-
Notification of Publication Failure
Hello, Is there a way that users can be notified when a publication fails? I can see this previous question which showed there is a repository table to see this in BI Office,…
- Answered
-
Remove expand icon of hierarchy within a matrix
Hello all, I would like to remove the expand icon in a matrix from one specific hierarchy. Do you have any idea how to solve this? I want to remove the expand or "+" icon from the product hierarchy.…
- Answered
-
Overlaying columns/bars with integrated variances (IBCS)
Dear Community, the following picture is taken from the IBCS v1.1 (2017). Is there a chance to create something like that with Pyramid? At least something that comes close to it?…
- Answered
-
List of supported databases
Hi all, is there a list showing all supported databases inkl. version info - preferably seperated into these three categories source in discover source in model target in model My client is…
- 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
-
Calculate a dimension value (numeric)
I'm wondering if its possible to use a numerical dimension value in a sum? I have exchange rates in its own dimension table and want to use them to calculate original currency premium value into a…
- Answered
-
Adding Hyperlink to text in Publish
Is it possible to add a text field with a hyperlink to a page in Publish? I've seen that you can add jump to hyperlink to a click action in Present, which is fine.…
- Answered
-
Customize KPI Component Captions
In KPI definitions, I would like to define the caption for each component - So I don't have to use "value", "goal" and "status". I know in a KPI type discover I can change them,…
- Answered
-
Combine attributes for "change caption"?
Dear Community, when using an MSAS-OLAP-Cube with Pyramid (maybe in different circumstances, too) there is an option to change the caption of the members displayed in the rows (or columns) - in case…
- Answered
-
Model mapping advanced
Hi, I have two different OLAP cubes with two different dimensions for Companies with different hierarchies and different name standard. I would like to use a filter in my Present dashboard from one…
- Answered
-
How to remove special characters from a string in Data Modeler?
Sometimes when you are importing data from a source, a column may have non-alphanumeric characters (aka special characters). How can I remove these characters? For example,…
- Answered
-
Action - Jump to Content. Hide the background slicers?
Ok so an Action is applied to open a discovery in a pop-up. The functionality works great as it takes the context in the cell which is right-clicked and uses that in the pop up.…
- Answered
-
Adding "All" to a slicer
HI this seems like it should be straightforward. I have a tick box slicer with numerical values which allows me to pick an "all" option. But I have another Drop Down which is Text items and does not,…
- Answered
-
What's this called please? ("Actions")
I have a discovery table in a presentation, DimensionA vs DimensionB with a measure in the values. I'd like the user to be able to select a cell in that table,…
- Answered
-
Accidentally pressed "Auto Interact"...
OK so I've made this mistake before, but this time it's really ruined my presentation. I have saved since as hadn't even realised I pressed it. Is there a way to undo all the knitting it has done…
- Answered
-
Background Colour cells based on IF formula
As per the above, I have created an IF formula to specify what colour I want the cell to be, based on the value of the measure. This doesnt seem to work no matter what I try when dragging the…
- Answered
-
Authenticating with ADS when Pyramid Analytics hosted on AWS
Hello, Does anyone have tips on setting up Active Directory Services (ADS) authentication in Pyramid Analytics running on AWS. ADS is running on local network and Pyramid Analytics is running on AWS.…
- Answered
-
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
-
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
Content aside
Category actions
Rate Pyramid today:
Please rate from 1-5 Stars and click on the Star
to register your feedback.
2024 Gartner MQ for BI and Analytics
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