Avi Perez's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid

Country

Latest Posts

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
Re: Seamless page loading
Priyanka Its not clear from your example which link does the thing you are expecting. Please be specific and maybe provide a screen shot. Separately, what in the context of Pyramid,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Left outer join not working
I suggest you create a support ticket and have them directly help you with your specific data set and schema problem.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: What/How are the actions coded? If, then logic, etc.
Ray I would start looking at help on actions here and here. For help on constructing action expressions, I would start with an overview of the full PQL function library here,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: How do you prevent business users from saving within the folder while allowing them to view the content/create new (personal) discoveries?
This question has many detailed aspects to it. The following is a light synopsis. Personal folder space gives the user the freedom to create anything for themselves and save freely.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Accounting Grid
At the moment no. There is an accounting grid format and you can edit general settings like font color, line color etc. But settings per level are not currently available.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Semi-Additive measures
The relational querying engine does not support these types of aggregations (SQL itself has no such logic). We may add it in the future. Separately, accessing Analysis Services on premise, via Pulse,…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Highlight(select) items with "shift" button and add them to grid
Use CTRL+Click to highlight items in random order selection. Use SHIFT+Click to highlight a range with a "from" - "to" selection. Once highlighted, push the space bar on your keyboard to select all…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Make multiselect filters selections visible
Change it to a multi-select list instead of a multi-select drop-down.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Changing decimal places on percentage data label
The percentage option is a "quick" technique for adding percents to your charts - so there is little flexibility. The stronger solution means creating a calculation (with your chosen data format),…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view

1 6 7 8 9 10 11 12

Back to top

Home

Questions & Answers

View all topics