How to display null values

[Tsunami]

Probably pretty simple BUT I'm trying to create a list of customers and sales.  However, the list is leaving off any customers without sales.  What do I have to do to have a full list of customers with and without sales?

[Arsenal]

depends upon the join between customer dim table and sales fact table.
you'll need some sort of an outer join - depending on how you have arranged it in FM you may require a left or right outer join or maybe even a full outer join (PERFORMANCE WARNING!!!!)

also in RS you'll need to number format fact data items to have missing values replaced with NA or something
if it is null on the DB for no sales customers, you might have to try a coalesce around the fact data item expression

[Lynn]

Another option to consider might be a union instead of an outer join.

Create a query from your customer table and add a data item for sales with an expression of zero.

Then query from your sales data with the exact same layout.

Union the two results together setting the sales data item aggregation to Total.

Can't say it will be faster than an outer join but it is another means of accomplishing the same thing.

[nthacker]

You could also use a Query calculation to create a new column.  Use and If, or Case statement to convert the nulls to 0's then cut out the old column and use the new one.