When I test a Measures Dimension Created from a Query Subject I get the following error:
This query contains an error and cannot be executed
It is recommended that you review the Query feedback int he "Query Information" tab
RQP-DEF-0177 An error Occurred while performing operation '
'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation 'sqlUpenResult' is inactive.
UDA-SQL-0104 A general exception has occurwed during the operation 'open result'
ERROR: 1139: Frame pinned record block limit exceeded
The underlying table is HUGE 13 to 16 tera-bytes. If I filter the underlying Qsubject and create a smaller subset, the the test of the dimension will actually run. However I want to know what this means for my application that I am trying to put together for the huge table.
Thanks