Options

Pivot table problems

LeïlaLeïla Member Posts: 8
Hi!

Does anyone know why, the pivot table on XL shows different figures than those which are in the analysis by dimension ?

Thanks
Regards
Leïla

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    there is a known issue with analysis entry skipping entries. Try to rebuild the analysis views.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    LeïlaLeïla Member Posts: 8
    Thanks Rashed, but do you know if there is an add on to solve this problem?

    Regards
    Leïla
  • Options
    ara3nara3n Member Posts: 9,256
    The workaround is to rebuild the analysis view table.
    To do this, change a setting in analysis view card, Navision will ask you that it will reset the entries. Click Yes.
    After the process is done, change the value back to the original setting and run calcuate. This will rebuild analysis view table

    Afterwards make sure you optemize analysis entry table. By going to file->dabase->information->table
    Filter on Analysis View Entry 365 and click on optemize.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    LeïlaLeïla Member Posts: 8
    ara3n wrote:
    The workaround is to rebuild the analysis view table.
    To do this, change a setting in analysis view card, Navision will ask you that it will reset the entries. Click Yes.
    After the process is done, change the value back to the original setting and run calcuate. This will rebuild analysis view table

    Afterwards make sure you optemize analysis entry table. By going to file->dabase->information->table
    Filter on Analysis View Entry 365 and click on optemize.

    Thank you Rashed, I've done what you advised but it still doesn't work! Figures are still different in XL, even on Cronus. The first line is always on 0 and all the total lines are different. May be I have to set up something in the XL sheet?

    Regards
    Leïla
  • Options
    ara3nara3n Member Posts: 9,256
    Can you verify which has the correct value? Analysis view or pivot table?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    LeïlaLeïla Member Posts: 8
    ara3n wrote:
    Can you verify which has the correct value? Analysis view or pivot table?

    The correct value is on the the analysis view.

    Leïla
  • Options
    ara3nara3n Member Posts: 9,256
    How do you create the pivot table? Do you refresh the datasource?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    LeïlaLeïla Member Posts: 8
    ara3n wrote:
    How do you create the pivot table? Do you refresh the datasource?

    Actually, I realised that the amount in XL is wrong because it takes into account only one analysis view entry line from Navision instead of taking all analysis view entry lines for one account. Do you see what I mean?

    Leïla
Sign In or Register to comment.