-
How to build Dynamic Today, current month, Previous Month etc. in Pyramid Formulate
How to build Dynamic Today, current month, Previous Month etc. in Formulate Get Dynamic Dates Using Formulate Wizard. To make the access on the latest information,…
-
NEW: Explore Pyramid - monthly Data Challenge Environment
Trickle your Brain and keep Learning Right before the Weekend, we are happy to give you the exclusive chance to start playing with the brand new Explore Pyramid Environment and begin your first…
-
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
Welcome to the Pyramid User Community
Pyramid User Community