on 10-01-2009 7:04 PM
Hi Gurus,
Can I show in a query null values in cases that the InfoCube or dso doesn´t have records with values?
Example:
Sales Cube (with data records)
1 = 100,00
2 = 150,00
3 = 200,00
The InfoObject COUNTRY have 4 records (master data):
1 = Brazil
2 = India
3 = USA
4 = Jamaica
The InfoObject have 1 hierarchy:
COUNTRY
001 BRA
002 IND
003 USA
004 JAM
The query results is:
COUNTRY
BRA 100,00
IND 150,00
USA 200,00
JAM
I need to show in this case 0,00 to record JAM, but the query shows BLANK.
Can I do this?
Best Regards
Alex
Try to create your calculated Key figure with data function NDIV0(x) or NOERR(x).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alex,
yes you can do this. Create a formula and add your sales + 0.00. In this case your result will always have 0.00 even if there is no data in your cube.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.