DLOOKUP
Syntax
<dlookup-expression> := 'DLOOKUP(' <Key> { ',' <Key> } ')'
Since
2.1.2
Return-type
Key
Description
This function evaluates, by immediately querying the cubes, for which keys of a dimension or dimension-level (defined by the first argument) a fact (defined by the second argument) is available (not NULL). When querying the cubes, the current filter will be considered. The DLOOKUP-function is very important whenever you build reports showing values for sparse filled cubes.
The DLOOKUP-function is very similar to the function LOOKUP but simpler and faster:
- DLOOKUP only can lookup whole dimensions or dimension-levels. Therefore, only dimension-names or level-names may be passed as first arguments. Also, you can only query for a single dimension with one call.
- DLOOKUP does not consider formulas, so it will only return keys which can be directly loaded out of cubes.
If the ordinary LOOKUP function is able to use this faster function instead, it will forward the operation to this function.
If any of the arguments is NULL, the function returns NULL.
Examples
DLOOKUP( Article, Fact:Amount )
Returns all articles with a Amount stored in any cube for the current selection
DLOOKUP( Article::Group, Fact:Amount )
Returns all article-groups with a Amount stored in any cube for the current selection
DLOOKUP( Article::Group + Article::Category, Fact:Amount )
Returns all article-groups and -categories with a Amount stored in any cube
DLOOKUP( Article::Group, Fact:Amount + PREV( Time ) )
Returns all article-groups with a Amount stored in any cube for the previous period
DLOOKUP( NULL, NULL )
= NULL
See also
LOOKUP, SPLIT
