OWC 11 Pivot Table and SSAS 2005 Cube

[YH]

Hi, there,

I created a VB6 apps that use the OWC 11 pivot table control. The pivot
table retrieves data from a SSAS 2005 cube. I have no problem in
retrieving the data to the pivot table.

I move further to try making the pivot table editable but to no avail.
I set the .AllowEdits of the active pivot view to TRUE but somehow, I
still don't manage to edit the content of the detail field. I am not
sure whether this is supported by OWC 11.

I intended to perform some write-back to the olap cube. I can do this
in Excel pivot table but in OWC, I have yet to be able to do it. You
must be wondering why I still need OWC to do the write-back? This is
because of the row limitation in Excel and Excel pivot seems to be very
slow (sometimes, just freezed) as we drag more dimension member. OWC
don't have these problems and the refresh is acceptable unlike Excel
which is simply unacceptably slow.

Any help will be appreaciated.

Thank you.

Regards,
Yong Hwee

 

[Alvin Bruney [MVP]]

As far as I am aware, the pivot table in OWC does not allow write-backs.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin

 

[YH]

Hi, Alvin,

Thanks for your reply. I found no other properties to set the pivot
table to allow editing besides the .AllowEdits. Even set to TRUE, the
pivot table still does not allow editing. It's OK then.

But, I was wondering why the pivot table in Excel and the pivot table
in OWC work differently? OWC pivot table simply retrieves faster than
the Excel pivot table.

Thank you.

Regards,
Yong Hwee

As far as I am aware, the pivot table in OWC does not allow write-backs.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi, there,

I created a VB6 apps that use the OWC 11 pivot table control. The pivot
table retrieves data from a SSAS 2005 cube. I have no problem in
retrieving the data to the pivot table.

I move further to try making the pivot table editable but to no avail.
I set the .AllowEdits of the active pivot view to TRUE but somehow, I
still don't manage to edit the content of the detail field. I am not
sure whether this is supported by OWC 11.

I intended to perform some write-back to the olap cube. I can do this
in Excel pivot table but in OWC, I have yet to be able to do it. You
must be wondering why I still need OWC to do the write-back? This is
because of the row limitation in Excel and Excel pivot seems to be very
slow (sometimes, just freezed) as we drag more dimension member. OWC
don't have these problems and the refresh is acceptable unlike Excel
which is simply unacceptably slow.

Any help will be appreaciated.

Thank you.

Regards,
Yong Hwee

 

[Alvin Bruney [MVP]]

These are different objects, they may look the same but they are different
underneath.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi, Alvin,

Thanks for your reply. I found no other properties to set the pivot
table to allow editing besides the .AllowEdits. Even set to TRUE, the
pivot table still does not allow editing. It's OK then.

But, I was wondering why the pivot table in Excel and the pivot table
in OWC work differently? OWC pivot table simply retrieves faster than
the Excel pivot table.

Thank you.

Regards,
Yong Hwee

As far as I am aware, the pivot table in OWC does not allow write-backs.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

Hi, there,

I created a VB6 apps that use the OWC 11 pivot table control. The pivot
table retrieves data from a SSAS 2005 cube. I have no problem in
retrieving the data to the pivot table.

I move further to try making the pivot table editable but to no avail.
I set the .AllowEdits of the active pivot view to TRUE but somehow, I
still don't manage to edit the content of the detail field. I am not
sure whether this is supported by OWC 11.

I intended to perform some write-back to the olap cube. I can do this
in Excel pivot table but in OWC, I have yet to be able to do it. You
must be wondering why I still need OWC to do the write-back? This is
because of the row limitation in Excel and Excel pivot seems to be very
slow (sometimes, just freezed) as we drag more dimension member. OWC
don't have these problems and the refresh is acceptable unlike Excel
which is simply unacceptably slow.

Any help will be appreaciated.

Thank you.

Regards,
Yong Hwee