dbTalk Databases Forums  

Properties bug with parent-child dimensions

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


Discuss Properties bug with parent-child dimensions in the microsoft.public.sqlserver.olap forum.



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

Default Properties bug with parent-child dimensions - 09-20-2005 , 02:06 PM






There is a bug in ADOMD and ADO.NET whenever you query for properties of a
parent-child dimension. If you use any of the flattening methods like
AdomdDataReader.Fill or AdomdCommand.ExecuteReader with a query that requests
properties of a parent-child dimension like:

select {[Measures].[Org Salary]} on columns
{[Employees].members} properties [Employees].[Position Title] on rows
from [HR]

You do not get the properties returned in your result set. I have submitted
this with an example program to Microsoft, followed up on it regularly for a
couple of months and was finally told that they are not going to fix this
bug. The exact message was:

"Sorry for taken us such a long time to investigate this issue, thank you
for you patient. The developer finally had a chance to look into this issue
and had confirmed that this is a bug, meantime, there is no fix to this bug
because this is a risky area to fix that might cause instability in other
area in the current product."


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.