NPANS's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Latest Posts

Re: Pyramid 2025 "Newton" Released !
Yay!
- NPANS
- 2 wk ago
- Product Announcements
- Reported - view
Re: Turn off time changes
System time is determined from the OS's running your servers. If you want to change the clocks, you need to somehow change the time in your operating systems.…
- NPANS
- 2 wk ago
- 1
- Questions & Answers
- Reported - view
Re: Building cascading filters/slicers that contain only relevant values of charts at the presentation layer
@Michael Daun I agree with you. Pulling up too many filters / slicers is not a good design because you're effectively retrieving every value for every attribute used.…
- NPANS
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Difference between the calculations
@Shuvankar Mondal this is a good start.
- NPANS
- 3 wk ago
- Questions & Answers
- Reported - view
Re: Purpose of the different filter panels
This is a good question that requires a long answer! From my experience deploying Pyramid, it is an area that some people initially misunderstand. At first, we thought it was overly complicated.…
- NPANS
- 4 wk ago
- 4
- Questions & Answers
- Reported - view
Re: Cascade for date filter
@Mohit Bhandari You can create a two-way by drawing the interactions in both directions.
- NPANS
- 1 mth ago
- Questions & Answers
- Reported - view
Re: How to wrap text in a Cell in Discover. From Tips & Tricks Vol 5/21
@Shuvankar Mondal There isn't. Although, it the row expands to wrap for one field, it expends for all items in the row. It will look a little strange for some to wrap and others to be cut-off or…
- NPANS
- 1 mth ago
- Discover
- Reported - view
Re: Is there a way to create a parameter for a user to choose the time display (eg month, quarter, year)?
Technique #1: tedious, but simple create a global parameter that has 4 switches : week, month, quarter, year build each discover report 4 times: one for each date range in a presentation,…
- NPANS
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: PQL lookup second largest value
@Michael Daun 's original suggestion is the right way to go. In fact, you can build a mini grid that specifically answers the question without repeating the entire query as is.…
- NPANS
- 1 mth ago
- 1
- Questions & Answers
- Reported - view
Re: Prioritize the Discover level over the Presentation layer when displaying or hiding specific dimensions using the Runtime Settings
The settings need to be set in the presentation itself. They are not imported over.
- NPANS
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Alerts that loop through multiple data points
The alerts are built using the dynamic text engine - which may have the formulas you need. So, build a basic alert. Choose advanced in the dialog Edit the trigger and add/update the logic of the…
- NPANS
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: 2 elements in 1 minitab
No, you cannot. It's not what it was designed for.
- NPANS
- 2 mths ago
- 1
- Questions & Answers
- Reported - view
Re: hyperlinking
Hyperlinking text is not a truly feasible solution. The column either contains label text or it contains URL text. The engines cannot magically combine 2 random columns together to create the visible…
- NPANS
- 2 mths ago
- Questions & Answers
- Reported - view
Re: hyperlinking
If your URL template is consistent, you can use the "actions" mechanism. Although your users need to right click and choose the action from the menu, it's a quick way to get what you want.…
- NPANS
- 2 mths ago
- Questions & Answers
- Reported - view
Re: Origin date format isn't recognized by Pyramid as a DATE
The model cannot guess it's a date unless it's really a date. Add a calculated column that splits out the string using the "substring" functions and then reconstitute the elements as a proper date…
- NPANS
- 2 mths ago
- Questions & Answers
- Reported - view
Re: API for Testing In-Memory Data Source Connection
Create a simple Discover report against the relevant data source. Then use the analytics APIs to open ("extract") that report. If you get a result - it's working. Otherwise, it's not.
- NPANS
- 2 mths ago
- 2
- Questions & Answers
- Reported - view
Re: Tenant-localizable field names
The overlay engine may be what you are after. https://help.pyramidanalytics.com/Content/Root/AdminClient/data%20sources/Hierarchy%20Overlay.htm
- NPANS
- 3 mths ago
- Questions & Answers
- Reported - view
Re: Table in Present automatically changing to different style on resize.
In the Present designer, right click on the item. Choose visuals options > miniature off.
- NPANS
- 4 mths ago
- 3
- Questions & Answers
- Reported - view
Re: Publication Subject - Bold
@Aaron Yohannan It sounds like your customer is ignorant of most email solutions. Perhaps GMAIL in a browser allows it. Outlook doesn't, and I'm sure most phone email systems won't support it.…
- NPANS
- 4 mths ago
- Questions & Answers
- Reported - view
Re: Publication Subject - Bold
This is the subject line of an email. You cannot format the subject lines of emails - because the email client would need to show it and most (if any) don't.
- NPANS
- 4 mths ago
- Questions & Answers
- Reported - view
Re: How to define a Design Theme for grids with a single-color background?
Use the accounting grid style for quick result.
- NPANS
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Maps in Pyramid
The maps will not show your regions unless these names and locations are globally understood designations. For example, it will understand the state of "California",…
- NPANS
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Schedule Model Refreshes for a window of time
I believe this cannot be done with the built in scheduler. However, you can call schedule executions via API. In which case, create your bespoke app, with your own timing logic that triggers a…
- NPANS
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Publication Performance
Based on your responses, the most obvious issue is the query times. If the queries are taking 223 seconds, or just under 4 minutes to run, then Pyramid itself is only consuming about 1minute of your…
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Publication Performance
Please provide more context on your environment and setup: Who else and what else is using this machine when these things are being processed? Are other people using this solution at the same time?…
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics