OWC 11 - Grouping Intervals in Pivot Table

[Lucas]

Hi,
The Grouping Intervals functionality is available? What may I do to set it.
Thanks

LucasC

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for posting in MSDN managed newsgroup!

From my understanding to this question, you are going to use the Interval grouping feature of Pivottable. With this feature, we can bucket items into
larger groups so that data is better organized. The users will be easier to find the information they need.

If so, you should set the GroupOn property of the specified field to the OWC constant: plGroupOnInterval. Then based on your scenario, plesae set
the value to the GroupInterval of the specified field so that pivottable knows how to show the interval grouping data. The 4th sample of Pivottable
new feature sample in the OfficeXP web component toolkit will demonstrate this for you. The "showIntervalGrouping()" function in the PTDemo.htm
file will help you a lot. By default, the file is located at:%programfiles%\office component toolpack\Walkthroughs\Pages\PTDemo.htm.

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 question, you are going to use the Interval

grouping feature of Pivottable. With this feature, we can bucket items into

larger groups so that data is better organized. The users will be easier

to find the information they need.

If so, you should set the GroupOn property of the specified field to the

OWC constant: plGroupOnInterval. Then based on your scenario, plesae set

the value to the GroupInterval of the specified field so that pivottable

knows how to show the interval grouping data. The 4th sample of Pivottable

new feature sample in the OfficeXP web component toolkit will demonstrate

this for you. The "showIntervalGrouping()" function in the PTDemo.htm

file will help you a lot. By default, the file is located

at:%programfiles%\office component toolpack\Walkthroughs\Pages\PTDemo.htm.

 

[Lucas]

Does this feature works for OLAP repositories.

Thanks