User Community

How to enable Javascript

Q&A

Latest Activity

Got stuck with a report? Start a discussion or help others to move forward.

Filter
Newest
Active
Popular
Status
- Answered
- Unanswered
Tags

1
Using URL Parameterization
I am currently trying to figure out how to parametrize a URL in order to link directly to a Present whose data would be filtered by the other application.…
- Niko ZCertification In Progress
- Niko_Z
- 1 yr ago
- 1reply
- 35
- 1
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

2
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…
- Hamza Lahbabi
- Hamza_Lahbabi
- updated 1 yr ago
- 1reply
- 25
- 2
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

0
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.…
- Moshe YossefPyramid Employee
- Customer Solutions Architect
- Moshe_Yossef
- 1 yr ago
- 3replies
- 12
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

0
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.…
- Moshe YossefPyramid Employee
- Customer Solutions Architect
- Moshe_Yossef
- updated 1 yr ago
- 3replies
- 10
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

1
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…
- Sophie durrantTop Contributor
- Sophie_durrant
- 1 yr ago
- 2replies
- 30
- 1
- Last replySophie durrantTop Contributor1 yr ago
- Q&A
- Answered
- Answered

1
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…
- Sophie durrantTop Contributor
- Sophie_durrant
- 1 yr ago
- 2replies
- 20
- 1
- Last replySophie durrantTop Contributor1 yr ago
- Q&A
- Answered
- Answered

7
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,…
- Sophie durrantTop Contributor
- Sophie_durrant
- 1 yr ago
- 5replies
- 51
- 7
- Last replyimbarCommunity Team1 yr ago
- Q&A
- Answered
- Answered

5
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?…
- Dan SharmanTop Contributor
- Dan_Sharman
- 1 yr ago
- 6replies
- 43
- 5
- Last replyShai DvirPyramid Employee1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Janneke RichterCertification In Progress
- Business Intelligence consultant
- Janneke_Richter
- 1 yr ago
- 4replies
- 32
- Last replyJason PickerCommunity Team1 yr ago
- Q&A
- Answered
- Answered

0
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,…
- Alister Hill
- BI Project
- Alister_Hill
- 1 yr ago
- 1reply
- 12
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

6
How to create a loss triangle in Pyramid Analytics
Does anyone know of a way to create a loss triangle in Pyramid Analytics?
- Robert ClarkTop Contributor
- Robert_Clark
- 1 yr ago
- 11replies
- 154
- 6
- Last replyRobert ClarkTop Contributor1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Adam Taylor
- Adam_Taylor
- 1 yr ago
- 8replies
- 28
- Last replyAdam Taylor1 yr ago
- Q&A
- Answered
- Answered

1
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,…
- ErikCustomer
- Erik
- 1 yr ago
- 2replies
- 40
- 1
- Last replyErikCustomer1 yr ago
- Q&A
- Answered
- Answered

1
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.)
- Alec Mason
- Alec_Mason
- 1 yr ago
- 1reply
- 29
- 1
- Last replyJason PickerCommunity Team1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Jessica Weaver
- Jessica_Weaver
- 1 yr ago
- 2replies
- 31
- Last replyJessica Weaver1 yr ago
- Q&A
- Answered
- Answered

1
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.…
- Alister Hill
- BI Project
- Alister_Hill
- 1 yr ago
- 1reply
- 22
- 1
- Last replyIan MacdonaldAdmin1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Nicholas CampbellTop Contributor
- Nicholas_Campbell
- 1 yr ago
- 1reply
- 22
- Last replyIan MacdonaldAdmin1 yr ago
- Q&A
- Answered
- Answered

2
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.…
- Alec Mason
- Alec_Mason
- 1 yr ago
- 1reply
- 29
- 2
- Last replyJason PickerCommunity Team1 yr ago
- Q&A
- Answered
- Answered

0
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.…
- Frank Tobin
- Frank_Tobin
- 1 yr ago
- 1reply
- 22
- Last replyIan MacdonaldAdmin1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Markus Loy
- Senior Consultant BI & Data Management
- Markus_Loy
- 1 yr ago
- 1reply
- 19
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

1
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,…
- Alec Mason
- Alec_Mason
- 1 yr ago
- 1reply
- 35
- 1
- Last replyJason PickerCommunity Team1 yr ago
- Q&A
- Answered
- Answered

0
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.…
- Anastasia Pamina Dobasis
- Anastasia_Pamina_Dobasis
- 1 yr ago
- 1reply
- 22
- Last replyAvi PerezAdmin1 yr ago
- Q&A
- Answered
- Answered

2
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?…
- Markus Loy
- Senior Consultant BI & Data Management
- Markus_Loy
- 1 yr ago
- 2replies
- 39
- 2
- Last replyIan MacdonaldAdmin1 yr ago
- Q&A
- Answered
- Answered

0
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…
- Markus Loy
- Senior Consultant BI & Data Management
- Markus_Loy
- 1 yr ago
- 2replies
- 17
- Last replyMarkus Loy1 yr ago
- Q&A
- Answered
- Answered

0
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…
- ErikCustomer
- Erik
- 1 yr ago
- 9replies
- 55
- Last replyErikCustomer1 yr ago
- Q&A
- Answered
- Answered

1 3 4 5 6 7 23 Next

Got stuck with a report? Start a discussion or help others to move forward.

Key Resources

Pyramid Community User Survey

Community FAQs

Recent Tweets

Follow @PyramidAnalytic

Welcome to the community!

User Community

Q&A

Using URL Parameterization

Configure Model's Targets / Sources with a variable

Smart discover - allow selecting custom calculation

smart discover - change order of nesting

Negative number formats

Scaling options in Present panels

Hide unwanted subtotals

Colouring different parts of a dynamic text sentence.

Aggregating clients for a location while taking into account other locations

How can a mobile viewer user add favourites?

How to create a loss triangle in Pyramid Analytics

Adding a custom map

How to calculate aggregate correctly without using underlying details

Export List of Pyramid User Accounts

Present - Runtime Settings on slides, reports

Analysis Services Dynamic Management Views as IMDB Data Source

Multi Select (All) parameters

Stop distribution of when 'Finished with Errors'

PQL Custum Measure: modify value before passing to aggregation

Colorizing in Discover does not work as expected

Notification of Publication Failure

Remove expand icon of hierarchy within a matrix

Overlaying columns/bars with integrated variances (IBCS)

List of supported databases

Cumulative context but to exclude specific status measures (unable to reproduce solution)

Key Resources

Recent Tweets

Home

Key Resources