OWC 11 - Plotting large dimensions in Chart

[Lucas]

Hello,

I' ve a problem with OWC 11.0 chart and it's connected to a pivottable in an
asp page.

I would like to know if there is a way to break or stop the chart refresh
when I 've to much members in the pivot table. If someone know a way, I will
appreaciate.

Thanks

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

So far as I know on this issue, if you specify the data source of one chart component to one pivottable, the data in chart component will refresh
with the change of pivottable. If you want to break the linkage of the two components, you may need to specify the data for chart component
programmatically from pivotTable.

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]

The problem we have is that if we try to plot a large dimension it takes too
much time (and CPU usage). We'd like to know if there is a way to indicate
Chart come kind of limit for the items to draw.
Suppose you have a dimension with 10.000 members. If you put it in the Pivot
Table and the chart tries to plot it, it will take a lot of time and
resources (and the chart won't be understandable). So, is there any way to
specify a limit in the items to plot (suppose, just draw the first 1000 or
just draw when items are below 1000 elements)

Thanks a lot.

Hi Lucas,

So far as I know on this issue, if you specify the data source of one

chart component to one pivottable, the data in chart component will refresh

with the change of pivottable. If you want to break the linkage of the two

components, you may need to specify the data for chart component

 

[Kory Skistad]

I think Microsoft should create a scrollable chart component, similar
to the one used by Intellibrowser (Hungry Dog Software).

If the chart contains 10,000 members, for example, it displays a
horizontal scrollbar at the bottom of the chart, and the user can
scroll to the right to see more.

To increase performance, the chart should only "fetch" as much as can
be displayed at one time. As the user scrolls to the right, it
fetches more data, giving the illusion that it is one continuous
chart.

Just a thought.

Kory

 

[Lucas]

I agree with Kory. Plotting dimensions with a lot of members is a problem
(because it consumes a lot of client time and resources) and the user
doesn't know exactly how many item is he/she plotting until he/she dropped
the dimension (so it's too late).

A Scroll can be a solution, a warning indicating that the items exceed some
limit could be another or directly limit it via some parameter.

Does OWC 2003 give me some kind of alternative in this way?

Thanks

LucasC

I think Microsoft should create a scrollable chart component, similar
to the one used by Intellibrowser (Hungry Dog Software).

If the chart contains 10,000 members, for example, it displays a
horizontal scrollbar at the bottom of the chart, and the user can
scroll to the right to see more.

To increase performance, the chart should only "fetch" as much as can
be displayed at one time. As the user scrolls to the right, it
fetches more data, giving the illusion that it is one continuous
chart.

Just a thought.

Kory

"Lucas" <[email protected]> wrote in message

The problem we have is that if we try to plot a large dimension it takes too
much time (and CPU usage). We'd like to know if there is a way to indicate
Chart come kind of limit for the items to draw.
Suppose you have a dimension with 10.000 members. If you put it in the Pivot
Table and the chart tries to plot it, it will take a lot of time and
resources (and the chart won't be understandable). So, is there any way to
specify a limit in the items to plot (suppose, just draw the first 1000 or
just draw when items are below 1000 elements)

Thanks a lot.



"Wei-Dong Xu [MSFT]" <[email protected]> escribió en el mensaje

Hi Lucas,

So far as I know on this issue, if you specify the data source of one

chart component to one pivottable, the data in chart component will refresh

with the change of pivottable. If you want to break the linkage of the

two
components, you may need to specify the data for chart component

programmatically from pivotTable.

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.

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying!

So far as I know on this issue, I'd suggest you may need to obtain the data source for the chart component from the pivottable component
programmatically. If the dimension is very huge, I'd suggest you can show one warning window for your users before they request the data from
SQL analysis service in your application.

In addition, I think the suggestion from Kory and you are great ideas for a future owc enhancement. I'd recommend that you forward the
recommendation to the Microsoft Wish Program. Microsoft offers several ways for you to send comments or suggestions about Microsoft products.
If you have suggestions for product enhancements that you would like to see in future versions of Microsoft products, please contact us using one
of the methods listed Please feel free to let me know if you have any further questions.

1. World Wide Web - To send a comment or suggestion via the Web, use one of the following methods:
a)In Internet Explorer 6, click Send Feedback on the Help menu and then click the link in the Product Suggestion section of the page that appears.
b)In Windows XP, click Help and Support on the Start menu. Click Send your feedback to Microsoft, and then fill out the Product Suggestion page
that appears.
c)Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm

d)Click Microsoft.com Guide in the upper-right corner of the page and then click Contact Us . Click the link in the Product Suggestion section of
the page that appears.
e)Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.

2. E-mail - To send comments or suggestions via e-mail, use the following Microsoft Wish Program e-mail address, (e-mail address removed).

3. FAX - To send comments or suggestions via FAX, use the following Microsoft FAX number, (425) 936-7329.
NOTE : Address the FAX to the attention of the Microsoft Wish Program.

4. US Mail - To send comments or suggestions via US Mail, use the following Microsoft mailing address:
Microsoft Corporation
Attn. Microsoft Wish Program
One Microsoft Way
Redmond, WA 98052-6399

Each product suggestion is read by a member of our product feedback team, classified for easy access, and routed to the product or service team
to drive Microsoft product and/or service improvements. Because we receive an abundance of suggestions (over 69,000 suggestions a year!) we
can't guarantee that each request makes it into a final product or service. However we can tell you that each suggestion has been received and is
being reviewed by the team that is most capable of addressing it.

All product or service suggestions received become the sole property of Microsoft. Should a suggestion be implemented, Microsoft is under no
obligation to provide compensation. Thank you once more for your wonderful suggestion!

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]

What do you mean with " I'd suggest you may need to obtain the data source
for the chart component from the pivottable component programmatically" How
can I do that?

Thanks

Lucas C

Hi Lucas,

Thank you for replying!

So far as I know on this issue, I'd suggest you may need to obtain the

data source for the chart component from the pivottable component

programmatically. If the dimension is very huge, I'd suggest you can show

one warning window for your users before they request the data from

SQL analysis service in your application.

In addition, I think the suggestion from Kory and you are great ideas for

a future owc enhancement. I'd recommend that you forward the

recommendation to the Microsoft Wish Program. Microsoft offers several

ways for you to send comments or suggestions about Microsoft products.

If you have suggestions for product enhancements that you would like to

see in future versions of Microsoft products, please contact us using one

of the methods listed Please feel free to let me know if you have any further questions.

1. World Wide Web - To send a comment or suggestion via the Web, use one of the following methods:
a)In Internet Explorer 6, click Send Feedback on the Help menu and then

click the link in the Product Suggestion section of the page that appears.

b)In Windows XP, click Help and Support on the Start menu. Click Send your

feedback to Microsoft, and then fill out the Product Suggestion page

that appears.
c)Visit the following Microsoft Web site:
http://www.microsoft.com/ms.htm

d)Click Microsoft.com Guide in the upper-right corner of the page and then

click Contact Us . Click the link in the Product Suggestion section of

the page that appears.
e)Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
and then complete and submit the form.

2. E-mail - To send comments or suggestions via e-mail, use the following

Microsoft Wish Program e-mail address, (e-mail address removed).

3. FAX - To send comments or suggestions via FAX, use the following

Microsoft FAX number, (425) 936-7329.

NOTE : Address the FAX to the attention of the Microsoft Wish Program.

4. US Mail - To send comments or suggestions via US Mail, use the

following Microsoft mailing address:

Microsoft Corporation
Attn. Microsoft Wish Program
One Microsoft Way
Redmond, WA 98052-6399

Each product suggestion is read by a member of our product feedback team,

classified for easy access, and routed to the product or service team

to drive Microsoft product and/or service improvements. Because we receive

an abundance of suggestions (over 69,000 suggestions a year!) we

can't guarantee that each request makes it into a final product or

service. However we can tell you that each suggestion has been received and
is

being reviewed by the team that is most capable of addressing it.

All product or service suggestions received become the sole property of

Microsoft. Should a suggestion be implemented, Microsoft is under no

 

[Wei-Dong Xu [MSFT]]

Hi Lucas,

Thank you for replying!

From my understanding to your issue now, you may need to write codes to get the data you specifed to the chart component. For your
convenience, the sample from OfficeXP toolkit will provide some assistance for you. Please go to:
OfficeXP web component toolkit
http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

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]

Are you talking about to "manually" fill a Chart with data from Pivot Table?
We have done this before. But we must code too much now in order to explode
OWC 11 functionality.
That's why we change to Chart bounded to Pivot Table and that's why we try
to find some way to limit the plotting of large dimensions.

Thanks

LucasC

Hi Lucas,

Thank you for replying!

From my understanding to your issue now, you may need to write codes to

get the data you specifed to the chart component. For your

 

[Kory Skistad]

Here's an idea. Let me know if it sounds like it would work (I
haven't tried it yet)

Embed the chart component within another host control (web browser
control, image control, etc.) Pick a host control that exposes
scrollbars (such as a browser control).

Let the pivot chart expand indefinitely, as it would in a browser.
Although the PivotList control has a property "Auto size the control",
I couldn't find the same property for the PivotChart component. What
is equivilant property for the chart component called? Anyone?
Anyone? Whatever it is called, it should = True.

Now, when you view the Chart in a browser or VB app, you will have the
chart component embedded within another control, and you will use the
horizontal scrollbar of that control.

I plan to test this and see what works best. What I need to know from
the development community that may read this posting is:

What is the PivotChart property that allows AutoSize = True?
What is the property to set the Max Height and Max Width?

I'm guessing you can also use a slider control to adjust the Max Width
property to Expand and Compress the chart to the desired resolution.

Let me know if this solution sounds plausible.

Thanks

Kory

 

[Kory Skistad]

I may have misspoke earlier...

Apparently the ChartSpace object does not support the Autosize or Min
and Max Width properties like the PivotList object does.

And apparently the chart component does not "expand indefinitely" in a
browser, the way the PivotTable List component does either.

I feel the Chart component should behave exactly like the PivotList
component in this regard. Just as the PivotList doesn't "scrunch"
itself within a confined width if a user choses to display 1000
columns (the component "grows" inside the browser window, allowing
scrolling), the chart component shouldn't either.

Kory

 

[Lucas]

The problem I had (and motivated this post ) is about the overhead of making
Chart components plot a large dimension because it forces Pivot Table to
look for all the necessary data. What I wanted to have is some kind of
parameter (or something) that allow me to restrict the amount of "items" to
be plot.

Thanks

I may have misspoke earlier...

Apparently the ChartSpace object does not support the Autosize or Min
and Max Width properties like the PivotList object does.

And apparently the chart component does not "expand indefinitely" in a
browser, the way the PivotTable List component does either.

I feel the Chart component should behave exactly like the PivotList
component in this regard. Just as the PivotList doesn't "scrunch"
itself within a confined width if a user choses to display 1000
columns (the component "grows" inside the browser window, allowing
scrolling), the chart component shouldn't either.

Kory

(e-mail address removed) (Kory Skistad) wrote in message

Here's an idea. Let me know if it sounds like it would work (I
haven't tried it yet)

Embed the chart component within another host control (web browser
control, image control, etc.) Pick a host control that exposes
scrollbars (such as a browser control).

Let the pivot chart expand indefinitely, as it would in a browser.
Although the PivotList control has a property "Auto size the control",
I couldn't find the same property for the PivotChart component. What
is equivilant property for the chart component called? Anyone?
Anyone? Whatever it is called, it should = True.

Now, when you view the Chart in a browser or VB app, you will have the
chart component embedded within another control, and you will use the
horizontal scrollbar of that control.

I plan to test this and see what works best. What I need to know from
the development community that may read this posting is:

What is the PivotChart property that allows AutoSize = True?
What is the property to set the Max Height and Max Width?

I'm guessing you can also use a slider control to adjust the Max Width
property to Expand and Compress the chart to the desired resolution.

Let me know if this solution sounds plausible.

Thanks

Kory





"Lucas" <[email protected]> wrote in message

Are you talking about to "manually" fill a Chart with data from Pivot Table?
We have done this before. But we must code too much now in order to explode
OWC 11 functionality.
That's why we change to Chart bounded to Pivot Table and that's why we try
to find some way to limit the plotting of large dimensions.

Thanks

LucasC

"Wei-Dong Xu [MSFT]" <[email protected]> escribió en el mensaje
Hi Lucas,

Thank you for replying!

From my understanding to your issue now, you may need to write codes

to
get the data you specifed to the chart component. For your

convenience, the sample from OfficeXP toolkit will provide some

assistance
for you. Please go to:

OfficeXP web component toolkit

http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

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.