VALIDATESLICERS

In database-independent reports, the values of the slice dimensions are typically stored in an XML variable. The VALIDATESLICERS function can be used to analyze and adjust the XML created by the INITSLICERS function.

VALIDATESLICERS checks XML against a specified cube and checks whether the hierarchies listed in the XML exist and the elements are accessible. If a hierarchy does not exist, VALIDATESLICERS, uses the default hierarchy of the corresponding dimension. If neither the dimension or hierarchy exists, VALIDATESLICERS deletes the entire row. If an element does not exist, the default element is used.

Syntax

=VALIDATESLICERS("cube_Olap_metadata_uniqueName","slicers_XML")

Example

=VALIDATESLICERS("[Repository].[BestPracticesOLAP].[Analysis],reportvariables.rv_slicer.text)