Wednesday, August 21, 2013

Level Metric Formulas

When creating a level metric on the fly (Derived metric inside a report), there is some syntax you need to know for the different grouping and filtering options.
The table bellow shows the different options:




Symbol

Definition

Metric Level target
~ Report Level
[Attribute Name] Target
Symbols placed before the target
No symbol Grouping = Standard
! Grouping = None
<| Grouping = Beginning fact
>| Grouping = Ending fact
< Grouping = Beginning lookup
> Grouping = Ending lookup
Symbols placed after the target
+ Filtering = Standard
* Filtering = Absolute
% Filtering = Ignore
No symbol Filtering = None


The above means that, if you need to create a dynamic level metric, it would look like this:
Sum([Metric]) {~}
or
Sum([Metric]) {[Year]}
or
Sum([Metric]) {![Year]*}

I got these definitions from Raja Vel on his blog: http://microstrategytechbuzz.blogspot.com/2013/04/tip-metric-level-property-symbols.html

2 comments:

  1. All slots 카지노사이트 are primarily based on one key thought – spin the reels and hope they land on a certain mixture. This makes understanding slot games extremely easy for a newbie, as when you perceive how one performs out, you know the fundamentals behind all of them. The code beneath simulates your net achieve should you guess $1 on purple on 400 completely different spins of the roulette wheel. The app from Wild Casino is great for a number of|numerous|a selection of} completely different devices.

    ReplyDelete