the site im working on is under windows 2000 server, iis (asp), and im using excel (office 2000 and above) as my presentation layer.
the problem im encountering is the way excel shows the data which is kinda funny at times. i mean, even though your refresh - it still is funny. well, if i do drill-up to the highest level, then drill-down back to the preferred level, everything comes out OK.
to elaborate on example, consider a certain dimension
now, if i do drill down from a an excel sheet having an embeded pivot table, the dimension comes out as
which is kinda funny, right?
however, if i reset (not RELOAD) the excel sheet by drilling up to the top-most level, then drill-back down, everything comes out ok.
it is just that i dont want the need to drill-up to the top level, then go back down... it is just not good for dynamic reports, and im quite sure that the users would be complaining
the problem im encountering is the way excel shows the data which is kinda funny at times. i mean, even though your refresh - it still is funny. well, if i do drill-up to the highest level, then drill-down back to the preferred level, everything comes out OK.
to elaborate on example, consider a certain dimension
Code:
A
B
C
D
E
F
G
H
I
J
Know, if i do drill down from a an excel sheet having an embeded pivot table, the dimension comes out as
Code:
A
E
B
C
D
F
G
H
I
J
Kwhich is kinda funny, right?
however, if i reset (not RELOAD) the excel sheet by drilling up to the top-most level, then drill-back down, everything comes out ok.
it is just that i dont want the need to drill-up to the top level, then go back down... it is just not good for dynamic reports, and im quite sure that the users would be complaining