Drillthrough with multiple tables RRS feed

  • Question

  • Hi,

    I'm having a bit of trouble with drillthrough, hope someone can help.

    When the user drills through, I would like them to retrieve some records that are located in another table - not in the fact table.

    E.g. if they drill down on one record of with a data value of 100, they should see 4 related source records that reside in another table.

    At the moment, when the user drills down, they always see the entire contents of the other table. Of course it should only show you the records that apply to the value you're drilling on.

    I've tried several things, setting up a relationship in the cube schema, and setting up a relationship in SQL Server between the two tables. Either way I always get the whole table back.

    Can anyone help


    Wednesday, August 10, 2005 6:37 AM