Any Ideas?

Dear Sagar, I have managed to find it through one of the logs. It is shown below. [2016-05-09T17:17:11.355+08:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 1c18] [messageid: USER-0] [requestid: 515000c] [sessionid: 5150000] [username: admin] ############################################## [[ -------------------- SQL…

Thank Andrei for your tips. You re correct in that I am trying to start the report from the catalog and wish to remove it from there and NOT from the dashboard prompt. Is there any way to do so? Or Am I stuck with the labels forever? Thanks

Thanks for your reply Andrei. However, where I put the HTML? To clarify this is not a dashboard prompt, this is an analysis prompt. I have tried to input it into the settings, but it doesn't do anything. Please Help

Dear Sagar, Thanks for your reply. I don't know what you mean by Physical SQL. I did a search and found this in the log. SET VARIABLE SAW_SRC_PATH='/shared/COMMON/UCDPMT';SELECT 0 s_0, "VALID V EUC"."Ucdpmt"."Height from dimension" s_1, "VALID V EUC"."Ucdpmt"."Height to dimension" s_2, "VALID V EUC"."Ucdpmt"."Left hand…

Dear Sagar, Thanks for your reply. The SQL below is if i don't input anything, and just press OK. SELECT 0 s_0, "Business Area : VALID IV EUC"."Ucdpmt"."Txn date" s_1 FROM "Business Area : VALID IV EUC" ORDER BY 2 ASC NULLS LAST FETCH FIRST 65001 ROWS ONLY If I press a value, it would give me the no result message. I am…

Okay sure, The picture below is the result of the table I have selected. I have configured a prompt for it, with the operator for "equal" as shown below. So Using one of the dates from the first picture, I inputted into the prompt as shown below. Supposedly, it should only show that data. However, it gives me that no…