NPANS's Profile - Pyramid Analytics Community Forum

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
2 days agoWed, April 2, 2025 at 8:54 AM UTC
Questions & Answers
Reported - view

Re: Difference between the calculations

@Shuvankar Mondal this is a good start.

NPANS
3 days agoMon, March 31, 2025 at 5:11 PM UTC
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
7 days agoFri, March 28, 2025 at 8:33 AM UTC
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
13 days agoFri, March 21, 2025 at 4:16 PM UTC
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
2 wk agoThu, March 20, 2025 at 12:51 AM UTC
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
3 wk agoThu, March 13, 2025 at 8:09 PM UTC
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
3 wk agoTue, March 11, 2025 at 5:59 AM UTC
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
1 mth agoThu, February 13, 2025 at 5:58 PM UTC
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
1 mth agoThu, February 13, 2025 at 10:59 AM UTC
1
Questions & Answers
Reported - view

Re: 2 elements in 1 minitab

No, you cannot. It's not what it was designed for.

NPANS
1 mth agoTue, February 11, 2025 at 1:36 PM UTC
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
1 mth agoThu, February 6, 2025 at 8:12 PM UTC
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
1 mth agoThu, February 6, 2025 at 8:01 PM UTC
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
1 mth agoTue, February 4, 2025 at 4:42 PM UTC
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 agoMon, February 3, 2025 at 8:25 AM UTC
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
2 mths agoTue, January 14, 2025 at 9:05 AM UTC
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
3 mths agoThu, December 19, 2024 at 9:00 AM UTC
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 agoFri, November 29, 2024 at 1:01 PM UTC
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 agoFri, November 29, 2024 at 7:44 AM UTC
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
5 mths agoThu, October 24, 2024 at 4:29 PM UTC
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
5 mths agoThu, October 10, 2024 at 1:51 PM UTC
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
6 mths agoWed, September 25, 2024 at 9:21 PM UTC
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
7 mths agoMon, August 19, 2024 at 8:17 PM UTC
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
7 mths agoMon, August 19, 2024 at 4:12 PM UTC
Questions & Answers
Reported - view

Re: Making Custom Bins With Measures For Discover

@Cindy Tran Thats because there is technically no "measure" in custom columns. There are only table columns (otherwise known as model attributes). So, if you have a measure called "SALES" in the…

NPANS
9 mths agoTue, July 2, 2024 at 4:56 PM UTC
Questions & Answers
Reported - view

Re: Making Custom Bins With Measures For Discover

@Cindy Tran We do this all the time. The binning effectively takes any value column and introduces it as an attribute. Create a new custom column (or virtual column in the model) and use Imbar's…

NPANS
9 mths agoTue, July 2, 2024 at 4:14 PM UTC
Questions & Answers
Reported - view