-
Configure Model's Targets / Sources with a variable
Hi everyone, I'm wondering if there is any way to configure targets / sources with a variable or a parameters that contains a connection string ? That will help us to not update connections in every…
- Answered
-
Smart discover - allow selecting custom calculation
If I create an IMDB model, I can't have an aggregated average as an intrinsic measure. If I want a measure called "avg price" it has to be a calculated measure.…
- Answered
-
smart discover - change order of nesting
I tried creating a smart discover. I chose 2 measures, and two dimansions. Now one dimension is on the rows, and on the columns I see the measures on top, and the dimension underneath them.…
- Answered
-
Negative number formats
I have been asked to produce a report with a very particular number format, and I can't see a way to do it They want negative values to be shown in parentheses and in red- I have managed to get the…
- Answered
-
Scaling options in Present panels
The current options for scaling in presentation panels do not allow for scaling on width, so if I have a grid that's wider than the panel, the only option I have to get the columns to fit is "scale…
- Answered
-
Hide unwanted subtotals
Hello, I'm wondering if it is possible, when including subtotals in a grid, to select which columns you want the subtotals to show for? Currently when subtotals are added,…
- 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
-
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
Got stuck with a report? Start a discussion or help others to move forward.