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
------------------------------
Original Message:
Sent: Thu December 15, 2022 11:55 AM
From: Jose Luis Señas Cuesta
Subject: Dimension hierarchy update fails.
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