Hi,

I have a cube where the drilldown is working correctly, that is until I want
to i've just added an additional table into the cube schema.

The cube contains a customer table and I've just added a new table into the
schema called special_circumstances. I have linked the two tables in the cube
schema and the data is a 1 to 1 relationship.

Now if i add the description field from the new table into the drilldown
fields instead of just one customer record I get 10 for each customer (there
are 10 records in the lookup table).

I have definately joined the tables in the schema but it doesn;t seem to
take much notice of this fact. Is there something that i'm doing wrong here,
or anyone have any ideas?

Thanks

Ian.

Hi Ian,

Maybe adding the join condition for this new table to the Drillthrough
Filter will fix this problem, like:

"table1".field1" = "table2"."field2"


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks Deepak, that worked spot on !!

"Deepak Puri" wrote: