Hi, thank you. i want to selet month number.. because i am display the month numbers in column headers .. month data also i am getting.. if i select month number 10 from column prompt.. current month. @{pro_005}, ie 10 (oct) previous month @{pro_005-1} ie 9 (sep) 10-1=9 then column headings dynamically cahnge if i select…

Hi, As you said, i have tried.. its working fine... using presentation variable & column prompt varaible i have taken... by using this i am getting dynamically column changes based on prompt selection .. and also column data also geting dynamically based on prompt selection... for dynamically changing the column headings i…

Hi, as you said, i have tried.. But i didnt get correct data.. I used unions also.. i didnt get correct. I am getting same results for total outstanding bal, total top 100 outsatnding bal, and %ge share from npl. please see the below screen shot. Please help me Thanks in advance, A.kavya

Hi, I have tried.. I have kept filter on that column.. But I am getting same results for total balance & top 100 total balance.. Please help me.. Thanks & Regards, A.kavya

Hi, In db , if i execute the stored procedure, i am getting data as showing below screenshot.. The same procedure, executing in obiee direct data base request.. i am getting error.. please help me.. how to execute the stored procedure in obiee 11g analytics

Hi, sorry for late reply, as you said, i have tried on that day, its working fine.. I have used like this formulae CAST('31-Jul-' || TRIM(BOTH ' ' FROM CAST( YEAR("F_PL_BAL"."BUSINESS_DATE") AS CHAR) ) AS DATE) Thank you very much, A.kavya

Hi, If i use current_date, its working fine. If i use our table date like CAST( SUBSTRING(CAST("F_PL_BAL"."BUSINESS_DATE" AS CHAR) FROM 1 FOR 4) || '/07/31/' AS DATE) i am getting below error. View Display Error Odbc driver returned an error (SQLExecDirectW). Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State:…

Hi, as you , i have tried , i am getting..output like yyyy/mm/dd. my date is as follows '07/31/' || SUBSTRING(CAST("F_AA_LOAN_DISBURSE"."DISB_DATE" AS CHAR) FROM 1 FOR 4) i want 2015/07/31. please help me, Tahnks in advance, a.kavya

Hi sir, Actually when i opened the analytics report, in that report i am getting following error. To resolve this error i search in google. then i got that two links.. using that link , i didnt make any changes . please help me , Thank in advance, A.kavya view display errorExceeded configured maximum number of allowed…

Hi, As you said, I have tried. Now its coming.. That queries are... Last year first day of current month:: TIMESTAMPADD(SQL_TSI_YEAR, -1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE) ) Last year last day of current month TIMESTAMPADD(SQL_TSI_YEAR, -1, TIMESTAMPADD( SQL_TSI_DAY , -(1),…

Hi @Gianni Ceresa, How to calculate the Last year first day of current month and Last year last day of current month based on current date? Ex:current date= 2015-JAN-08 Last year first day of current month=2014-JAN-01 Last year last day of current month=2014-JAN-31 sorry for creating new thread. Please help , Thanks in…

Hi, Thank you sir..

Hi, I have tried. but i am getting null values. please send any document for this. Please help me.... Thanks in advance, A.kavya.