Planning Analytics

 View Only
  • 1.  Dimension hierarchy update fails.

    Posted Thu December 15, 2022 11:55 AM
    Hi,
    We are running a turbo integrator process to update a dimension hierarchy. Business as usual, no changes in the process itself. Now process fails and I get this log error message:

    Error: MetaData procedure line (0): P&L_PRODUCTO Dimension Update Fail. Rule Is Invalid. Until rule is fixed

    No recent changes in the cube rules also. This cube rules has no references to the updated dimension hierarchy.
    Has this kind of error been reported? Is it a bug?
    Any advice will be appreciated

    Regards.

    ------------------------------
    Jose Luis Senas
    Data Analyst
    Kimberly-Clark Mexico
    Mexico City
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Dimension hierarchy update fails.

    Posted Fri December 16, 2022 03:18 AM
    Hi Jose Luis,

    Sometimes you get that error message when there are other issues with the rule, e.g. a hard-coded reference to a deleted element in another dimension/hierarchy or a DB call with incorrect dimensionality. Or even a reference to the dimension being modified with no hierarchy specified and now the process is trying to add an element that already exists in another hierarchy and the system can not tell which one the rule tries to refer to (so instead of !Element or 'Dimension':!Element, try 'Dimension':'Hierarchy':!Element (made up example)).

    BR,
    Anssi

    ------------------------------
    Anssi Lehtinen
    ------------------------------



  • 3.  RE: Dimension hierarchy update fails.

    Posted Fri December 16, 2022 09:18 AM
    Jose Luis,

    I just encountered this error last week.  What I found (echoes Anssi) is that a rule referenced an element in another dimension that matched an alias in the dimension I was updating.  I qualified the rule reference to "Dimension":"Element" and problem went away.  For some reason this conflict didn't come up anywhere else (logs, validation of rule), and never came up in previous updates.

    Dean

    ------------------------------
    Dean Watts
    ------------------------------



  • 4.  RE: Dimension hierarchy update fails.

    IBM Champion
    Posted Fri December 16, 2022 10:04 AM
    Hi Jose,

    A guess is that you are getting ambiguous element names in the cube, and have a rule where you have not provided the dimension and hierarchy name. That would be most likely, if the issue arose in normal maintainse, where new hierarchy and dimension members are added.

    Example:
    - You have a rule ['Company A', 'Account 1234'] = DB(....);
    - You create a new hierarchy in the Department dimension, called "Company", with Company A, Company B... summarizing departments
    - Your rule is now invalid, as Company A could referee to both your new Department:Company hierarchy and the Company dimension.

    To solve that, provide the dimension (and if requiere hierarchy as well) in the rule: ['Company':'Company A', 'Account 1234'] = DB(....);



    ------------------------------
    Emil Malmberg Fosdal
    ------------------------------



  • 5.  RE: Dimension hierarchy update fails.

    Posted Fri December 16, 2022 10:14 AM
    Hi,
    Thanks Anssi, Dean, Emil for your comments and suggestions.
    Seems like I have to review my cubes' rules (lots of).
    Will do that and post the ressult.
    Thanks again.

    ------------------------------
    Jose Luis Senas
    Data Analyst
    Kimberly-Clark Mexico
    Mexico City
    ------------------------------