Open Forum

Expand all | Collapse all

Jet Cube does not show the posting dates after 11/27/2018

  • 1.  Jet Cube does not show the posting dates after 11/27/2018

    SILVER CONTRIBUTOR
    Posted 18 days ago
    Hello Friends,

    I wonder if any of this group members use JET data manager server to build the analysis cubes.

    I built a pivot chart using the JET analysis cube, but the posting dates do not show up correctly. For the month of November, the end date is shown as 11/27/18 and there after all the invoices are moved under Unknown date.

    I did check the date table settings for the cube, which shows that there is no such end date set for the table.
    Querying the SQL table that build up the Cube, I see the posting dates to be showing up correctly.
    I think this has something to do with the settings for the date table in the Jet Cube. I am not sure where else to look for.

    Any ideas/suggestions are highly appreciated.

    Thank you,

    ------------------------------
    Archana K
    Business Systems Analyst
    American Labelmark Company (Labelmaster)
    Chicago IL
    ------------------------------


  • 2.  RE: Jet Cube does not show the posting dates after 11/27/2018

    Posted 15 days ago
    I am not a Jet expert by any stretch of the imagination, but I seem to remember that NAV has settings for Analysis Views that dictate when a window of time gets created.
    Meaning, if you have the setting to aggregate weekly, it will not create that bucket until there are transactions posted in that window.
    So, if Jet is using that data somehow, it may not create this week's bucket until you have postings in it. So it may fix itself this evening after the next build.

    It is possible that I am way out in leftfield, but I wanted to throw it out there for the Financial and Jet Experts to confirm or refute.

    ------------------------------
    ~Roger Neely
    OOBE, Inc

    ------------------------------