Hi Everyone, In our system - Profit Center is in the Entity Dim and Cost Center is in UD1. Only specific Cost Center(s) are valid per profit center, and this mapping is stored in a SQL table in the system. The need is to be able to enter data for 1 s...
Hi, How to get 4 quarters data in one year like Q1+Q2+Q3+Q4= 2023? what is the use of Scenario View-SV in View Dimension? Can anyone help me with above questions? Thanks in advance.
My Cube view has entities in rows. One of the rows is a sum of several entities ( E#A1+E#A2+E#A3). In the 4 columns I have Actual, Budget, Variance and Variance%. Variance and Variance % being calculated from the two first columns. Works fine except ...
Hello all, Is there any way to set a conditional formatting in a cube view column based on 2 different columns? I have 2 variance columns (one on dollar amount and another with a % variance) that should have a red color if 2 conditions are met. For e...
How do I combine XFMemberProperty with Dynamic expansion in a cube view? E.g. I want to expand Entity and account on Rows. Row1: E1 =E#Total.Base, E2=A#FinancialAssets.Base in columns I have transaction and ledger amounts (UD5) and then I want to add...
