How 2 suppress records>0 & nulls as I hv 2 measure & a dimensn, datasource cube

[xyz]

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

[xyz]

Hi All,

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


Thanks & Regards,
XYZ

[xyz]

Hi All,

Can someone please share some suggestions on this post?


Your help is much appreciatred?

Thanks & Regards,
XYZ

[bdbits]

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.

[xyz]

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

[bdbits]

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?

[xyz]

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