Hi there,

I have a AS2000 cube where I have drillthrough enabled. I have several
columns of the underlying tables selected. Now when I do the
drilltrough only 5 out of the selected show up in the query result.
All are from my facts table, however one column from the facts table
is also missing. I see no connection why certain colums are selected
and correctly returned and others are selected but don't show up in
the result.

I'm not sure if this is related to it I also get the "Data source
provider error. Statement could not be prepared;42000;The column
prefix 'dbo.mc_dimAPDRG' does not match with a table name or alias
name used in the query;42000'.

Some columns in the defined drillthrough are from the table
mc_dimAPDRG, so when I select this Table as a dimension this message
won't show up, but again part of the defined columsn won't show up in
the result.

best regards
andreas

Andreas Palm
HP Switzerland