Hi
I'm trying to deliver a flexible customer dashboard for a client using OLAP Analysis services (2000 not 2005) and Excel 2007. Everything works great until i try to drill through to the detail data behind the 'Grand Total' figure for a filtered set of data. I've found a Microsoft article that tells me this is not possible in Excel 2003 - does anyone know if it should work in Excel 2007 (I suspect I'll be disappointed and find that it won't) and has anyone come up with a solution to the issue ? Any help would gratefully appreciated before I go and write a series of macros to get each set of detail records into individual worksheets before consolidating them into one big worksheet.
Any advice gratefully received
dave
Hello! I suspect that the grand total is a calculated member and drill through is not supported on calculated members.
Regards
Thomas Ivarsson
No comments:
Post a Comment