Error when creating GLBudget Cube in Business Analytics

aje
aje Member Posts: 4
edited 2006-08-31 in NAV/Navision Classic Client
When I try to run the BA Configurator, it halts during processing of the GLBudget Cube and I get the following text in the Analysis Server log-file: "...A member with key '00015249' was found in the fact table but was not found in the set of leaf members of dimension 'G_L Account'. The maximum number of dimension key processing errors has been exceeded..."

The cubes I process is the standard cubes coming with BA with no alterations.

Anyone who knows the solution to this?

Comments

  • kine
    kine Member Posts: 12,562
    I had same problem - check this:

    it seems that the G/L Account 00015249 is of type "Begin-Total". You cannot create Budget for Begin-Total accounts if you want to use BA. Move all budget entries for begin-total accounts to corresponding End-totals accounts.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • aje
    aje Member Posts: 4
    Account no. 15249 does not exist in my database! No budget entries for begin-total accounts either!
  • kine
    kine Member Posts: 12,562
    Try to search your table 96 G/L Budget Entry for that G/L account. It seems like there are entries for nonexisting account.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • aje
    aje Member Posts: 4
    I have no entries in table 96 with this account no. I have no entries in table 96 on account type: begin-total.

Categories