Adaptive Metrics

Hello there! Today let's talk about how to create different aggregation formula for each fact table used in a fact in Microstrategy. Let's say that we need to create a SUM(value) for Fact A and a COUNT(value) for Fact B. When we get data from Fact A, Microstrategy must SUM, when in Fact B, Microstrategy must COUNT. …

Creating filter for an incomplete date field using pass-through functions

Hello there! Today let's talk about how to create a dynamic filter for an incomplete date field in a report using DB functions in MicroStrategy. DB functions or pass-through functions are MicroStrategy functions that allows you to customize the query that MicroStrategy creates for the reports. Those are very powerful functions. With them, you can write specific …