-
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.…
-
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,…
-
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.…
-
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,…
-
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
-
"Model", one word and many meanings
When working with Pyramid Analytics we often mean different things when we refer to “Model” or “Data Model”. In this post I will clarify the main distinctions between the different model terms.…
-
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).…
-
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,…
-
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…
-
When trying to use an R script from the Market Place an error occurs
When trying to use a script from the Market Place that uses one of R packages e.g the “Sentiment analysis” (uses stringr package) the following error occurs: "scripting error:Error:…
-
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)…
-
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
-
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…
-
Let's talk about Dimensions and Measures
Dimensions and measures are the two central building blocks in multidimensional reporting. In Pyramid Analytics, they are mainly dealt with in the “Model” and “Discover” modules.…
-
Order Dimension Tables
Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.
- Answered
-
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.…
-
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
-
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
-
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
-
Tips & Tricks - Vol 2/21 - Discover - Model - Present - Publication
Sneak: Calculate YoY Growth% + Distinct Count + How to build an Alert + Dynamic Text + Chromecast Pyramid + Rank Calculation Tips & Tricks created by the Pyramid Customer Success Team The…
-
How to use a Report or Page Trigger to generate a Publication when criteria are met
How to use a Report or Page Trigger to generate a Publication when criteria are met When you offer to trigger a report or page from your Publication, it only makes sense to start the process if the…
-
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 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…
-
Filtering on 2 dimensions and counts
Hi community, I am struggling to do something that I think should be possible so asking for help here
I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…- Answered
Welcome to the Pyramid User Community
Pyramid User Community