Open Forum

Expand all | Collapse all

Analysis By Dimension -Getting The Analysis View Entry does not exist

  • 1.  Analysis By Dimension -Getting The Analysis View Entry does not exist

    GOLD CONTRIBUTOR
    Posted 12 days ago
    ​Our Accounting is trying to update the Analysis by Dimension but getting an error saying the Analysis View Entry does not exist.
    This is the message we are getting when update



    This is the setup of the Analysis View Card


    What is causing this to happen?

    We have reset the view and try to do the update but still getting thesame message but different information.

    ------------------------------
    Berlinda Yap
    IT Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------


  • 2.  RE: Analysis By Dimension -Getting The Analysis View Entry does not exist

    Posted 11 days ago
    Edited by David Yee 11 days ago
    To me, it looks like someone deleted the data.  I would check the last update date.  I'm pretty sure when I deleted the data the last update date changed.  We use an ancient version of Nav but so it might be different for later versions but I think you only do this in the dev version.

    When performing the update, I'd strongly recommend having your microsoft partner do the update.  I did the update and for some reason it got hung up and locked the system.  We had to revert the database to the last update and lost a day of production.  I don't think payroll has forgiven me to this day and earned me the nickname crash.
    ------------------------------
    David Yee
    Foothill Packing
    Salinas CA
    ------------------------------



  • 3.  RE: Analysis By Dimension -Getting The Analysis View Entry does not exist

    GOLD CONTRIBUTOR
    Posted 11 days ago
    ​We reset the Analysis view thinking it will solve the issue but did not.

    Will have our partner look into this.

    ------------------------------
    Berlinda Yap
    IT Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------



  • 4.  RE: Analysis By Dimension -Getting The Analysis View Entry does not exist

    TOP CONTRIBUTOR
    Posted 7 days ago

    I may suggest going to some of the transactions to confirm Dimensions actual exist for those transactions.

    Next try going to the Chart of accounts to see if the dimensions exist in various top menu choices:
    G/L Balance by Dimension
    Report Trial Balance per Global Dim.,
    Report Trial Balance Spread G. Dim

    I don't know what version you are running or is this from an upgrade which now they switch over to Dimension Set ID, that might not be transferred correctly.

    Good luck.



    ------------------------------
    Geovanny Fuentes
    BioLegend
    San Diego CA
    ------------------------------



  • 5.  RE: Analysis By Dimension -Getting The Analysis View Entry does not exist

    TOP CONTRIBUTOR
    Posted 6 days ago
    Do you require monthly compression of data? ​I would suggest running it without compression, and starting on 11/1/18. If that work then try daily, weekly, then monthly compression. This will allow you to narrow down the source of the error. If you don't need monthly compression, you may have a working Analysis View.

    ------------------------------
    Andrew Good
    President
    Liberty Grove Software
    Oakbrook Terrace IL
    ------------------------------



  • 6.  RE: Analysis By Dimension -Getting The Analysis View Entry does not exist

    GOLD CONTRIBUTOR
    Posted 5 days ago
    ​We reset everything and redo all the analysis by dimension - this seems to work.

    We are not doing it by compression.

    Thanks everyone for your suggestion and help.

    ------------------------------
    Berlinda Yap
    IT Service Manager
    Foremost Groups, Inc.
    East Hanover NJ
    ------------------------------