Thursday, July 2, 2020

Fun with Financial Reporter - @ANY in Reporting Tree

Something else learned along the way last week . . .
1. The @ANY value, which is typically assigned only to the summary level, enables the reporting tree to be used for all companies. However, all child nodes must have a company assigned to them for the roll-up to work.

2. You can have multiple companies defined in Financial Reporter. If you select the company code @ANY, the FR default company is used to generate reports.
I had always assumed that @ANY also rolls all dimensions across all Companies up to the summary level as well - like below. But that is not the case.

Attached image - No description set

The Branch dimension in the example needs to be accompanied by a Company value on the line.

Attached image - No description set

This will roll the cross-company Branch results up to the summary level but the config in the previous image will not.


1 comment:

  1. Amazing knowledge and I like to share this kind of information with my friends and hope they like it they why I do birth chart astrology

    ReplyDelete