data model

Find Difference between two dates

Hi All, We need to find difference between two date dimensions present in our model. Is it possible to do it using formulate?

• 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

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

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

Case Statement in model

Hello! Wondering if someone could help me with a case statement that i have been unsuccessful with and have tried it many ways... Any help would be greatly appreciated.…

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

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

Number Formatting in Discovery

Hi all, I have the attached discovery prepared from the attached data model. I am having trouble displaying the variance information as a percentage rather than a number format.…

• Answered

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

SQL Query in Model

Hello, I am trying to set up a SQL Query in a MODEL, but I do not understand which table name I should include into my SQL query. See both print screens attached. Sincerely Clément

• 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

Local storage of "In Memory" DB

Assuming i want to do a data model and i want to story it locally for speed of access (a bit like Tableau allows you to store the data encapsulated in the report),…

• 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

Data Model - summarize column, unique row

Hello, I am running into a problem when developing my data model. I have two rows of data: ID AMT CREDITS COUNT_REG UID1 24775 18.00 1.00 UID1 -1286 18.00 1.…

• 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