-
Learning Live: Getting Started with Model
About this Video: In this video we give you an overview about the Model Module. Content: Lets dive into Model, this video will cover the following topics:…
-
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
-
Learning Live: Analytics Pipeline
About this Video: In this video we give you details how to build an Analytics Pipeline in the Pyramid Platform. We will cover all stages and possibilities with live examples.…
-
Creating an IMDB Time column in the Model designer
In the current version of Pyramid (2020.10), the Time type column is not supported when creating an IMDB model. As a result, it will appear in a Discovery report but it will not be possible to…
-
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,…
-
Learning Live: Working with SAP Data
About this Video: In this video we give you an overview how you can easily use SAP Data in the Pyramid Platform. Content: Lets dive in to this topic, this video will cover the following topics:…
-
Issue when running a model that has JSON nodes that connect to HTTPS data source
ISSUE: When running an ETL that contains references to an HTTPS site the following error may occur: "Failed to read file list: SSLException: No PSK available.…
-
Processing Multiple Models vs. One Big Model?
I use a number of Models, each with a specific job to do. A few models pull data into my warehouse from various sources, and a few models abstract different cuts of the raw data suitable for various…
- Answered
-
Using Python or R to pivot excel workbook
We have a workbook which has a list of names, and then a column with their performance each week i.e. John Smith, 1,4,10,8,4,6, Finance, Analyst with column headers being name, week 1, week 2,…
- 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.…
-
Learning Live: Parent Child Hierarchies
About this Video: In this video we give you an overview on Parent Child Hierarchies and how they can be useful especially in Fiancial Reporting. Content: Lets check out this session,…
-
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: Master Flows - messaging, events and conditional flows
About this Video: In this session, we will examine the features of the Master Flow that allow us to control the order of operations, notify the appropriate personnel of the status and kick off…
-
Learning Live: Forecasting Basics - Creating statistical forecast calculation
About this Video: In this video we give you an overview about about Forecasting Theory, various models and how to embed Forecasting into your Pyramid Reports.…
-
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.…
-
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…
-
Learning Live: Self-Service Analytics - Controlling Access
About this Video: In this video we showcase how users can Dice, Add, Swap but also how we can control this access for different types of users via the Data Model.…
-
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 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…
-
Learning Live: Smart Capabilities
About this Video: In this video we give you an overview about the Smart Tool available to support you in Model, Discovery, Present, Insight and our Chat Bot.…
-
Learning Live: Data Catalog
About this Video: In this video we give you details about the Data Catalog Capabilities in the Pyramid Platform. We will show you how to use these Ad Hoc and for external Applications.…
-
GA input call/record limits
Hi all, do you know what the limits are for how many records/days/etc. can be pulled in from Google Analytics at a time? We are only receiving a limited part of the data when pulling from longer…
- Answered
-
Learning Live: In-Place Analytics
About this Video: In this video we give you an overview about In-Place Analytics in Pyramid. How it developed, what it means for the end users and how it looks in the Pyramid Platform.…
-
Learning Live: Simplify the user experience
About this Video: In this video we give you an insight how to simplify the user experience. Content: Lets dive into this topic, the video will cover the the following Topics:…