OWC 11 - Create Calculated Data Field

[Lucas]

Hi,
In the Pivot Table toolbar's has disabled the "Created Calculated Data
Field" option. When it became enabled? Is it available in OWC 11?

Thanks

LucasC

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this issue, you want to know whether the "Create Calculated detailed Filed" is still available in OWC 11. From your
scenario, you may find this item in the toolbar is disabled.

This feature is really available in Office web component 11. I'd suggest one MSDN article will introduce this topic for you.
Pivoting Tables: Part I
Use the Office Web Components Pivot Table to See Data from New Angles
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/odc_pivotingtablesparti.asp

In the "Math Whiz" part, it will introduces a lot for you concerning the "calculated-detail fields".

Furthermore, in the OfficeXP web component toolkit sample page PTDemo.htm which is located at %programfiles%\office component toolpack
\Walkthroughs\Pages\PTDemo.htm by default, you can change the class id from "CLSID:0002E552-0000-0000-C000-000000000046" to
"CLSID:0002E55A-0000-0000-C000-000000000046". The difference for the two class id is:
CLSID:0002E552-0000-0000-C000-000000000046
CLSID:0002E55A-0000-0000-C000-000000000046
^
After that, please select "New OWC feature->PivotTable List Demonstration". Then the sample will use OWC11 to perform the demonstration. From
some samples, You will find this feature is really available for the office web component version 11. Since all the source code of this sample is
available, they will help you a lot.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Lucas]

I could make it work when the DataSource is a standard database but it's
disabled when I point it to an Analysis Services Repository.

Any idea?

Thanks

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this issue, you want to know whether the "Create

Calculated detailed Filed" is still available in OWC 11. From your

scenario, you may find this item in the toolbar is disabled.

This feature is really available in Office web component 11. I'd suggest

one MSDN article will introduce this topic for you.

Pivoting Tables: Part I
Use the Office Web Components Pivot Table to See Data from New Angles
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/odc_pivotingtablesparti.asp

In the "Math Whiz" part, it will introduces a lot for you concerning the "calculated-detail fields".

Furthermore, in the OfficeXP web component toolkit sample page PTDemo.htm

which is located at %programfiles%\office component toolpack

\Walkthroughs\Pages\PTDemo.htm by default, you can change the class id

from "CLSID:0002E552-0000-0000-C000-000000000046" to

"CLSID:0002E55A-0000-0000-C000-000000000046". The difference for the two class id is:
CLSID:0002E552-0000-0000-C000-000000000046
CLSID:0002E55A-0000-0000-C000-000000000046
^
After that, please select "New OWC feature->PivotTable List

Demonstration". Then the sample will use OWC11 to perform the demonstration.
From

some samples, You will find this feature is really available for the

office web component version 11. Since all the source code of this sample is

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

So far as I know, this feature will be disabled when the data source is OLAP. If you want to calculate the detailed field when the data source is
OLAP, you may need to create the calculate column in the MDX or directly calculate the column in the SQL Analysis Service. Then you can directly
retrieve them from the OLAP and display for your users.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Lucas]

OK. Thank you.

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

So far as I know, this feature will be disabled when the data source is

OLAP. If you want to calculate the detailed field when the data source is

OLAP, you may need to create the calculate column in the MDX or directly

calculate the column in the SQL Analysis Service. Then you can directly

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying!

It is is my pleasure to be some of service!

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.