Bad performance when using many dropdown boxes

[Former Member]

Hi all,

my requirement is to use 10 variables in my VC model. (year, company code, division, key product, material, sales manager, customer, country, currency, industry).

When I configure all 10 as input fields I do not have performance issues. However I must configure them as drop down boxes, and then starting up the dashboard in runtime takes more than 1 minute. This is probably because for all drop down boxes the master data has to be read from BW.

Are there possibilities to speed this up, while still using drop down boxes?

Thanks in advance,

Ralph

[Former Member · Accepted solution]

Hi Ralph

One way to achieve better performance is by splitting these fields into two forms which you can show in a single iview by using Tabstrips. The forms would be inside 2 layers implementing tab strips.

You can keep the event/action button in the last form and do a final save/submit.

This should certainly help.

regards

Navneet

Please revert incase of doubt.

[Former Member · Accepted solution]

Hello Navneet,

thanks for your reply. Regretelly this will not work in my scenario. I am already using tabstrips an would like to have 1 form that contains all dropdown boxes and parses values to all queries in my model.

Best regards,

Ralph

[Former Member · Accepted solution]

Hi

Going by what you have put forth, it looks like you have 2 or many tabstrips in your model.If so, then why don't you try to componentize it by using nested iViews each containing different functionality( i mean tab strips/form). also you could form these nested iViews into Accordions.It gives better visual appeal as well.

I have done this to my scenario and have achieved better performance.

<b>Warning Note</b>:-<u>If you are foreseeing anymore addtional tab strips to your existing model, you may get Flex error(32k size limit) which is nasty and brings along lot of re-work.</u>

Regards

Navneet

Message was edited by:

Navneet Giria

[Former Member · Accepted solution]

Hello Navneet,

that is exactly what I have been doing. I have 8 tabstrips, all containing over 10 chart of tables. Thus at high level I have 1 I-view with an input form and layers that contain a nested I-view per tabpage.

Now the input form contains many drop down boxes which takes too much time to load master data from BW when running the dashboard. Any idea on speeding up this process?

Best regards,

Ralph

[Former Member]

Hi Ralph,

Does your flash compiler is tuned for speed ?

Check if "Data service retrieval" is set for speedy data retrieval.

If you are not integrating in GP , please uncheck the "Add GP information" also.

Also i would have tried 'Entry List Manager' under TOOLS menu of VC story board.