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.
The Branch dimension in the example needs to be accompanied by a Company value on the line.
This will roll the cross-company Branch results up to the summary level but the config in the previous image will not.
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