A common requirement of dashboards, scorecards, and mobile BI applications is providing the ability to slice and dice them by time periods: Week to Date (WTD), Month to Date (MTD), Quarter to Date (QTD), and Year to Date (YTD). One way to achieve this requirement in MicroStrategy is by creating a Report Services Document with … Read More
MSTR Object Development
MicroStrategy Metric With a Constant Text or Number Value
A neat solution I discovered when I first began working with MicroStrategy was how to create a metric with a fixed value. I am a big fan of this solution because the fixed metric value is calculated by the MicroStrategy Analytical Engine after the SQL query is executed against the data warehouse. Compared to other … Read More
Dummy MicroStrategy Attribute With a Text or Number Value
In this article, I will be providing detailed instructions on how to create dummy MicroStrategy attributes with either a fixed text or number value. In some of my past projects, I have used these attributes as placeholders in Report Services Documents to create spacing in grids, among other data visualization hacks where a fixed attribute … Read More