How to reverse signs of Revenue and Liability accounts in Oracle GL balance essbase cube?
Summary:
We are looking to identify the best approach for reporting Revenue and Liability account numbers in Smart View. Currently, these accounts appear as negative values. While Excel formatting can hide the negative sign visually, the underlying values remain negative, which is affecting Excel formulas. Is there a configuration setting in the GL Essbase cube that allows the sign to be reversed for these accounts? We want to know the best practice.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
0