dbTalk Databases Forums  

Urgent: DISPLAY_INFO problem When query using OLE DB for OLAP

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Urgent: DISPLAY_INFO problem When query using OLE DB for OLAP in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Elvis Tang
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.