Model

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

Workflow Versioning

Hello, Can I please be pointed to an article that goes into a little more depth on 'Save as New Version' in the model workflow? I'm trying to find more information on how the different versions of…

• 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

Order Dimension Tables

Is there a way to order the tables in Pyramid? I want them in a specific order not alphabetical order.

• Answered

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

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

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

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

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

Hidden Tables Delete Relationships. Is this a bug or a feature?

Hello PA Team, I’ve found that hiding tables in the data model causes their relationships to disappear. This may break existing content (reports, dashboards) that depend on those connections.…

• Answered

Using Regular Expressions to replace

Hello, Is there a way to use regular expressions to search and replace?

• 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

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

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