Question:
Hi
I am working on a query from PCA infocube which has rows representing grouping of accounts using PCA account number ranges to display the amounts. I have the functionality to drill it down on account number. We have a specific business requirement to exlude the PCA accounts which have negative G/L balance in reporting.
I sincerely appreciate anybody's feed back on the logic to solve this problem. I was trying using cell editor, conditions, structures, multi cube with GL etc.,
Thanks
_________________
SunSAP
Answer:
Could you use the boolean function to derive a new figure having a value of 1 or 0 depending on whether the balance is greater than zero? Multiply this with the original balance so that negative balances become zero and positive ones are unchanged.
..or have I misunderstood the problem?
Answer:
We had a similar situation. We created an ODS out of the FIGL cube to summarize the GL ACCOUNT balance. Then wrote Update Rules code to go against the /BIC/ table of the ODS and fill in a 'negative' or 'positive' balance flag.
I hope this helps,
Mike