Now, that means when user click on browse button then they have to wait for 5 secs before they can select value. You can see that query took nearly 5 secs. I ran that query in SAP HANA Studio to capture the execution time. Let’s look at the SQL statement captured from Analysis for excel log file. When user click on browse button to select value for “Plant” variable then it generates a SQL statement. When user click on browse button (as shown in above image) then it display these values. This variable will display values from column “Plant” from same information view. Let’s look at the filter variable created in SAP HANA for attribute “Plant”. For example, in following window we have a variable for “Plant”. Usually in SAP HANA we create variables to filter the data in HANA information view at runtime. This performance issue might be faced during consuming HANA information view with large amount of data. In this blog, I will discuss the performance issue which I experienced while selecting input variables/filters (prompts) for HANA information view consumed directly in SAP Analysis for Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |