Skip to Content
0
Oct 01, 2009 at 06:04 PM

Show null (zero) values in query

62 Views

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