Show and Hide KF

[Former Member]

I have place the KF Amount in the Query Designer.

I would like to hide this key figure if it is 0, and show only if it is not 0.

Can we acheive this in Query Designer?

Kindly advice, thank you.

[Former Member]

good info

[Former Member]

HI,

Create a Condition on that Keyfigure that Keyfigure isnotEqualto Zero.Then only if Keyfigure having values those records only displayed.

Tarak

[Former Member]

Hi,

Select your query in BEX>Right click on your query>select All characteristics--> select suppress zero Columns/Rows.

we cant hide KF for zero values. We can hide it totally.

Regards

Pcrao.

[Former Member]

Create two formula variable. Populate one when KF is zeor and other when KF is not zero. In the query designer, you hide original KF and fformula variable1. You just display formula varibale 2.

Thanks..

Shambhu

[Former Member]

Hi Shambhu,

Can you please explain again on the following, I am not very sure what you mean.

"...Populate one when KF is zeor and other when KF is not zero..."

Thank you!

[Former Member]

Hi Linda,

the solution not to show zeros is:

In Query Designer, go to Query Properties --> "Representation of values" Tab --> Represent Zeros --> Represent as blank space

In this way zeros are not shown anymore.

Hope it helps you

[Former Member]

Hi Jordi,

I can't find the following:

"... "Representation of values" Tab --> Represent Zeros --> Represent as blank space .."

I am on BI7.

My question is on how can we suppress the entire column if it is 0.

Thank you,.

[Former Member]

Friends,

Ok, this the scenario.

I have created the MultiProvider to link the two cube - Plant A and Plant B.

I have the following in Plant A cube:

Characteristic:

Plant

Cost Center

Key Figure:

AmountA

I have the following in Plant B cube:

Characteristic:

Plant

Cost Center

Key Figure:

AmountB

I have placed the Plant, Cost Center in the MultiProvider, and Identify them with Plant A and Plant B.

I have also Placed the Key Figure AmountA in the MultiProvider, assigned to only Plant A cube.

I have also Placed the Key Figure AmountB in the MultiProvider, assigned to only Plant B cube.

There are reason why I dont want to group the AmountA and AmountB together.

In the Query Designer, I have placed the Plant and Cost Center in the Row. And the Key Figure AmountA and AmountB in the Column.

When I run the query, I have the following output:

Plant.....Cost Center.....AmountA...AmountB

1500......1158970.........1,000.....0

1600......2234567.........3,999.....0

Above result is coming from Plant A cube, because no data is pull out from Plant B cube and hence the AmountB is 0.

Now, is there a way for me to hide this AmountB so that I have the following output:

Plant.....Cost Center.....AmountA

1500......1158970.........1,000

1600......2234567.........3,999

Please help.