AVAILABLEOFFLINE
Syntax
<availableoffline-expression> := 'AVAILABLEOFFLINE(' [ <Key> { ',' <Key> } ] ')'
Since
2.5
Return-type
Boolean
Description
The AVAILABLEOFFLINE function checks, if the fact passed as argument (or which is currentley selected in the filter) is available in any offline cube for the currentley selected dimension-keys (which also can be overridden by passing keys as arguments).
This function can be used to avoid error messages when using offline data, e.g. you can use it to display more information in a report inside the instantOLAP Player if the computer is connected to the database and to hide special areas of a query whenever it is disconnected.
Examples
AVAILABLEOFFLINE( Amount )
Returns TRUE if the "Amount" Fact for the currentley selected filter is available in any offline cube.
AVAILABLEOFFLINE( Amount, Product:1 )
Same check but for a special product.
