Hide empty rows web intelligence 4.0

[former_member327010]

Hi all,

how can i hide empty rows in web intelligence 4.0??

I tried "Format table" > "Show rows/columns with empty measure values" but it doesnt work. I dont know why. Could it be that a zero value is not recognized as empty ? We are using olap connection to bex query. There is no universe layer between.

Thanks,

regards Martin Zluky

[Former Member]

Hai

http://bi.stieper.dk/tip-hide-coloumn-in-web-intelligence-webi-145/

[former_member327010]

link is not working

[former_member327010]

Can someone explain me how this option works: "Show rows/columns with empty measure values" ?

I have a row with two empty measures and two wtih value "0". When i use this option it still remins visible in the report. I think it takes the zero value as any other value and the thats way it still remains visible, am i right ?

[Former Member]

Hi,

You are right. 0 is not an empty value.

Raoul

[former_member327010]

Wow,

i must say that i am starting to hate web intelligence. Any ideas how i can hide rows with measure value "0" ??

Thanks for any help,

regards Martin Zluky

[Former Member]

Hi Martin,

It sounds like you might just want to filter the data for the block. If you add a filter: Measure > 0, does that work?

If the logic to hide the row is more complex, you can create a variable called "Visibility" that contains a formula that returns "Hide" or "Show". E.g.

If Measure1 > 0 and (measure2 > 0 or IsNull(Measure 3) or Measure3 > 0) then "Hide" else "Show"

Then create a filter for Visibility = "Show"

Hope that helps.

[former_member327010]

Hi david,

it looks like your formula is really showing the rows i wanted but the measure values are (after applying filter for show or hide) now #unavailable. I think its because they are database delegated. But i cant do nothing because we are using access to SAP BW via BICS and there is only an "unvisible" universe layer and all measures/key figures are set to database delegated, like it or not

Thank you anyway,

regards Martin Zluky

[Former Member]

Yes, if you introduce another filter into the block and the measures are db delegated then you'll get #UNAVAILABLE.

If your measures are sums, then you can set the projection type to sum in the universe. If they're averages or percentages, then you're probably stuck.

[former_member327010]

Thats what i thought,

thank you anyway.