data model

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

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

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.…

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

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

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

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

Ordering the Months

Currently when I am displaying the MonthName field it defaults to showing me the names in alphabetical order. How do I fix this to show me the regular order (January, February, March, April, May,…

• Answered

Pyramid and Elasticsearch

Hi Everyone, Is there a way to connect pyramid to Elasticsearch?

• Answered

Filter a second dimension based on the value of a first dimension in Discover

Contents Hi Community, Please bare with me whilst I try to explain what I am trying to achieve. This is a very slimmed down example, but suffice to say,…

• Answered

In a Data Model, I want to use one column as the description for another

I have a direct SQL data model. There is a URL(dashboardpageurl) column and a description (dashboardpage) of that URL in another column as shown: I want to use the description column in place of the…

• Answered

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

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