Behind the magic: Employee of the quarter (Q3)

Introduction This Post Explains how to create a new column that will calculate the week number of a Quarter. Business Case In many cases Business Analyst would like to track trends over time aggr...

You might want to compare MoM on a daily average, which means to take the daily average of the current month (even if the month isn’t over yet), and compare it with the previous month’s daily averag...

Step-by-Step Guide:  There are two main approaches to implementing financial quarter-specific drilldowns: Option 1: Enable Custom Fiscal Year (ElastiCube or Environment Level) Step 1: Set Fisca...