| MEmerson 2005-09-20, 8:24 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."
|