NPANS's Profile - Pyramid Analytics Community Forum

Badges

Latest Posts

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
- 2 wk 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
- 2 wk 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 4 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
- 4 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
- 4 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
- 4 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
- 5 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
- 5 mths ago
- Questions & Answers
- Reported - view
Re: Default theme not pre-selected
It might only take effect on a refresh of the client application
- NPANS
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Common Y-Axis Scaling for Trellis Column Charts
- NPANS
- 6 mths ago
- 1
- Questions & Answers
- Reported - view
Re: How to skip first N rows when reading an excel file using pyramid when the header is not necessarily the first row.
Mark the grid of Excel data with a name (aka "named range") or as an Excel table.
- NPANS
- 6 mths ago
- Questions & Answers
- Reported - view
Re: Pyramid 2023.11 Released
@Obee1 Yes...... incredible.... according to Microsoft, and I am quoting here: Copilot can't modify the visuals after it has generated them. Copilot can't add filters or set slicers if you specify…
- NPANS
- 6 mths ago
- 1
- Product Announcements
- Reported - view
Re: How To Install Python Packages
Search in the help for 'DSML Environments' and 'Virtual Scripting Environments'
- NPANS
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Bad design has left me with database fields that can be populated with comma separated list
Add a new Python environment and use the Pandas module that you want.
- NPANS
- 7 mths ago
- Questions & Answers
- Reported - view
Re: Dynamic calculation measure for Prev Qtr End using selected date of report
@Obee1 Yikes! You can do this using the time calc wizard in 4 clicks. In Discover, use the 'time calculations' wizard on the query tab of the ribbon in the drop down,…
- NPANS
- 7 mths ago
- 1
- Questions & Answers
- Reported - view

1 2 3

Welcome to the community!

User Community

NPANS

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

Re: Default theme not pre-selected

Re: Common Y-Axis Scaling for Trellis Column Charts

Re: How to skip first N rows when reading an excel file using pyramid when the header is not necessarily the first row.

Re: Pyramid 2023.11 Released

Re: How To Install Python Packages

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

Re: Dynamic calculation measure for Prev Qtr End using selected date of report

Home