Cube Dependencies Added with No Manual Intervention

[normanbobo]

We are seeing INFO level messages in our log which show cube dependencies being added. However, no processes were run and all of the chores are turned off. What could be triggering these cube dependencies to be added?

It's a mystery wrapped in a conundrum.

Here are the log entries. You will note the GMT times in the log are 11:51 and 15:27. The server is on Pacific time, GMT-8, so this is happening at 3:51 AM and 7:27 AM respectively. I can tell you that no one is on this system at that time!

Code: Select all

9928   [2]   INFO   2014-07-08 11:51:19.808   TM1.Cube.Dependency   Adding cube dependency: Cube 'P&L' depends on cube '}ElementAttributes_Door'.
9928   [2]   INFO   2014-07-08 11:51:19.902   TM1.Cube.Dependency   Adding cube dependency: Cube 'New Door' depends on cube '}ElementAttributes_Door'.
9928   [2]   INFO   2014-07-08 11:51:19.902   TM1.Cube.Dependency   Adding cube dependency: Cube 'New Door' depends on cube 'P&L Allocation'.
9928   [2]   INFO   2014-07-08 11:51:19.917   TM1.Cube.Dependency   Adding cube dependency: Cube 'P&L Allocation' depends on cube 'Door Detail'.
9928   [2]   INFO   2014-07-08 11:51:19.917   TM1.Cube.Dependency   Adding cube dependency: Cube 'New Door' depends on cube '}ElementAttributes_Date'.
9928   [2]   INFO   2014-07-08 11:51:21.228   TM1.Cube.Dependency   Adding cube dependency: Cube 'P&L' depends on cube '}ElementAttributes_Account'.
9928   [2]   INFO   2014-07-08 11:51:21.649   TM1.Cube.Dependency   Adding cube dependency: Cube 'P&L' depends on cube 'Global Version Control'.
9928   [2]   INFO   2014-07-08 15:27:40.437   TM1.Cube.Dependency   Adding cube dependency: Cube 'P&L' depends on cube 'FX'.

[lotsaram]

It isn't really anything special at all. It simply means a user has requested results from a view that have caused a rule calculation to be evaluated that in turn has caused the server to discover a "new" dependency (encoded in the rule calculation). The latest versions do a much better job of picking such dependencies up on server load but pre 10.1 only feeder dependencies and not calculation dependencies were evaluated at server load.

[normanbobo]

Lotasaram: great answer as always. Thanks!

[Wim Gielis]

In addition to what was said above, you can help TM1 by running a process in a chore, which goes through all cubes with rules.
Process the contents of the .rux file and use the AddCubeDependency function in TI.