Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
How to ommit the null division code :
See attachment:
For eg,
The NULL Division Code is summing up the "Budget Units" for other division code
I dont want the sum up of "Budget Units" in NULL Division Code.
Output should be "Budget Units":
CI10 9878
U001 12
How to write the expression for Inbound Orders , Blocked Stock and Actual receipts as they are not having division code.
See attachment.
I dont want the sum up of "Budget Units" in NULL Division Code.
SUM({<[Type Indicator] = {'B'}, [Division Code]={'*'} >} Quantity)
Same for the other expressions.
Hi, checking 'Supress null values' in [Division Code] dimension can be an option?
Beside your question - you have a lot of sythetic keys within your datamodel which could cause problems. Recomended is to resolve these sythetic keys, see for this: Synthetic Keys.
- Marcus