NPANS's Profile - Pyramid Analytics Community Forum

Badges

Latest Posts

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
- 19 hrs 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
- 3 wk 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
- 1 mth 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
- 1 mth 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
- 2 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
- 3 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
- 3 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
- 4 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
- 4 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
- 6 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
- 6 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
- 6 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
- 6 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
- 7 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
- 7 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
- 7 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
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Filter Selected Date
@imbar if you are using real dates, and just need it as a filter, this option is FAR simpler and FAR quicker. Simply drag the data chip to Filters, and the calendar is instantly operational
- NPANS
- 7 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan The key trick lies in the left joins - a central concept resolved in SQL itself. Custom Columns don't have to be in the model. You can add the columns into the model itself as a…
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Is it possible to create a combined list by selecting members from two different tables and columns?
@Vijayan Krishnan If you need the details resolved at the grain (which is sounds like), you need to use custom columns. Otherwise, you can build a semantic "list" and filter it using the nonempty…
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Allow microphone use in a browser or mobile app
@Dmitri Kanounnikov Is the site using a valid SSL certificate for secure comms via HTTPS? The browsers will block the microphone without it.
- NPANS
- 8 mths ago
- Questions & Answers
- Reported - view
Re: Allow microphone use in a browser or mobile app
This has nothing to do with Pyramid. It's your browser and its settings (see help for the details). It may also be corporate rules and policies. In Chrome (and other browsers) you can right click on…
- NPANS
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Bad design has left me with database fields that can be populated with comma separated list
@anonymous client It's in help. Do a search for "add Python environment."
- NPANS
- 8 mths ago
- 1
- Questions & Answers
- Reported - view
Re: Automated Export/Extract to SQL Server
@terrance smith The plot thickens................ If you want to automate this process with a UI experience, then options 1 and 2 are no good - they work without a UI to intercept the query.…
- NPANS
- 9 mths ago
- Questions & Answers
- Reported - view
Re: Automated Export/Extract to SQL Server
There are multiple techniques for this: Use the 'Data Flow' tools in Model: set the chosen report as a source and choose your SQL server as the target. It would go straight without issue. No CSV etc.…
- NPANS
- 9 mths ago
- Questions & Answers
- Reported - view

1 2 3

Welcome to the Pyramid User Community

Pyramid User Community

NPANS

Re: Tenant-localizable field names

Re: Table in Present automatically changing to different style on resize.

Re: Publication Subject - Bold

Re: Publication Subject - Bold

Re: How to define a Design Theme for grids with a single-color background?

Re: Maps in Pyramid

Re: Schedule Model Refreshes for a window of time

Re: Publication Performance

Re: Publication Performance

Re: Making Custom Bins With Measures For Discover

Re: Making Custom Bins With Measures For Discover

Re: Help regarding pyramid learning materials.

Re: External IMDB Service Setup

Re: Concerns about Python Access

Re: Using an Excel List or Power BI list to Filter Pyramid Report

Re: Using an Excel List or Power BI list to Filter Pyramid Report

Re: Calculation based on Date Filter Range

Re: Filter Selected Date

Re: Is it possible to create a combined list by selecting members from two different tables and columns?

Re: Is it possible to create a combined list by selecting members from two different tables and columns?

Re: Allow microphone use in a browser or mobile app

Re: Allow microphone use in a browser or mobile app

Re: Bad design has left me with database fields that can be populated with comma separated list

Re: Automated Export/Extract to SQL Server

Re: Automated Export/Extract to SQL Server

Home