-
Origin date format isn't recognized by Pyramid as a DATE
The system I use generates reports where the date is formatted as a string of numbers and I cannot figure out how to get model to see it as a date. I assume somewhere there is a solution where I can…
- Answered
-
Scheduled maintenance down time
Afternoon, I've looked but have not found any means to have pyramid shut down access for scheduled maintenance. Main requirement is to prevent JDBC calls interrupting Netezza service procedures.…
- Answered
-
Reuse Data Models to Build other data models.
PROBLEM: Currently, we build data models that contain a set of tables (data model for products, data model for financial information); but these tables can have relationships between them too (EG:…
- Answered
-
IMDB Setup on a Kubernetes deployment
Hi there, wondering if there is any specific information about setting up the IMDB (in memory database) source server specifically in a kubernetes environment.…
- Answered
-
How to register an APP in Azure for OAuth connections to Snowflake or Azure Synapse in Pyramid.
1) Register an App in the Azure portal Required fields: Name: give the app a name Supported account types: choose the option that you require. Redirect URL:…
-
How to speed up Queries running against an AWS Aurora RDS MySQL database instance?
AWS RDS Aurora MySQL 5.7.12 Query Performance In a recent customer scenario we encountered some unexpected performance issues when connecting to a AWS RDS Aurora MySQL 5.7.12 as data source.…
-
Connecting with Anaplan
Hello! My finance team is interested in connecting Anaplan to Pyramid. Have you done that successfully and if so, what did you find that worked the best?
- Answered
-
PDF / Document files as a Data Source in Modeller
Hi Avi / Pyramid Dev team, Often, information useful for a Pyramid client is stored in PDF or other document formats - for example where the Pyramid client itself has many suppliers who do not…
- Answered
-
How to add a CData custom connector as a data source
A step-by-step guide on how to add a CData custom connector as a data source. Download the Java JDBC driver for the data source you want to connect to. (Click here for a complete list of the…
-
Twitter Source questions
We recently received a few questions regarding the Twitter data source. We thought to share the answers with you. What search options do we have with the Twitter source node in Model?…
- Answered
-
Is there any way to get notified when a scheduled Model Data Flow fails?
We are using a model which gets processed everyday. Is there any way in Pyramid to get notification if model processing failed for some reason? Current version of Pyramid we are using is Pyramid…
- Answered
-
Call Stored Procedure
How to call Stored Procedure from SQL Server Source with dynamic parameters values to Stored Procedure?
- Answered
-
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,…
-
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
-
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
Welcome to the Pyramid User Community
Pyramid User Community