Analysis Services and Excel

• Roman Aimar

  SSC Rookie

  Points: 28

  More actions

  November 22, 2004 at 1:25 pm

  #162720

  I have a lot of problems

  1. I change in Analysis Service the measures data format, and when i open the cube in excel, doesn't bring me the format

  2. In Excel, how can i drill down?

  3. In Office Web Component how can i save a modified Report

• November 25, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Angela But

  Hall of Fame

  Points: 3848

  More actions

  November 25, 2004 at 10:22 pm

  #531573

  Can you see the correct format if you view the cube from Analysis Services?

  To drill down in Excel double click the cell you want to drill down on.  To Drill back up click on the level you want to drill up to and double click.