MS SQL Server OLAP

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Adomd.net

Deep blue via SQLMonster.com

2005-09-27, 11:24 am

Hi ,
I am converting XML from adomd cellset using ExecuteXmlReader(). But when the
cell is empty, the ExecuteXmlReader() ignores the empty node like in below
example. Is it possible to retain those empty nodes? In the below example you
can clearly see cellordinal 1 is missing . Can anyone help??

Thanks

<Cell CellOrdinal="0">
<Value xsi:type="xsd:string">2004-09-13T00:00:00</Value>
<FmtValue>13/09/2004</FmtValue>
</Cell>

<Cell CellOrdinal="2">
<Value xsi:type="xsd:double">95</Value>
<FmtValue>95.0</FmtValue>
</Cell>

Sponsored Links