Print Page - Showing empty rows for crosstab [SOLVED]

Title: Showing empty rows for crosstab [SOLVED]
Post by: intrepid402 on 12 Mar 2014 12:39:18 PM

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.

Title: Re: Showing empty rows for crosstab
Post by: intrepid402 on 17 Mar 2014 12:29:29 PM

Anyone has a solution for this?

Title: Re: Showing empty rows for crosstab
Post by: Francis aka khayman on 17 Mar 2014 08:45:25 PM

are you using dimensional or relational?

Title: Re: Showing empty rows for crosstab
Post by: intrepid402 on 18 Mar 2014 10:38:42 AM

Hi,
I am using relational.

Title: Re: Showing empty rows for crosstab [SOLVED]
Post by: intrepid402 on 19 Mar 2014 11:17:22 AM

I used this document to finish the task.

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: intrepid402 on 12 Mar 2014 12:39:18 PM