RE: OWC11 Pivot Table has problem when i use LastChild functions

Hi Luze Zhang.
Thank you for fast response. The problem will resolved if i remove the
custom rollup formula or if i set pivot table control always display empty
item row and columns. however that is not what we want..

If the Time.Currentmember.LastChild contain an empty, that means when
looking at the higher level, the OWC11 Pivottable will display "error
message". meaning to said that higher level should be "Empty in Total" but
when expanded, you can see the data somewhere in the cell but NOT the last
child, which is valid.

*The data/Cube is valid as it work fine in Excel 2003 Pivot Table. No error
message.
*Can OWC11 bypass the message and continue to display the result?

Regards
Wizard@TCK


"Luke Zhang [MSFT]" wrote:

Hello,

This problem may be related to the actual data from the data source, have
you confirmed if the problem will be resolved if you remove the custom
rollup formula "Time.Currentmember.LastChild"? Also, you may set the Pivot
Table control always display empty rows and columns, can this remove the
error message, and display some empty cell? If so, you may check the cells
to see what data cause the problem.

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.




.

Relevant Pages
Loading