| Original Message |
Posted Aug 11, 2012 9:03 AM
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
|
|
|