locked
Get problem when export grid to excel RRS feed

  • Question

  • when i export grid to excel , the title of column in hirachy level 4 th is incorrect.

     

      2008 2008 2008 2008 2008 2008
    2008 2008 2008 1st Half Year 1st Half Year 1st Half Year
    2008 2008 2008 1st Half Year 1st Half Year 1st Half Year
    2008 2008 2008 2008 1st Half Year 1st Half Year
    Accum of Oppty Accum of Sign % Sign Accum of Oppty Accum of Sign % Sign
    Mr. xxxx 13 1 7.69% 13 1 7.69%
    Ms. yyy 54 24 44.44% 39 16 41.03%

     

    at "2008" it's not correct but the correct is "1st Half Year"

     

    How come i got this problem and how i slove it ???

     

    Thanks a lot

     

    p.s. with proclarity 6.3 + MS Sql server 2005 SP2

    Friday, September 19, 2008 3:37 AM

All replies

  • Hi AfterA,

     

    Are you exporting from the standard client or professional?  Does it look differently depending on which client you export with?  Does it look correct in PAS and then different in Excel?  As a test, try pivoting the view and see if the export issue remains.

    Tuesday, September 23, 2008 4:21 PM
  • Hi Sean Flanagan [MSFT],


    I'm using proclarity dashboard and exporting from analytics server.
    In PAS it look correct but incorrect in excel.
    I test to pivoting and export , i got same problem when hierarchy dimension more than 3 levels.

    I want to absolutely sure ,why i got it ??

    thank you

    Friday, September 26, 2008 2:39 AM
  • Do you see the same issue if you export from the Professional client?

     

    I'm not completely sure what the view is showing, but it looks like there are several hierarchies on columns that show members referencing time.  What if you have just the one hierarchy that shows the problem on columns?  Does the same thing happen?

     

    Wednesday, October 8, 2008 12:12 AM