Questions & Answers Category

Let's talk about Dimensions and Measures

Dimensions and measures are the two central building blocks in multidimensional reporting. In Pyramid Analytics, they are mainly dealt with in the “Model” and “Discover” modules.…

Filtering on 2 dimensions and counts

Hi community, I am struggling to do something that I think should be possible so asking for help here I have a star schema modelled in snowflake and a Direct Query model in Pyramid consisting of a…

• Answered

How to determine DataFlow NodeID?

Good day everyone, I try to automate the change of data models via the Pyramid API. But I can't find a function to get the Node ID of an existing model.…

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

Reordering Columns Once Model Has Processed

So in pyramid model there is a column operation that allows me to reorder the columns. Still, once I process the model, the order of the columns that is displayed is not what I specified in the model.…

• 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

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

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

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

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

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

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

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

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

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