-
Learning Live: Custom Columns
About this Video: In this video we give you overview about our new feature in Discover: Custom Columns. From the inital problem that is solved with them,…
-
Creating a dynamic parameter for a date range
Hi Everyone, I am trying to figure out a solution for the following issue. We have a contract with a start date and and a end date dimension. We want to select the active contracts within a year.…
- Answered
-
HR Cube - Absenteism hours - Formulate
PYRAMID Hello could someone help me on this one ? I have a HR table, in which I have 3 columns : Absenteeism days Contract hours Calculation of absenteeism hours=absenteeism days*contract hours…
- Answered
-
Learning Live: Introduction to Parameters
About this Video: This video we give you an introduction to Parameters and their use in the Pyramid Platform. How to build Discovers and add Parameters via Formulate to improve the report usability…
-
Learning Live: Formulate - 5 common business calculations
About this Video: This video we cover how to use the Formulate Module to complete five simple common business calculations. Each Example is completed with a live demo Content:…
-
Learning Live: PQL Masterclass Vol 2
About this Video: This video is the second of two sessions that cover the Pyramid Query Language (short PQL) in detail. With PQL you have additional possibilities to influence the results of your…
-
Learning Live: PQL Masterclass Vol 1
About this Video: This video is the first of two sessions that cover the Pyramid Query Language (short PQL) in detail. With PQL you have additional possibilities to influence the results of your…
-
Adding an empty measure column to a Discovery
Adding columns is basically done by creating and selecting Calculated members/measures into the Columns selection area. In this case, the requirement is to add an empty column to discovery,…
-
Why are my formulas not showing up
I have a handful of formulas that execute successfully in a Public Content folder. However, in Discover, only 2 of them show up Even if it is a blank discover panel.…
- Answered
-
Learning Live: Time Series Capabilities
About this Video: In this video we give you an overview on how to use the time series capabilities in Pyramid Analytics. You will learn how to build comparisons against previous periods.…
-
Tips & Tricks Vol 3/21 - Discover - Formulate - Present - Publish
Sneak: Add and show Top 10 filter + MiniMap to navigate grids + List of all objects + Custom Visuals Marketplace Tips & Tricks created by the Pyramid Customer Success Team The Tips&Tricks Series is…
-
Learning Live: Iterative Logic to Solve Complex Questions
About this Video: In this video we give you an overview about how you can work with iterative logical concepts in Formulate. Content: Lets check out this session,…
-
Percentage points change
Hi We are looking at a solution to create point percentage change column. In the given example we would like to create a measure that can be calculated on percentages,…
- Answered
-
Learning Live: Getting Started with Formulate
About this Video: In this video we give you an overview about the Formulate Module. Content: Lets dive in to Formulate, this video will cover the following topics.…
-
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
-
How can I convert date hierarchy into specific format?
Hi together, I need a graph with a dynamic changing x-axis (last 12 months) with dates in the format “MM-YYYY”. I am using a date hierarchy to get the dynamic part working.…
- Answered
-
Change Value on horizontal axis based on variable value selected
I am trying to change dimension in horizontal axis of my graph based on the filter selected. For example, In graph I would like to change value in horizontal axis to created date year, quarter,…
- Answered
-
Is there any way to count filtered rows in formulate?
Hi together, Is there any way to count filtered rows in formulate? SID Status 1 True 2 False 3 True 4 True I need to count all rows and then just rows which are true,…
- Answered
-
Formulate: Comine Standard List with a Measure
Hi guys, I'm not sure if I'm just "standing on the tube" or if my idea can't be realized, so I hope for your support: In formulate, I want to combine the function of a "standard list" with a measure:…
- Answered
-
Rank function
Hi Everyone, I am trying to use the rank function in Pyramid (similar to rank function in excel) to rank customers with highest revenue to lowest. The environment used is MS OLAP.…
- 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
Search for answers here or ask a question