Set analysis in chart - unexpected results

[#1]

Morning all,

I have a document where the user wants to be able to define for themselves how many months are to be included in the analysis (1 to 13).

The document creates a set of variables at load time based on the current month. These are then used to create dynamic expressions depending on the number of months selected and I use 'sum' with 'set' to calculate the values.

However, I dont see what I expect to see - please see the comments in the attached qvw.

Is it the way I am trying to use set analysis (I'm afraid me and it are barely on speaking terms) or more fundamental?

Any help appreciated.

Regards,

Gordon

[sathishkumar_go]

Hi Gordon,

In that Application, Cust5 and 5 don't have values that what pivot is not showing....

-Sathish

[#3]

Hi Sathish,

...but if the result of the 'set(sum' is 0 and 'suppress zero-values' is NOT checked....?

Regards,

Gordon

[Oleg_Troyansky]

Gordon,

very strange behavior.. especially when it comes to "Cust4" and "Cust5", when the Dimension value is being replaced with a null()... I'd report it to support as a possible bug.

I don't see any problems in your Set Analysis, it's pretty straight-forward...

[#5]

Thanks Oleg - I have raised it with support and will post their response.

Regards,

Gordon

[#6]

...this has been given bug ID 33875

Gordon

[#7]

I got this reply from Support:

Unfortunately the issue as described below has been rejected by our Test department as a WAD (Works As Designed), ID 33875.

We can however provide you with a workaround which should help you.

This looks to be related to the fact that the Cust4 and Cust5 data is all zero's

if you go to Object > Properties > Dimensions tab and then select the "Show All Values" checkbox then the Cust4 and Cust5 Data appears, and if you Deselect the "Suppress When Value is Null" you will see the Null Value line appear under the other data.

About "Show all Values":

Select this box to show all the dimension field values in the chart, including logically excluded values.

the "Logically Excluded Values" is what i think Cust4 and Cust5 data is.