Showing empty rows for crosstab [SOLVED]

[intrepid402]

Hi Developers!
The business requirement is that I need to show empty rows for [Work] even when [Employee] hasn't done it.
Currently for measure, I am using this:

count([Work] for [Employee],[Work])

I need to display [Work] column even if employee hasn't done any number of [Work].

I tried left outer join in the FM. That didn't help. Is it possible to do this when you have measure where you are using is count?
If it isn't count, I guess you can input null values and show that. But I am kind of lost. Please let me know if anyone has any solutions.

[intrepid402]

Anyone has a solution for this?

[Francis aka khayman]

are you using dimensional or relational?

[intrepid402]

Hi,
I am using relational.

[intrepid402]

I used this document to finish the task.

http://www-01.ibm.com/support/docview.wss?uid=swg21341708