-
Getting Started with Pyramid
In our first session, we will cover the basic getting started workflow from Quick Model, to Discover and finally Present. These examples are simple and designed to acquaint you with the product.…
-
Troubleshoot a failure when trying to creating a large IMDB model
When creating a new model to an "IMDB" data source, and the model looks like it is created, but it cannot be queried in Discover (the Green app) (An error is shown).…
-
Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector
Introduction You’re working on an analytic project and have all the data you need, minus some crucial data that you suspect may be available on the internet.…
-
Python script in model: ok in preview, fails at runtime
Hello everyone. I am attempting to execute a python script module in Model. The key library I am using is googletrans, which allows API calls to Google translate to facilitate foreign language…
- Answered
-
How to: Display Daily Data in a Calendar View
How to: Display Daily Data in a Calendar View When you are working with Daily Data it will sometimes make sense to display the information in a Calendar view.…
-
How to connect Google Sheets to Pyramid
Pyramid can model and blend numerous complex data sources for basic or advanced analysis. The quick tutorial below shows how you can use Pyramid to access and import data stored in a Google Sheet,…
-
Update data from excel file in pyramid 2018?
Hi , I have an excel sheet as a soruce for my data model. the data is dynamic and I change them 5 time a day. i want to change my data on my excel sheet ,…
- Answered
-
Adding IMDB Server After Install
If you install the new Pyramid 2018 release without the new in-memory engine and then later want to add it, what should you use for the settings to add it as a data source?…
- Answered
-
Learning Live 2024: Pyramid 2023 Update
About this Video: In this Episode of Learning Live we will give you an update and overview of the new features and improvements that have been included in the Product since the launch of Pyramid…
-
Learning Live: Enriching Data with Python Scripts
About this Video: In this video we give you an overview about how you can enrich your analytics data with Python Script. Content: Lets check out this session,…
-
Learning Live: Pyramid with OpenAI and ChatGPT
About this Video: In this week's learning live, we will explore how ChatGPT can be utilized to analyze workflow conversations effectively. Leveraging Pyramid's capabilities,…
-
Tip of the Day - How to format a measure that is in seconds as hours minutes and seconds
How to format a measure that is in seconds as hours minutes and seconds Imagine you have a table column in a model that represents the duration of a period in seconds,…
-
Importing data from Excel - formatting decimals
Hello, I have downloaded new version of Pyramid Analytics and would like to make some visuals for a test. My initial inquiry got stuck in the phase of loading data from Excel.…
- Answered
-
Tip of the Day - How to Replace Nulls with Zeros
How to Replace Nulls with Zeros This tip will walk you through how to manipulate a column within Model, to replace NULLS with Zeros, using the convert and replace nodes within a data flow.…
-
Learning Live: Master Flows and Incremental Load
About this Video: This video tackles the task how to update your information sources with incremental loads. Adding data in slices, from a variety of sources with a Master Flow.…
-
How to: Extract all data from Reports while removing report filters
How to Extract all data from reports while removing report filters Users might have Discover reports with existing filters (for example filtering the report to only display the top 10% of customers)…
-
Learning Live: Advanced Workflows in Model
About this Video: This session will cover how to develop more sophisticated data transformation routines using Pyramid’s Master Flow functionality. We will showcase how to elevate your ETL processes…
-
Learning Live: The Hub and Personalized Dashboards
About this Video: In this video we give you overview about a new feature in the platform: 'The Hub'. These Hub provides a method to display individual content when users log into the platform -…
-
Learning Live: Custom Machine Learning with Learn/Predict Scripts
About this Video: In this video we give you an overview about how to run Custom Machine Learning in Pyramid with Learn and Predict Scripts. How it is developed,…
-
Concerns about Python Access
Hello, On our Pyramid installation, we're looking to host multiple tenants. However, we've encountered an issue where we can access the host's file system through Pyramid,…
- Answered
-
Learning Live: Custom Columns
About this Video: In this video we give you overview about our new feature in Discover: Custom Columns. From the inital problem that is solved with them,…
-
How to use Parent Child Hierarchies. From Tips & Tricks June 2022
Sneak: How to use Parent Child Hierarchies The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks to more…
-
Using same parameter for same model but pointing at different tables
Hi All, I have a model that creates some simple data sets. They are linked by location but each of them also have a parameter of "online sale" where a column states 1 or 0.…
- Answered
-
How to add Seasons to your Time Dimension
How to add Seasons to your Time Dimensions When building a data model the Time Intelligence option will automatically additional time based attributes based on any date fields.…
-
How to use direct query to create custom tables. From Tips & Tricks May 22
Sneak: How to use Direct Query to create Custom Tables The Tips&Tricks Series is produced by the Customer Success Team. It highlights several easy to follow instructions and range from simple tasks…
Search for answers here or ask a question