-
Aggregating clients for a location while taking into account other locations
Good morning, background: we use Pyramid 2020.15.046 against a SSAS datasource, tabular model. I have a user wish, which I don't know how to build. The user wants to know for a certain location how…
- Answered
-
How can a mobile viewer user add favourites?
Hi, We have mobile viewer users, I just told one of them to add something to their favourites but the option doesn't seem to be there. I have had a look on the app and can't find it either,…
- Answered
-
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Answered
-
Adding a custom map
Hi i've converted a Mapinfo TAB file to Geojson format using an online service and uploaded the .geojson file to Pyramid, I can pick that custom map as a property for the relevant dimension in a…
- Answered
-
How to calculate aggregate correctly without using underlying details
Hello, Background: We use Pyramid 2020.15.046 against a SSAS datasource. I want to calculate the amount of interesting clients per location without using clients in the table,…
- Answered
-
Export List of Pyramid User Accounts
Is there a way of exporting a full list of user accounts on Pyramid, along with related information (e.g. Roles, Profiles etc.)
- Answered
-
Present - Runtime Settings on slides, reports
Under Runtime Settings in Present, I see two options: Global-Scope and Slide-Scope. What do these mean? I also would like to know if I can apply different runtime settings to different slides in…
- Answered
-
Analysis Services Dynamic Management Views as IMDB Data Source
Hi, I have an Excel file with that uses custom .odc files as data sources with a connection string to analysis services and MDX query to pull back DMV's.…
- Answered
-
Multi Select (All) parameters
Multi Select (ALL) parameters. If you have this selected to all for a dashboard, after a while new elements are added however the (ALL) selection now only selects the elements which were there when…
- Answered
-
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
Got stuck with a report? Start a discussion or help others to move forward.