Skip to main content
User Community
Pyramid
Help
Learning Hub
Support
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Questions & Answers
Explore Pyramid
Product
News & Events
Member Lounge
Latest Activity
Home
Profile
Avi Perez
Admin
AviPerez
"making the sophisticated simple"
Everywhere
www.pyramidanalytics.com
Follow
Joined
Sat Jul 30 23:34:10 UTC 2016
1292
posts
176
likes received
20
followers
Badges
2545
18
1
3
1
Company
Pyramid
Country
Namibia
Latest Posts
Re: Display Folders from Tabular Model
We don't support multiple folders (I'm not sure why you would want to). Use one only.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Can I Publish to pdf and have Discoveries wrap onto subsequent pages?
When you print Discover reports directly, they will be multi-page if needed. Ensure you don't choose "Scale to fit" in the print dialog. "Flowing" content is not currently supported in Publish…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Is there any way to count filtered rows in formulate?
Here is an example: it counts all states starting with "new" and deducts that from the total number of states. count(AllMembers([customers].[State]) ) - count(StartsWith(AllMembers([customers].…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Add interactions accross diffent slides
Philipp: Slicers/filters are global. if you make a change on one slide, the change will be reflected on all other slides. The change, however, is only triggered when a user selects the new slide.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
2
Questions & Answers
Reported - view
Re: Single/MultiSelect Tree Slicer Default Selection
Tree slicers are very tricky (unfortunately). The cannot reflect classic sets or lists like the other slicers including the other capabilities like default member choice - because of the tree…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: Geospatial map using german zip codes
The general flow requires you to supply an attribute in your data model that designates country. Then you don't need to use the dialog box - which is a short cut for data models that don't have a…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
2
Questions & Answers
Reported - view
Re: Formulate: Comine Standard List with a Measure
First, as a general concept, the PQL and MDX languages are very flexible in achieving almost any logical formulation needed. Sometimes, the graphical tools don't facilitate this flexibility so you…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: Access: designate User Defaults
The user defaults are set by tenant only. After creating a user defaults template, you set it for a given tenant in the tenants editor. They then apply to all Pro users in that tenant.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: Defining Custom Color Palette
Practically, this simply means adding more predefined colors to the theme color palette beyond the 16 slots already provided. If this is truly what you want please add it as an idea to the ideas…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Defining Custom Color Palette
Yes. The theme editor is available in the admin console to define custom colors, fonts, lines, backgrounds etc for visuals and all other cosmetic elements.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Multiple Members Search
If you would like this feature (and it sounds like you do!), please add it to the ideas section so its included in development considerations and others can vote on it.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: Horizontal bar chart with two values
use the "shared primary" options in the value drop zone.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Creating a waterfall using deduction amounts
I believe the new Waterfall capabilities in 2020.02 close out the challenges you had in this thread.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Salesforce as Data Source with filtering
SOQL capabilities are being added to the platform and should be out in the next release.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Want a appropriate solution for error code RGE-1001.
Thanks for letting us know. Can you give us a few links to pages hosting video's that don't work. We'll need to see if the problem is on the hosting end (YouTube, Wistia),…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Display Folders from Tabular Model
First, display folders are designed to let you group and sub-group measures as needed. This is their actual role - and its how it's used in Pyramid. Measure groups are not an organization tool -…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Grand Total: calculation
Turn on the "Overwrite Solver Order" and set it to something bigger than 0. It defaults to 1000. This should resolve the problem. For future note, we continue to investigate techniques on how to…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Grand Total: calculation
Before diagnosing this in great detail, check the following: the total option you chose was it "SUM" or "AGGREGATE" in the dialog box. If it is sum, change it to "aggregate" - which will sum the…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Trigger / Click Action based on Slicer Selection (Presentation)
A select and jump option from an analytical view or slice is not available. The only suggestion is to have the selection auto-inject into an action button and then have the user click on the button…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: V2020 Unable to set Chart data label to white font
More control over color settings through "readability" is now offered in 2020.02.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: Can you rename "Default Section" in a presentation?
This is a known bug that is fixed in 2020.02 - which will be released shortly.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Direct URL to Presentation Content (Slide xyz)
there isn't.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: can we refresh chart or grid data automatically at run time?
make sure the "caching" is turned off in the Discover report.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
Re: Trigger / Click Action based on Slicer Selection (Presentation)
Slicers today do not trigger an action - they can only inject selections into other items that can then be used with the action. You have already stumbled on the perfect alternative - grids.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
1
Questions & Answers
Reported - view
Re: V2020 Unable to set Chart data label to white font
@Robert Taticek Please follow 'Product Announcements' to get emails on when things are released. The updated converter will come out with the second service pack for 2020 (2020.02) very soon.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
6 yrs ago
Questions & Answers
Reported - view
1
7
8
9
10
11
12
13
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Highlights
Product Ideas
Current Product Ideas
Archived Product Ideas
Knowledge Base
Embedding Pyramid
Admin
Data Sources
Databases
Discover
Formulate
General
Deployment & Setup
Model
Performance
Present
Publish
SAP
Security
News & Events
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
Member Lounge
View all topics