-
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
-
Data Flow Output Question
I am trying to create a dataflow that starts with 2 different Pyramid content file sources (Tables I created within Pyramid already). Since each is referencing a different database,…
- Answered
-
model development
Hello, I'm developing a model from an oracle connection (two tables). I'm trying to append one of the tables via union however when I do I only get a measure from one table and not the other.…
- Answered
-
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
-
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
-
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
-
Data Model - summarize column, unique row
Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…
- Answered
-
Case Statement in model
Hello! Wondering if someone could help me with a case statement that i have been unsuccessful with and have tried it many ways... Any help would be greatly appreciated.…
- Answered
-
Local storage of "In Memory" DB
Assuming i want to do a data model and i want to story it locally for speed of access (a bit like Tableau allows you to store the data encapsulated in the report),…
- Answered
-
Bad design has left me with database fields that can be populated with comma separated list
Assume my database has the following columns ID DESCRIPTION USERS LOCATIONS I know that ID and DESCRIPTION are always relevant. USERS and LOCATIONS can contain 0, 1,…
- Answered
-
Option to change the data format to the Europan format: 1.234,56
Hello, it would be helpful to be able to change the data format from 1,234.56 to 1.234,56 as this format is used in Europe. This could either happen in the profile of each user,…
- In review
-
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
-
Find Difference between two dates
Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?
- Answered
-
Configure Model's Targets / Sources with a variable
Hi everyone, I'm wondering if there is any way to configure targets / sources with a variable or a parameters that contains a connection string ? That will help us to not update connections in every…
- Answered
-
No proxy account was set for user (2020.10)
When content is from an MS OLAP /Tabular data source, after upgrading to Pyramid 2020.10 RTM the following message is shown when opening some content for the master user:…
-
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,…
-
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.…
-
how to create nest folder view in configuration section
Hi, May i ask your help how to achieve nested folder structure in Pyramid model development from the snapshot provided the second screenshot is taken as reference from different BI application.…
- Answered
-
Creating a Date Time intervals in Data modeling tool
When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00). To do this,…
-
change start of week in Data Flow (Advanced Time Intelligence)
Hi everyone, I managed to successfully use the Time Intelligence widget to change the start of our fiscal Year and training week, as advised by @Avi Perez in the Product Ideas forum.…
- Answered
-
Data model Hierarchy - Tree slicer
Hi everyone, I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure. The problem I have is that it works well with double click and drill down,…
- Answered
-
When trying to use an R script from the Market Place an error occurs
When trying to use a script from the Market Place that uses one of R packages e.g the “Sentiment analysis” (uses stringr package) the following error occurs: "scripting error:Error:…
-
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
-
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.…
-
Seamless page loading
First of all, sorry for the bad terminology used here. I have no clues on what the thing I try to explain is called. Let me try: I recently see a lot of nice websites being build with a "seamless…
- Answered
Welcome to the Pyramid User Community
Pyramid User Community