Report with Dynamic Calc Members does not run!
Good morning!
I have an issue with the retrieval of dynamic calc members populated via outline formula.
My application has the following dimensions:
Accounts dense
Time Periods dense
Dir Dense
Scenarios Sparse
Versions Sparse
Years Sparse
Units Sparse
Recipients Sparse
Products Sparse
Recipients dimension is a mirror dimension to Units so as to be able to represent for fees and costs, the fee’s or cost’s source (Unit) and the fee’s or cost’s destination (Recipient). So if Units dimension has members A, B, C,..., recipients dimension has members :A, :B, :C,.... and if user enters an amount 100, fees (dimension Accounts), Paid (dimension Dir), A (dimension Units), :B (dimension Recipients)I want to dynamically calculate an amount -100, fees, Received, B, :A. The calculations (reversed amount and reversed source-destination) are performed in outline via members’ formula in member Received (Dimension Dir).