Avi Perez's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Company

Pyramid

Country

Latest Posts

Re: Dynamic formatting of table headers
We only support data formats, foreground and background colors from the cube. You can turn that on from the Query tab with "Model Colors" and "Model Formats". Font settings are ignored.…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Drill Down in an inner dimension of two nested ones
We don't see such behavior in Excel - it works like Pyramid. Can you upload some screen shots of what you see and what you're doing. Also, what data source etc.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Relation between discoveries
Build a "list" out of the products and reuse it in both discovery reports.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Can you change the headers of the columns?
FYI: As of 2020.10, you can make overlay changes for all users if you are an admin.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: How to add text in the header or footer of a publication?
The master page concept is based on more advanced layout tools and design applications, where people need to create layout concepts of various things that go well beyond simple headers and footers.…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Custom sort ordering - order by top N but leave "other" at bottom
Imbar's suggestion is how to resolve your issue. You need to construct a list/set of the top N items - sort that as you want with the List builder (you can use any element in the model to drive the…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Change Discovery Column Label without Changing the Measure Caption throughout the system
Please see the response here.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Unit of Measure
This technique, via the Discover, sets it for yourself only. To set it for users (by role), you should do it through the admin in the data source manager.…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Unit of Measure
Currency is the regional locale of your data. So it likely defaults to "$". To create any other unit simply use the custom format option and type it in. To set it up for Euro's type: "€" #,#
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Create a table in publish
This option is not yet available in Pyramid 2020. There are new tools for layout and alignment coming out soon, while a proper table object will appear towards the end of Q3 2020.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: PA mobile version dashboard
First, the mobile interface uses the tiled layout mode. Second, the creation of content is the same as the full app - except things are auto-redacted to fit the small screen size.…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Database Write Back

Pyramid is often asked when they will add a "write back" option to the tools. Often such functionality is centered around capturing end-user data input or budgeting and planning applications.…
- "making the sophisticated simple"
- AviPerez
- updated 4 yrs ago
- 5replies
- 338
- 10
- Tech Blogs & Webinars
Re: Can you change the headers of the columns?
not on the grid itself. use properties.....
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: PA mobile version dashboard
When you build a presentation you can elect to design a specific version of that dashboard for tablets and phones independent of the desktop version. There is some (light) explanation of the process…
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
Re: Question about Sets and Display Folder in SSAS Cube
Please contact support to help you out.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- Questions & Answers
- Reported - view
Re: Pyramid Office Hours 4/16: Arrangement of Labels on Bubble Chart
If you look carefully, the labels do not overlap with each other.
- "making the sophisticated simple"
- AviPerez
- 4 yrs ago
- 1
- Questions & Answers
- Reported - view
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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- 2
- Questions & Answers
- Reported - view

1 6 7 8 9 10 11 12

Back to top

Home

Questions & Answers

View all topics