At the moment the Aggregated member uses the IsConsolidated property to aggregate or not. Do I have any option if I wanted to aggregate a member but not consolidate it? With the introduction of the new member Aggregated, is there going to be a IsAggr...
Hi All, I am trying to get my member formula to calculate an unbalanced balance sheet and I built a Quick View to see the calculation. However, it does not seem to be calculating anything with the member formula. The following is the member formula u...
Hi all, I have built out my cube view that shows headcount change for 2019 M12, I want to be able to capture the ‘Ending Balance Headcount’ for 2020 M1 as its ‘Begin Balance’. Will a rule be the way to go in order to achieve this? Unsure on where to ...
What is the best way to design and implement constant fx rate analysis? We want to apply a budget rate to all months for actual/fc/budget. Entities are loaded in local currency and I thought it would be simple to use an entity hierarchy in which I'd ...
Often global companies may report a metric like units sold or volumes in a stat account. But that unit of measure may vary by region or country. Below is one option for handling the conversion of stat accounts like units sold or volumes. For example:...
