-
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.…
-
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,…
-
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 build Neural Networks in Model
In a recent internal discussion, we came across the question if it is possible to use more than one hidden layer in the "Shallow Neural Net" node from our Machine Learning elements in Model.…
-
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.…
-
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,…
-
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…
-
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: 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)…
-
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.…
-
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
-
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.…
-
Union: Adding Attributes to a Node
How do you Map Your Measures? You have numbers accrued in a database or excel for months, but nobody has taken an interest in them. You want to unleash the can of worms, so to speak,…
-
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.…
-
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
-
How to determine DataFlow NodeID?
Good day everyone, I try to automate the change of data models via the Pyramid API. But I can't find a function to get the Node ID of an existing model.…
-
Global variable doesn't update when new model is processed
Hello, I'm trying to use a conditional to check the most recent run date column in a model and compare it with today's date. I'm hoping to create a crude validation that will email stakeholders and…
- Answered
-
Reordering Columns Once Model Has Processed
So in pyramid model there is a column operation that allows me to reorder the columns. Still, once I process the model, the order of the columns that is displayed is not what I specified in the model.…
- Answered
-
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
-
Last non empty function Modell Pro
Hello Pyramid Community, is it possible to select the function 'last non empty' for Measures in the modell pro designer? I want to show the last filled amount for the month.…
- 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…
-
Possible to use publication outputs an input to model?
Hi A Publish can only publish files to email and internal, not a shared folder as far as I'm aware. I'm in a situation where I'm using a publication to extract a lot of data,…
- Answered
-
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,…
-
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…
Welcome to the Pyramid User Community
Pyramid User Community