Skip to main content
User Community
Pyramid
Help
Learn
Support
Generative BI
How to enable Javascript
Sign Up
Login
Welcome to the Pyramid User Community
Pyramid User Community
Search for answers here or
ask a question
Questions & Answers
Explore Pyramid
Product
Events & News
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
1195
posts
144
likes received
16
followers
Badges
7
1
Company
Pyramid
Country
Namibia
Latest Posts
Re: Creating a waterfall using deduction amounts
are your "deduction types" measures or items in a hierarchy?
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Cloud Server Quick Start
Yes. It will be launched sometime in December.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: V2020 Unable to set Chart data label to white font
In 2020, the font colors are automatically ignored if the contrast between the background and the foreground is too not clear enough.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Is there a way to search through a list of cubes for specific key words?
@Kelly Scott The cost of opening up every cube definition and finding something inside it is prohibitive in real world scenarios. Its why we don't do it.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Is there a way to search through a list of cubes for specific key words?
Search for what? Cube by name? something inside the modeling of the cube?
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Conditional Formatting
If you want the 100% totals to go across thew rows - then this is how the calc and visual will work. The next approach is more depth, but it may resolve it for you,…
Attachments
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: query a report between dates
@Ray Johnson Its been there for quite some time. Please the response to your other posting.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Limiting Results to All Data After x/xx/xxx Date
The most robust technique is to build a list or set. Assuming you want to pick the to and from dates, build 2 date parameters in the Formulate parameter tool - that is a simple listing of all dates.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Latitude and Longitude
@Ray Johnson you should try running a direct query to your relational db (if you have one) or pushing it through the in-memory database. You might be really surprised at the greater flexibility…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Duplicate Discoveries in Presentation
You cannot. The query underlying duplicates is shared by all visual instances. You should duplicate the discovery and add them independently to your visual.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Creating multi-charts
@Nate Meyer There is no totals chip. One way to solve it is to create a new measure that is the aggregate of the items you'er looks at using the Formulate tools and then plot that.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Batch Processing// Multi Threading// Parallel Processing
Peerzada A few thoughts and comments on your question: The "ETL" or yellow tool builds packages for importing/cleaning data. These packages are executed on the "Task" server tier.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: Conditional Formatting
When using the 'quick' percentage indicator, it will calculate each cell as a percentage of the total for an ENTIRE MEASURE - regardless of the columns or rows.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Publish email with attchment
Please see the topic in help for full details of the licensing switches needed to get the attachment option to appear:…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Publish email with attchment
You can only attach emails with an enterprise license. Otherwise you can only add links to your email.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Page Repeater
No. At the moment, the page repeater only works on a single page.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Coloring specific cells
There are numerous out of the box coloring options. Please read the help on the color drop zone.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: Latitude and Longitude
What type of data source are you using? If its MS OLAP/Tabular or SAP BW, you'll need to build the aggregation type into the cube/model directly - it cannot be changed directly from Pyramid.
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: How to remove Grid header deatils
BTW: The "title" can be turned off in Discover from the design tab. Perhaps this is what you are after?
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: Calculate difference from two table on presentation
You should solve this with a third query. You can easily build a function using Formulate that is the underling difference between the 2 measures in both grids.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Adjust default aggregation for date drill down levels.
At the moment we do not offer an 'Average of Children' aggregation option. one way to solve it is to build the standard additive metric on your fact table and then a second metric counting the…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
1
Questions & Answers
Reported - view
Re: How to set Custom Order
If the model was created with Pyramid, you should use an independent column to determine the sort order since your captions are sorted using plain text.…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
Re: Pyramid Usage Model and Analysis
For explanations on the model metrics see this posting. https://community.pyramidanalytics.com/t/184nyf/pyramid-usage-model
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Tech Blogs & Webinars
Reported - view
Re: Pyramid Usage Model
Response Size Metrics Column Count: number of RAW columns in the result set Row Count: number of RAW rows in the result set Cell count = columns x rows The RAW result set is not always indicative of…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
2
Questions & Answers
Official response
Reported - view
Re: How to get # of days between given two dates
You need to use the "datediff" common library function. Create a custom measure formula in Formulate. I would swap to script mode. It will look something like this datediff( [transactions].…
Avi Perez
Admin
"making the sophisticated simple"
AviPerez
4 yrs ago
Questions & Answers
Reported - view
1
6
7
8
9
10
11
12
Home
Questions & Answers
Explore Pyramid
Pyramid Explore Missions
Learning Live Archive
Tech Blogs & Webinars
Pyramid Dashboard Gallery
Product
Product Announcements
Product Ideas
Current Product Ideas
Completed Product Ideas
Knowledge Base
Admin
Data Sources
Databases
Discover
Formulate
General
Install/Upgrade/Cloud/License
Model
Performance
Present
Publish
SAP
Security
Events & News
Upcoming Events & Webinars
Getting Started
Community News
Customer Success Activities
What's New
View all topics