Database Reference
In-Depth Information
VQ4. DW versions containing a
dimension that has a given structure
its direct upper level, regardless other levels that
may exist as lower levels of Products and upper
levels of VAT_Categories .
The general syntax of the query is shown below.
The structure of the dimension of interest is speci-
fied by means of clause OF [EXACT [UP|DOWN]]
STRUCTURE. The structure of a dimension is
expressed by means of level's hierarchy. The
optional EXACT keyword allows to express that
the structure of a dimension has to be exactly as
specified in the query. The optional EXACT UP
keywords allow to express that the structure of
a dimension has to match the specified structure
from a top level towards lower levels. The optional
EXACT DOWN keywords allow to express that
the structure of a dimension has to match the
specified structure from a bottom level towards
upper levels.
SHOW VERSIONS HAVING
DIMENSION Product
OF STRUCTURE (Products ->
VAT_Categories)
IN VERSION 'R_April'
VERSION FROM '01-04-2004'
TO '30-05-2004'
If we modify the above example query so
that the OF EXACT DOWN STRUCTURE
(Products→VAT_Categories) clause is included
in the query, then the query will search for di-
mensions Product (and their equivalents) whose
structure matches the specified hierarchy from the
bottom. In this case, all dimensions of structure
Products VAT_Categories →...→... would be
taken into consideration. The usage of the OF
EXACT UP STRUCTURE (Products→VAT_Cat-
egories) clause will result in searching for dimen-
sions Product (and their equivalents in other DW
versions) whose structure matches the specified
hierarchy from the top. In this case, all dimensions
of structure ...→...→ Products VAT_Categories
will be taken into consideration.
SHOW VERSIONS HAVING
DIMENSION dimension_name
OF [EXACT [UP|DOWN]] STRUCTURE
(level_name -> level_name ... ->
level_name)
IN VERSION version_name
[VERSION FROM start_date
[TO end_date]]
For example, in the below query the search
criteria are defined for base version R_April
(as specified in IN VERSION 'R_April'). In
this version, dimension Product is composed of
hierarchically connected two levels, such that
Products VAT_Categories , as specified in the
OF STRUCTURE clause. Notice that dimension
name and level names could change in some DW
versions. In this case, all dimensions equivalent to
Product and all levels equivalent to Products and
VAT_Categories will also be taken into consider-
ation. Notice also that the EXACT keyword was
omitted in the query.As a consequence, all Product
dimensions (and their equivalents) are taken into
consideration whose hierarchies include level
Products as a lower level and VAT_Categories as
VQ5. DW versions containing
a dimension instance that
has a given structure
The general syntax of the query is shown below.
The structure of the dimension instance of inter-
est is specified by means of the OF [EXACT
[UP|DOWN]] STRUCTURE clause, similarly as
in the query of type VQ4 . A dimension instance
is specified by means of attribute values belong-
ing to levels.
SHOW VERSIONS HAVING
DIMENSION dimension_name
INSTANCE OF [EXACT [UP|DOWN]]
Search WWH ::




Custom Search