HANA mini checks SQL statement - INPUT parameters modification from Studio

[former_member201054]

Hi Experts,

How can I enter the desired date and time interval while executing the HANA mini checks SQL statement - "HANA Resources CPU And Memory History" from HANA studio. I would say modifying the INPUT parameters according to need.

There is one more statement " HANA_Threads_ThreadSamples_FilterAndAggregation_Rev74+_ESS" for which want to enter the desired date and time interval.

I would appreciate your reply with more details.

Thanks in advance

[dvankempen]

Hi Daniel,

You ask a lot of questions. That is a good thing. Do make sure to tag properly. This question is about SAP HANA. Additional tags are not needed.

Make sure also to tag the correct answer as such and maybe visit some of your previous questions already answered? Thx

daniel.basis#content:questions

===

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[lbreddemann]

To change the selection parameters in those scripts, you have to edit the SQL text.

Many statements have a "configuration section" where you can change the selection and the output options.

Note, that those are literal values, not SQL parameters and that there is no GUI input prompt for that.

[former_member201054]

Hi Expert,

Should I not modify the Begin date and time & End date and time under the [ INPUT PARAMETERS] section in the SQL statement.?

...Please clarify