Aside from either re-writing every query that performs the ETL, or changing every Fact folder measure, is there any way via configuration that you can get all DR values to display as -, all CR as + (and yes I know this is not standard accountancy convention) - or if you are not au fait with DR / CR to flip the signs of all values in financials.
thanks for your input,
thanks for the thought but simple as this is when you multiply it by all columns and all reports that currently exist then this becomes a massive job, I was looking for something more along the configuration lines if at all possible...
Do this in the RPD level(Metric level).If these metrics are used in 50+ reports also it gives u the same results(+ to - and - to +).
If you dont want to do even in the RPD level then only left option is at the ETL layer..