NPANS's Profile - Pyramid Analytics Community Forum

Skip to main content

User Community

Badges

Latest Posts

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
- 2 days 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
- 1 mth 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
- 1 mth ago
- 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 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 2 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
- 3 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
- 3 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
- 4 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
- 5 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
- 5 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
- 6 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
- 6 mths ago
- 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
- 8 mths ago
- 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
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Help regarding pyramid learning materials.
@Supriya Misal There are tons of training videos freely available in the help, plus the interactive tutorials offered in the product itself for Pro users (its literally on the welcome panel).
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view
Re: External IMDB Service Setup
There is a good guide on scaling Pyramid in the online help (search for "scaling guide"). It covers the entire platform and has some recommendations on the in-memory database service ("IMDB").…
- NPANS
- 8 mths ago
- 6
- Questions & Answers
- Reported - view
Re: Concerns about Python Access
Pyramid includes a variety of capabilities (Python, R, command line access, SQL) that can all be abused if not managed: "with great power comes great responsibility".…
- NPANS
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Using an Excel List or Power BI list to Filter Pyramid Report
There are at least 2 ways to do this: 1. Short to the Point: Open up Model Pro, create a data flow. The first source item should be a "Pyramid Content" item,…
- NPANS
- 9 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Using an Excel List or Power BI list to Filter Pyramid Report
@Andrew Smith Your approach does sound cumbersome! To give you a better approach, please explain a little more about your data and setup. Like: What data source does the Pyramid report operate off?…
- NPANS
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Calculation based on Date Filter Range
Build a complete and separate date table that joins to the facts (turn on bi-directional). Either count the months off this table or sum a counter column (using a "1") on the table.…
- NPANS
- 9 mths ago
- 1
- Questions & Answers
- Reported - view

1 2 3 4

Back to top

Home

View all topics