We are using reporting three duplicate of organization hierarchy.
We have two legal entities and many departments at dimension level.
We are trying to consolidate financial statement with transaction level through reporting tree using, department financial dimensions, but financial reporter do generate consolidation report at financial, account level not at transaction level.
Even in consolidation at reporting tree, one issue we face again and again in Financial Reporter is consolidation across a large number of entities. We have three entities using D365 finance that will have issues when their report trees need a row for each entity and dimension combination. For example; we have 30 department's dimension values want a consolidated report view for their 3 entities . To make matters worse, they also want a drill-down by the department. While a tree becomes very big and almost unmanageable, because combinations must be created for each entity as a separate row (level) in the tree.
Suggestion: We have @any in reporting tree which supported to generate consolidate report at financial details level but coming to account detail level, the consolidation would generate with three different legal entities level and transaction level we have to drill with each entity wise, If @any function is consolidating financial at same level, we drill down can see consolidated transaction for all legal entities with financial dimension might be very useful .
It basically instructs the reporting tree to use @any generating the report and requires to generate consolidation at transaction details level.