BPC MS10.0 Drill through Help

[Former Member]

Hello Experts,

I have setup drill through to a database table and it works perfect for most of the cells for which it was setup. How ever for few cells when I click display table in Microsoft excel it does not bring any data (Only brings the drill through heading but not the data) but all the drill through setup cells works 100% perfect when I click display table in web browser option. Any one please help me resolve this issue.Your help is appreciated.

Thanks,

Ma.

[Former Member · Accepted solution]

Hello,

Please check for semicolon ";" in any of the column in Drill through table and if found replace it with comma ",". Drill Through for Excel have issues when semicolon exist in any of column in drill through table.

Thanks & Regards,
Rohit

[Former Member · Accepted solution]

Hello Rohit,

Thanks for your reply.But I checked all the columns and I don't see any ; in them. It does not work still any other ideas??

Thanks

[Former Member · Accepted solution]

Hello,

Please look for any other special character in any of the column in Drill through table, Drill through for Excel hve issues with special characters exist in any of column in drill through table.

Thanks & Regards,
Rohit