OWC11 Pivot Table has problem when i use LastChild functions

[Wizard@TCK]

I'm using OWC11 Pivot Table connect to Ms analysis 2000. When i set the
custom rollup formula to "Time.Currentmember.LastChild" purpose to get the
current stock balance instead of sum. The cube is valid and the result is
fine in Excel 2003 Pivot Table. However when i use OWC11 Pivot Table in VB.
The OWC11 pivot table is not stable and give me error message of

"The pivot table list cannot display all of the data. One of the reasons
could be that the data contains an empty item that has non-empty child items.
Either set the option to display empty rows and columns, or alter the data do
that there are no empty items with non-empty child items."

Can somebody please help !!!

 

[Luke Zhang [MSFT]]

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.

 

[Wizard@TCK]

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]]

Hello,

WOuld you please provide me a sample which can reproduce the problem? For
example, some actaully data and the VB project? With these, I can perform
further research on this issue to see if there is any work around for this.
You can send this to me by email. (please remove "online" to get my actual
email).

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.