Sunday, April 21, 2013

This will return all the columns which are not null
for all the tuples of rows axis:

SELECT NON EMPTY { } ON COLUMNS , { } ON ROWS FROM [Cube];This will return all the rows which are not null for all the tuples of column axis:SELECT { } ON COLUMNS , NON EMPTY{ } ON ROWS FROM [Cube];Non Empty: