Urgent: DISPLAY_INFO problem When query using OLE DB for OLAP -
01-08-2006
, 02:56 AM
In MSAS 2005:
I build a cube [Test_Cube], which includes [Account] and [Time]
dimensions. [Account]'s Usage is "Parent", so it will be taken as
Parent-Child Dimension.
[Account] has four levels, and [Account].[Parent].&[2] is leaf member
in second level, [Account].[Parent].&[4] is leaf member in the fouth
Level(deepest).
Wen we execute a MDX statement, such as "SELECT
{[Account].[Parent].&[2], [Account].[Parent].&[4]} ON ROWS,
{[Time].[TD].&[200502]} ON COLUMNS FROM [Test_Cube]"
and get row set by such
like"IMDDataset->GetAxisRowset(),IRowset->GetNextRows()"based on
OLE DB for OLAP . From the row set I get ZERO value for [DISPLAY_INFO]
property when browser [Account].[Parent].&[4], but 1000 when browser
[Account].[Parent].&[2]. It is ridiculous because
[Account].[Parent].&[2] is also leaf member without any children. It
makes me impossible to check if the member is leaf member or not.
In MSAS2000, it works well by [DISPLAY_INFO] property.
BIG appreciated if someone can give me some idea. |