Dashboard multiple Qaaws connection is not working

[former_member221192]

HI,

I have 6 Qaaws connection 5 connection working fine when i add final one connection it is fetching data while running the Dashboard at first time ,if i change the year it is not fetching data again,data remain same it is not fetching

if i use only one connection it is woking fine ,if i use multiple connection it is fetching data at first time if change combo it is fetching..reply as soon as possible

[Former Member]

Hi,

Just try to harcode the prompt value in spreadsheet and preview the dashboard.
Again come out of preview and change the value and preview it again.

Check if this is working fine or no.

[arijit_das]

Did you use the trigger cell properly in the connection refresh settings ?

[former_member221192]

yes ,,properly i am using trigger,,Problem is if i use multiple connection it is not  fetching value ,,if i use single connection  is getting value also data is changing,,

[arijit_das]

Can you check with fiddler if all connections are being processed or not ? Also, you can see the data being retrieved in xml format for each connection.

[former_member221192]

it is solved data is coming after long time,it is taking too much time load,,

[former_member182541]

Enable the "show loading status" in document properties in file menu, to check where it takes long time to load the data.

[Former Member]

Will show loading status help? because it takes time when the dashboard is loaded and when the value for year is changed. Correct me if I am wrong.