Avi Perez's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid

Country

Latest Posts

Re: Question about Sets and Display Folder in SSAS Cube
First, we do not support display folders for SSAS named sets (sets designed on the server). There is a request for them, and you can vote for it if you want.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Unit of Measure
Yes - use the format string to style the measure. The custom format option will let you put whatever you want into the format mask. Remember to enclose the custom test in double quotes.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Folder & Location URLs
The content stored in the system is virtual. The folder path you are after does not physically visible or addressable on the drive of the servers. So, what you are after is a way to address a…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Number formats - "#,##0;(#,##0);" Only works for some users.
You cannot use 2 different formats on the same measure. You can try set formats on custom MEMBERS instead. Engines like MS Multidimensional OLAP or SAP BW can also allow you to do this by using…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Number formats - "#,##0;(#,##0);" Only works for some users.
Yes there is. Search for "Source Manager" in our help. Look for measure overlays in that section.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Number formats - "#,##0;(#,##0);" Only works for some users.
You are misinterpreting how the custom formats work. When a user changes a measure format in Discover, they are making a change for that measure across the platform for themselves only.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Drill Through within Measure?
The Excel approach is highly problematic when working on real databases. When you get this effect in Excel, you are typically pulling the data from another Excel spreadsheet - which is small and…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Calculate difference from two table on presentation
No, not at the moment - unless you built a third model that blends the other 2 somehow. We are busy developing a sophisticated response to this general problem - but it's only due in the next major…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Through within Measure?
The affect you are after is called a "drill-through" - which means take the high level stuff I'm looking at and go and dredge up the transactional or granular detail behind it.…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 2
- Questions & Answers
- Reported - view
Re: Gauge Tri band
There was a fix for this issue pushed in the latest version (2020.4.11+).
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Re: Blank Pages
Also try the "IsEmptyQuery" function in the same way.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- Questions & Answers
- Reported - view
Pyramid 2020.04 (Service Pack 4-A) Released

An intermediate service pack - 2020.04.011 - for Pyramid has been released and includes a few key fixes and improvements. The release should only be applied if the specific fixes are needed in your…
- "making the sophisticated simple"
- AviPerez
- updated 5 yrs ago
- 286
- Product Announcements
Improving Windows Authentication and Kerberos Delegation

As of version 2020.04.011, Pyramid will offer new settings to streamline Windows Authentication SSO implementations. This will offer the benefit of Win Auth and Kerberos delegation where and when…
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 149
- 1
- Tech Blogs & Webinars
Re: Display Folders from Tabular Model
We don't support multiple folders (I'm not sure why you would want to). Use one only.
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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].…
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 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…
- "making the sophisticated simple"
- AviPerez
- 5 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.…
- "making the sophisticated simple"
- AviPerez
- 5 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.
- "making the sophisticated simple"
- AviPerez
- 5 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Horizontal bar chart with two values
use the "shared primary" options in the value drop zone.
- "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