Anyone have experience with IEssOpMdxQuery.setDataless() in the JAPI? It appears to not be as dataless as I would expect. Specifically in the case of an ASO cube.

In the meantime, if you need to suppress data retrievals, setting one axis to an empty set

SELECT { [Full Year].Children } ON COLUMNS, { } ON ROWS FROM your.cube

or forcing data to 0 with a custom calc

WITH MEMBER Measures.NoData AS '0' SELECT { [Full Year].Children } ON COLUMNS FROM your.cube WHERE (Measures.NoData)

seem your best, and most SSAS-like, options.

Hi Zoltan,

On my 11.1.2.1.102 laptop, I get no data cells when setDataless() is set to true:


String mdx = "SELECT {actual} ON COLUMNS, \n" +
"NON EMPTY CrossJoin(Colas.CHILDREN, West.Children) DIMENSION PROPERTIES Market.GEN_NUMBER, [Product].[GEN_NUMBER], [Product].[LEVEL_NUMBER], PRODUCT.MEMBER_ALIAS, [Product].[Comments] on ROWS FROM SAMPLE.BASIC";

IEssCubeView cv = cube.openCubeView("default");

IEssOpMdxQuery op = cv.createIEssOpMdxQuery();

op.setQuery(false, false, mdx, true, IEssOpMdxQuery.EEssMemberIdentifierType.NAME);

op.setXMLAMode(false);

op.setDataless(true);

cv.performOperation(op);

IEssMdDataSet mddata = cv.getMdDataSet();

System.out.println(mddata.getCellCount()); // prints 0


Are you seeing a version-specific thing?

Tim

Tim Tow
Oracle ACE Director
Applied OLAP, Inc

>>Are you seeing a version-specific thing?

What I'm seeing is that at a customer site, with an ASO Cube, the script

SELECT { Descendants( [Year] ) } ON COLUMNS FROM ASOCube.ASOCube

Essbase throws an error for MAXFORMULACACHESIZE which is presumably legitimate but seems to imply Essbase is going to attempt to calculate something even if Essbase isn't going to stream back the results. Specifying an empty row set (e.g. { } on rows) or a calculated value (e.g. WITH MEMBER) seems to bypass the error.

It seems like Dataless(true) isn't returning data, which is nice for network transmission times, but I'd think it would suppress calculating it as well (like a Navigate w/o Data operation).