http://b-kaempgen.de/index.php?action=history&feed=atom&title=NON_EMPTY_Clause_in_MDXNON EMPTY Clause in MDX - Revision history2026-05-25T06:47:23ZRevision history for this page on the wikiMediaWiki 1.22.2http://b-kaempgen.de/index.php?title=NON_EMPTY_Clause_in_MDX&diff=573&oldid=prevBenedikt Kämpgen: 1 revision: From LD-Cubes2023-01-04T13:24:16Z<p>1 revision: From LD-Cubes</p>
<table class='diff diff-contentalign-left'>
<tr style='vertical-align: top;'>
<td colspan='1' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='1' style="background-color: white; color:black; text-align: center;">Revision as of 13:24, 4 January 2023</td>
</tr><tr><td colspan='2' style='text-align: center;'><div class="mw-diff-empty">(No difference)</div>
</td></tr></table>Benedikt Kämpgenhttp://b-kaempgen.de/index.php?title=NON_EMPTY_Clause_in_MDX&diff=572&oldid=prevBenedikt Kämpgen at 21:58, 26 September 20132013-09-26T21:58:04Z<p></p>
<p><b>New page</b></p><div>* Problem: we have a large query that we would like to properly execute with LDCX:<br />
<br />
<nowiki><br />
NON EMPTY SELECT CrossJoin({Members([httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23subject])},{Members([httpXXX3AXXX2FXXX2FedgarwrapYYYontologycentralYYYcomXXX2FvocabXXX2FedgarXXX23segment])}) ON COLUMNS, NON EMPTY {[httpXXX3AXXX2FXXX2FpurlYYYorgXXX2FlinkedZZZdataXXX2FsdmxXXX2F2009XXX2FmeasureXXX23obsValueAGGFUNCCOUNT]} ON ROWS FROM [httpXXX3AXXX2FXXX2Folap4ldYYYgooglecodeYYYcomXXX2FgitXXX2FOLAP4LDZZZtrunkXXX2FtestsXXX2FedgarwrapXXX2F0001193125ZZZ10ZZZ230379YYYrdfXXX23ds]<br />
</nowiki><br />
<br />
* When executed using [[Example_QB_Datasets_QueryTest.java]], apparently, in result, most values are "".<br />
* First, we guessed, NonEmpty is wrong<br />
<br />
<pre><br />
Accounts payable current | | 0000909832 2009-08-30 | |<br />
| | | | 0000909832 2010-08-29 | |<br />
| | Accrued insurance current and noncurrent | | 0000909832 2009-08-30 | |<br />
| | | | 0000909832 2010-08-29 | |<br />
| | Accumulated depreciation depletion and amortization property plant and equipment | | 0000909832 2009-08-30 | |<br />
| | | | 0000909832 2010-08-29 | |<br />
| | Accumulated other comprehensive income loss available for sale securities adjustment net of tax | | 0000909832 2009-08-30 | |<br />
| | | | 0000909832 2010-08-29 | |<br />
| | Accumulated other comprehensive income loss foreign currency translation adjustment net of tax | | 0000909832 2009-08-30 | 1.0 |<br />
<br />
</pre><br />
<br />
* We made an experiment using [[LD_Cubes_Explorer_XmlaTest.java]], asking the same query.<br />
* xmlaserver and olap4ld return a proper result with all the values<br />
* However, the result seems too large than to be parsed properly<br />
* It seems, only the combination of NON EMPTY columns and rows do work currently.<br />
* As a result, for now, we only call NON EMPTY mdx queries in LDCX.</div>Benedikt Kämpgen