Today I had a Microstrategy reporting problem: on my report there are two metrics, one is total number of incidents and attribute month; the other is total amount of payments received.They come from two different tables and have no relationship
Microstrategy derived metrics
I’ve been using Microstrategy for more than a year by now, never used derived metric before until recently discovered the beauty of derived metric. Derived metric, a Microstrategy’s term, I’d rather call it report function. Basically it’s a function that
Microstrategy movingsum
Have been using Microstrategy 9 for a while, had a moving sum problem recently. The customer basically needs moving sum for the past 12 months for each state/branch. Of course the month is based on accounting period, i.e. 1 May