HFM Consolidations not completing after enabling ICP for all accounts.
Need: An account may receive either ICP or Non ICP data. For example,
this month icp data may come for account: A_099099 (account)>E_9089(ICP) $1000
next month non icp data may come for same account: A_099099>[ICP None] $2000
Our solution:
To be able to load both possible data combination, we enabled 'ICP' (IsICP->yes) for 1200 base accounts in HFM.
Problem:
Consolidations are not completing and we get warnings like below in system messages:
[[A{A_BS00000.[Base]}.C5#MTD_AVG_AGG; The cube Scenario = 2, Year = 2019, Entity = 5, Parent = -1, Value = 17, contains at least 100000 records.]]
[[A{A_BS00000.[Base]}.C5#MTD_AVG_AGG; The cube Scenario = 2, Year = 2019, Entity = 5, Parent = -1, Value = 17, contains at least 150000 records.]]