I have a query, where I need to compare the 'Payment Terms' opted by the customer (Master data) with Payment terms actually done in the transaction.
So, I have Payment terms present in the InfoCube and also attribute of Customer Master.
Now, I need a report to show only those records where Payment terms varies with the Payment terms in the Master data..
Is this possible...?
1. Searched SDN but could not get the solution..
2. Checked with Formula Variables ..but in vein as we cannot pick charactieristics (of Data Type : Character string) with Formula Variables
3. Virtual Characteristics : Not a fessible option due to performance concerns