User Community
Pyramid
Help
Learn
Support
Search
How to enable Javascript
Sign Up
Login
Welcome to the community!
User Community
Search
Search for answers here or
ask a question
Q&A
Best Practices
Product
Resources
Latest Activity
Home
Create post
Q&A
Latest Activity
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
Got stuck with a report? Start a discussion or help others to move forward.
Filter
Newest
Active
Popular
Most likes
Most replies
Most views
Status
Answered
Unanswered
Tags
Search
Follow
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 Z
Certification In Progress
Niko_Z
1 yr ago
1
reply
35
1
Last reply
Avi Perez
Admin
1 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
1
reply
25
2
Last reply
Avi Perez
Admin
1 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 Yossef
Pyramid Employee
Customer Solutions Architect
Moshe_Yossef
1 yr ago
3
replies
12
Last reply
Avi Perez
Admin
1 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 Yossef
Pyramid Employee
Customer Solutions Architect
Moshe_Yossef
updated
1 yr ago
3
replies
10
Last reply
Avi Perez
Admin
1 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 durrant
Top Contributor
Sophie_durrant
1 yr ago
2
replies
30
1
Last reply
Sophie durrant
Top Contributor
1 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 durrant
Top Contributor
Sophie_durrant
1 yr ago
2
replies
20
1
Last reply
Sophie durrant
Top Contributor
1 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 durrant
Top Contributor
Sophie_durrant
1 yr ago
5
replies
51
7
Last reply
imbar
Community Team
1 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 Sharman
Top Contributor
Dan_Sharman
1 yr ago
6
replies
43
5
Last reply
Shai Dvir
Pyramid Employee
1 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 Richter
Certification In Progress
Business Intelligence consultant
Janneke_Richter
1 yr ago
4
replies
32
Last reply
Jason Picker
Community Team
1 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
1
reply
12
Last reply
Avi Perez
Admin
1 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 Clark
Top Contributor
Robert_Clark
1 yr ago
11
replies
154
6
Last reply
Robert Clark
Top Contributor
1 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
8
replies
28
Last reply
Adam Taylor
1 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,…
Erik
Customer
Erik
1 yr ago
2
replies
40
1
Last reply
Erik
Customer
1 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
1
reply
29
1
Last reply
Jason Picker
Community Team
1 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
2
replies
31
Last reply
Jessica Weaver
1 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
1
reply
22
1
Last reply
Ian Macdonald
Admin
1 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 Campbell
Top Contributor
Nicholas_Campbell
1 yr ago
1
reply
22
Last reply
Ian Macdonald
Admin
1 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
1
reply
29
2
Last reply
Jason Picker
Community Team
1 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
1
reply
22
Last reply
Ian Macdonald
Admin
1 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
1
reply
19
Last reply
Avi Perez
Admin
1 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
1
reply
35
1
Last reply
Jason Picker
Community Team
1 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
1
reply
22
Last reply
Avi Perez
Admin
1 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
2
replies
39
2
Last reply
Ian Macdonald
Admin
1 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
2
replies
17
Last reply
Markus Loy
1 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…
Erik
Customer
Erik
1 yr ago
9
replies
55
Last reply
Erik
Customer
1 yr ago
Q&A
Answered
Answered
1
3
4
5
6
7
23
Next
Ask a new question
Got stuck with a report? Start a discussion or help others to move forward.
Key Resources
Pyramid Community User Survey
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help
Recent Tweets
Follow @PyramidAnalytic
Home
Q&A
Best Practices
Selected Materials from Learning Live
Learning Live Topic Suggestions
Pyramid Innovators
Tips & Tricks
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowleg Base
General
Performance
Databases
Security
Install/Upgrade/Cloud/License
Admin
BI Office
BI Office Product Announcements
BI Office Blogs
BI Office - Knowledge Base
Resources
Getting Started
Community News
Upcoming Events & Webinars
Customer Success Activities
What's New
View all topics
Key Resources
Pyramid Community User Survey
Community FAQs
Register for Pyramid Webinars
Pyramid Learning Hub
Pyramid Tutorial Videos
Pyramid Support
Pyramid Help
BI Office Help