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

[VivekSahu]

Hi Daniel,

All these SQL statements, have a /* Modification section */ , that enables you to choose certain user defined parameters. Do not change anything outside this section, and you will get the results accordingly.

Best Regards,
Vivek Sahu

[former_member201054]

Hi Experts,

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

...Please clarify

[AtulKumarJain]

Hi Daniel,

Yes,you can modify the begin date and time and end date time,so you can narrow down the search creteria and get most accurate result .

Best Regards,

Atul

[former_member201054]

Hi Experts,

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

...Please clarify

[VivekSahu]

INPUT parameters are just for your reference, like what can you use in /*Modification section*/ and in which format. Whatever changes or customization is expected, do it inside the /* Modification Section */ only.