Page 1 of 1
ViewZeroOut on Strings in 9.4 HF16
Posted: Thu Feb 18, 2010 6:02 am
by jed
We were on 9.4 FP2 but have moved to HF16 in the last 3 weeks. ViewZeroOut in TI is not working on string values again - I was pretty sure it was working in 9.4FP2 (as per the fix list) so I removed HF16 just to double check and yep it worked.
Logged this as a bug with IBM and found out that it will not happen if you ensure all your string elements are at the end of the dimension. This is not required in FP2 so obviously it is a bug but at least we know how to work around it.
Re: ViewZeroOut on Strings in 9.4 HF16
Posted: Thu Feb 18, 2010 9:20 am
by Steve Rowe
Hey Jed,
Just to clarify this do you mean the string elements are in the last dimension in the cube or have the highest index in the dimension so they are listed last in that dimension?
Cheers,
Re: ViewZeroOut on Strings in 9.4 HF16
Posted: Thu Feb 18, 2010 10:57 am
by lotsaram
I have also seen this issue. Strange as is sounds the solution is to move all string elements to the end of the dimension. That is if there is a mix of N and S elements then they need to be arranged in index order:
1 N
2 N
3 N
...
n-2 S
n-1 S
n S
Arranging the dimension in this order solves the issue of ViewZeroOut not clearing string values. It also resolves a weird issue where string and numeric values are not displayed properly in views.
I think it is definitely a regression bug but at least there is a workaround.
Re: ViewZeroOut on Strings in 9.4 HF16
Posted: Thu Feb 18, 2010 10:48 pm
by jed
Steve Rowe wrote:Just to clarify this do you mean the string elements are in the last dimension in the cube or have the highest index in the dimension so they are listed last in that dimension?
Yes, I mean that the string elements have the highest index in the dimension and are listed last in the dimension.