-
Extracting a JSON Array in Data Flow
Our source tables may sometimes contain columns containing JSON arrays. in such cases we would want to expand the array and then break the JSON into a number of different columns.…
-
Advanced Messaging options in Pyramid Analytics
he Master Flow allows you to send emails and SMS messages, As we've seen before with sending emails upon failures. You would probably want to send emails that are informative,…
-
Send a Message on Model Failure
This short guide will show you how to use Messaging Components in Pyramid Analytics Model Definitions Master Flow, to send messages upon execution failures.…
-
Direct Query vs Ingestion: When to Use Each
Choosing the right data connection approach for your Pyramid model What's the Difference? Direct Query queries data at its source in real time. Every report interaction sends a query to the source…
-
"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.…
-
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.…
-
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,…
-
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)…
-
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 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.…
-
How to manage Automatic Column Handling. From Tips & Tricks September 22
Sneak: How to manage Automatic Column Handling How to manage Automatic Column Handling Automatic Column Handling allows users to update chosen tables in the semantic model each time the model is…
-
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…
-
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…
-
How to run a direct query. From Tips & Tricks May 22
Sneak: How to run a Direct Query 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 advanced use…
-
How to add a “Distinct Count” measure against a “Dimension” key in “Model”. From Tips & Tricks - Vol 2/21
Sneak: Distinct Count 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 advanced use cases.…
-
Tips & Tricks February 23 - Model Mapping
Sneak: How to create interactions between content items that are querying different data models. Tips & Tricks created by the Pyramid Customer Success Team The Tips&Tricks Series is produced by the…
-
Tips & Tricks September 22 - Model - Discover - Present
Sneak: Matrix Table Layout + Automatic Column Handling Tricks created by the Pyramid Customer Success Team The Tips&Tricks Series is produced by the Customer Success Team.…
-
Tips & Tricks June 2022 - Model - CMS
Sneak: Parent Child Hierarchies - Schedule and Subcription Manager Tricks created by the Pyramid Customer Success Team The Tips&Tricks Series is produced by the Customer Success Team.…
-
Tips & Tricks May 22 - Model - Discover
Sneak: Direct Query + Creating Custom Tables + Initial Selection for Sliders Tips & Tricks created by the Pyramid Customer Success Team The Tips&Tricks Series is produced by the Customer Success…
-
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's and Knowledge Base Articles for Model