-
Sorting on Multiple Columns in Model
Hello Community, I have a use case where I need to sort a data set first on column A and then, retaining this order, on column B. From what I gathered, the Sort node allows only one column at a time.…
- 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
-
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 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…
-
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
-
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 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,…
-
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
-
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,…
-
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.…
-
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…
-
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.…
-
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 -…
-
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 create a Matrix Table Layout. From Tips & Tricks September 22
Sneak: How to create a Matrix Table Layout 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 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.…
-
Running Oracle Procedures inside a Model
Hi, Has anyone been able to run an oracle procedure within a data model? I have a procedure that will return a populated cursor and another procedure which will not return any result sets but will…
- Answered
Search for answers here or ask a question