Is posible to edit an Online Cube's cell using PivotTable ?

O

odin

I haven't founf the way to allow the edition of Cube's Cell Value , for a
write-enabled Cube that is accessed from Excell or a Web Page using
PivotTable and the Cube is on the Olap Server .

thanks by your time
 
A

Alvin Bruney [MVP]

Pivot table is read-only, you can use separate controls to capture end-user
values and submit to the cube, but that will have to hand-coded.

--
________________________
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
 
S

Saiku

You mean, implement my own component to let the user enter data back,
in other words - I cannot use PivotTable component to write-back?
elsewhere I read that if the underlying fact table contains a primary
key, this can controled by setting PivotView's AllowEdit property to
true. Could you please comment a little more?

Thanks
Sai said:
Pivot table is read-only, you can use separate controls to capture end-user
values and submit to the cube, but that will have to hand-coded.

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


odin said:
I haven't founf the way to allow the edition of Cube's Cell Value , for a
write-enabled Cube that is accessed from Excell or a Web Page using
PivotTable and the Cube is on the Olap Server .

thanks by your time
 
A

Alvin Bruney [MVP]

I haven't played with the allowedit property so I can't help you there.
Maybe somebody else can chime in.

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black book on Amazon and
www.lulu.com/owc
Look out for Excel Services for .NET coming soon
Saiku said:
You mean, implement my own component to let the user enter data back,
in other words - I cannot use PivotTable component to write-back?
elsewhere I read that if the underlying fact table contains a primary
key, this can controled by setting PivotView's AllowEdit property to
true. Could you please comment a little more?

Thanks
Sai said:
Pivot table is read-only, you can use separate controls to capture
end-user
values and submit to the cube, but that will have to hand-coded.

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


odin said:
I haven't founf the way to allow the edition of Cube's Cell Value , for
a
write-enabled Cube that is accessed from Excell or a Web Page using
PivotTable and the Cube is on the Olap Server .

thanks by your time
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top