-
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…
-
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,…
-
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:…
-
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
-
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.…
-
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
-
Troubleshoot a failure when trying to creating a large IMDB model
When creating a new model to an "IMDB" data source, and the model looks like it is created, but it cannot be queried in Discover (the Green app) (An error is shown).…
-
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,…
-
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
-
Adding IMDB Server After Install
If you install the new Pyramid 2018 release without the new in-memory engine and then later want to add it, what should you use for the settings to add it as a data source?…
- Answered
-
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
Search for answers here or ask a question