Hi,

Drill through returns more duplicate records for a cell having a value 1
for a single record and found that drill through has tables which are
not required.

Is there anyway to remove tables from drillthrough.

Thanks
John Jayaseelan


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You determine what should be included in drill through in cube
editor\tools\drill through options

If your drill returns duplicate records it could be because you have used
optimize schema - I tried that once and the result was
duplicate records in drill through.

So now I don't optimize..

If you want to "turn" back optimize schema you need to select all dimensions
in the cube editor and where the member key columns points to
the fact table you set it back to point to the dimension table.

--Michael

"John Jayaseelan" <john.jayaseelan (AT) caravan-club (DOT) co.uk> skrev i en meddelelse
news:OWDGzObaEHA.2016 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Michael,

Thanks for the reply.

How to remove the tables already in the drilltrhough options?

Thank you





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!