Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: xyz on 25 Sep 2014 07:44:48 AM

Title: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: xyz on 25 Sep 2014 07:44:48 AM
Hi All,

I have a requirement, where I have display a list report for current selected week, I have fiscal week as a date prompt, where the list report displays Employee dimension along with two measures Labor Hours and Absent. Data source is SSAS cube, I am using dimensional function in the report studio.

Employee  Labor Hours  Absent
A              8                  3
B              0                   
C              2                   1

How will I suppress the null record in Absent measure as well as suppress 0 record in Labor Hours measure?

On the Employee dimension I can try the below statement to only on one measure

filter([Employee], [Absent] is not null)

How will I filter for Labor Hours?

Can someone, please help me on this, your help is much appreciated?

Thanks & Regards,
XYZ
Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: xyz on 28 Sep 2014 01:12:55 PM
Hi All,

Can someone, please update with some suggestions or idea's on the same, your help is much appreciated :)


Thanks & Regards,
XYZ
Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: xyz on 29 Sep 2014 02:52:40 AM
Hi All,

Can someone please share some suggestions on this post?


Your help is much appreciatred?

Thanks & Regards,
XYZ
Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: bdbits on 29 Sep 2014 05:06:38 PM
To be honest I've not needed multiple filters like that myself so I was not sure. I will venture a guess that alas, I have no time to test right now.

I think you had another post saying filter([dim],{some boolean} and {another boolean}) did not work? Try nesting the expressions - filter(filter([dim],{some boolean}),{another boolean}).

That might work.
Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: xyz on 30 Sep 2014 02:19:28 PM
Hi bdbits,

Thanks for the reply, your help is much appreciated.

I tried your suggestion as mentioned by you, but there is no improvement in the performance as my dashboard is running for 50 seconds.

Do you have any suggestion for improving the performnace?

SSAS cube as a datasource.

Your help is much appreciated :)

Thanks & Regards,
XYZ
Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: bdbits on 01 Oct 2014 09:04:46 AM
I thought the problem was whether it worked at all, rather than a performance issue. That's sort of a different issue.

If you do not filter() at all is the performance better? Is this a workspace, or just a report studio report? If it is just one report, is it possible for you to attach the report spec here?

Title: Re: How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube
Post by: xyz on 03 Oct 2014 01:38:58 PM
Hi bdbits,

Thank you very much for the reply, actually the filter idea suggested by you worked for me.

My apologies, performance is the other issue I have been facing, actually the report studio report I am finally pulling into workspace.

Can you please find the attached spec in xml, your ideas or suggestions is much appreciated.


Thanks & Regards,
XYZ
Text only | Text with Images