Avi Perez's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid

Country

Latest Posts

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…
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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:…
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Page Repeater
No. At the moment, the page repeater only works on a single page.
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 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?
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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].…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Call Stored Procedure
Your approach makes no sense. If you want to display a limited set of data in a query, use slicers and query parameters on an existing data base via a data model (direct or otherwise).…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to call or execute(take as data-source) an SQL stored procedure in pyramid analytics
You cannot currently call a stored procedure as a live data-set from Pyramid. Instead you can use the Model tools to ingest results from the stored procedure into another data model.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Enabling access at Folder Level in Public Content
This is not correct. All folders have their own role settings that allow you to set access for the entire folder and its subordinate elements. Select the folder and then right click and look at its…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Publications with Discoveries across pages?
This feature, called a "flow grid", is not available yet in the product. You can follow its progress here and vote for it.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Can Admin see which reports Users have accessed?
Yes. There is a way. The most effective on-going method is to use the transaction logs which will give you a bird's eye view of the entire system, its usage by user, date,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: How to remove Grid header deatils
this is not currently possible.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: map customization
1. Showing different symbols is not possible at the moment. I suggest you post an idea's request on the forum for this. 2. Create an attribute in your data model that flags each type of address,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Percentage of row total
The percent of total logic (driven through a context calculation) will act as follows: If the measure is in the background, it will apply to the entire grid,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view

1 7 8 9 10 11 12 13

Back to top

Home

View all topics