I'm new to Google Groups so, hi everyone. I have the following
question. I have an olap cube and i need to set it up for
drillthrough. I have no problems with that, except when i add a new
table at the Drillthrough dialog. When i do so, i get duplicate rows.
It seems like Analysis Services is not able to link the table i add to
the fact table. The thing is, that this table is already part of the
cube, because it is a dimension table, (and there is a link between
the dimension and the fact table also). I read that the tables listed
at the Drillthrough dialog are the ones which are part of the
partition dimension collection. So, it seems i have two different ways
to solve this. I can add this dimension table to the partitions or
force this link somehow. The fact is that i haven't managed to do
neither of these. Any ideas????