Oracle Error ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

Oracle Error Message

ORA-36800: (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP

Reason for the Error

The OLAP table function given used more than one LOOP statement.

Solution

It is currently impossible to specify more than one LOOP composite, either remove one of the statements (and loop densely over relevant dimensions), or create a new composite that encompasses both loops and have a single loop statement refer to that.