Skip to Content
0

Suppress Zeros in InfoChart (DS 1.6 SP1 Patch 2)

Jul 12, 2017 at 01:46 PM

88

avatar image

Hi Experts,

i'm facing a problem with "suppressed Zeros" in an InfoChart. In the Query i selected this option:

In Design Studio the Preview looks fine:

But, when i run the Dashbord the "zeros" were not suppressed in the InfoChart:

Has anyone an idea how i could solve this problem?

Best regards

Daniel

ds-preview.png (18.2 kB)
ds-infochart.png (25.6 kB)
10 |10000 characters needed characters left characters exceeded

Hi Daniel,

I assume the Preview screenshot is of the data source Initial View Editor? What does the data look like in a Crosstab? Are the zero columns correctly suppressed there as expected?

Regards,

Mustafa.

0

Hi Mustafa,

you are right, the Preview screenshot is of the data source Initial View Editor. There i modified the inital view. In a Crosstab the zero columns are supressed, as expected:

Regards Daniel

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mustafa Bensan Jul 13, 2017 at 06:01 AM
0

Hi Daniel,

Unless you are able to suppress the zero columns in the InfoChart Data Selection property, I am inclined to think the issue you are experiencing is a bug or design limitation with the InfoChart, especially if the Crosstab shows the data correctly, in which case I would suggest you open an SAP Support Ticket.

Regards,

Mustafa.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Hi Mustafa,

thank you! The Data Selection property is in our scenario no option, because the User select in the Variablescreen for each Key Figure the Fiscal Year. So i don't know which columns are suppressd at runtime. Or do you know a solution for this requirement?

We will open a Support Ticket.

Best regards

Daniel

0

Hi Daniel,

Can you clarify with a screenshot what you mean by "User select in the Variablescreen for each Key Figure the Fiscal Year"?

Regards,

Mustafa.

0

Hi Mustafa,

The requirement is to build a flexible Query. In the Bex Query I defined a Key Figure-Structure with this option:

In each Selection i add another Variable for the Fiscal Year:

So the Variablescreen in Design Studio looks like this:

The User can select individually the Fiscal Year(s) for the Actual Values, for the Plan and for Forecast Values.

regards
Daniel

0

Hi Daniel,

Thanks for the clarification. Interestingly the "Visibility of Structure Members" setting does not appear in my version of BEx Query Designer. I am running BW 7.31. What version are you on?

From your screenshot it looks like you have not activated the "Suppress Zeros for Structure as Group". Is that right?

Regards,

Mustafa.

0
Dwain Chang Jul 13, 2017 at 10:09 AM
0

Did you try to use a condition in the BEx query? Show values not equal to zero?

regards,

Dwain

Share
10 |10000 characters needed characters left characters exceeded