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.

See INITSLICERS.

VALIDATESLICERS checks XML, created with the INITSLICERS function, against a specified cube and checks whether the hierarchies listed in the XML exist. If they do not exist, VALIDATESLICERS, uses the corresponding dimension. If the dimension does not exist, VALIDATESLICERS deletes the entire row. If an element does not exist, the default element is used.

Syntax

=VALIDATESLICERS("OlapMetaDataUniqueName","Slicer XML")