Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Loading In The EXCEL Automatically

Hi All,

I had Creates Dash Board with Universe and QAAS connections


I had Kept the Option  Refresh Before the Component Load


As a Result every time users Access the Dash Board it is taking the Query Execution time in order to Populate Dash Board

Query is taking Longer time to Run

As This is a Monthly Reports is there Any Way that we can Automate the Query Every Month to Populate the Result set in Excel

So it wont take too much time to populate the Result set when the user switch Between tabs in BI Work Space

Or is there Any best Way

Please Advise ,

Thanks,

Krishna.

Tags:
Former Member
Former Member replied

Finally Found the solution for Data loading in Excel Automatically

Solition :

Create Webi Report with universe

Create a QAAS Link with Webi Report

and use that Link For creating the Dash Board

then Schedule the WEBI Report

Connection Options :and Kept the Options : Getfromlatest intance =1 in Dash Board Options from Inputs

in isSheduled Option = TRUE in Outputs

This way you can get the scheduled instance data Very Quick to the Report

and Keep the option Refresh on Open in Connection

Thanks

Krishna .

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question