Pivot table problems

Leïla
Leïla Member Posts: 8
edited 2006-10-20 in NAV/Navision Classic Client
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

  • ara3n
    ara3n Member Posts: 9,258
    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
  • Leïla
    Leïla Member Posts: 8
    Thanks Rashed, but do you know if there is an add on to solve this problem?

    Regards
    Leïla
  • ara3n
    ara3n Member Posts: 9,258
    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
  • Leïla
    Leï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
  • ara3n
    ara3n Member Posts: 9,258
    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
  • Leïla
    Leï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
  • ara3n
    ara3n Member Posts: 9,258
    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
  • Leïla
    Leï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

Categories