-
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
-
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
-
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,…
-
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
-
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
-
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,…
-
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
-
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
-
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
-
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
-
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,…
-
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)…
-
Reading HTML Tables from Web Pages using Pyramid and the Python Source Connector
Introduction You’re working on an analytic project and have all the data you need, minus some crucial data that you suspect may be available on the internet.…
-
Is there a way to change date formats in a model?
We are located in the US and would like to change the date formats to a format that our users are used to, such as mm/dd/yyyy. I don't see a way in the model to set the date format displayed.…
- Answered
-
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
-
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
-
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
-
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…
-
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…
-
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: 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.…
Search for answers here or ask a question