Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

i want to calculate amount in current Fiscal Year...

User_BNJK3May 30 2022

i am trying to get amount in current fiscal year 1-july-21 to 30th-june-22
count(case when "W_TIME_DIM"."FISCAL_YEAR" = '2021-22' then "C_INVOICE_DETAIL"."INVOICE_NO" end)
it is my formula but now i dont want to specify year every time. what can i do i am using OBIEE 12c

Comments

Nitin Khare
>
Is it possible to pass a variable instead of providing xml file.
I'm not sure what do you mean by providing xml file. The xmlhttp.open() function usage has to be like:
xmlhttp.open("GET","url",true);
where the url is for the server resource that you are trying to access (usually a file like php/asp/jsp etc.) and true/false flag denotes whether call has to be asynchronous (true) or synchronous (false) which usually passed as true for making typical AJAX calls. Now in case you want to send some additional data to the server then you may pass it through parameters something like
xmlhttp.open("GET","url?param1=value1&param2=value2",true);
Or in case to do a POST like an HTML form post:
xmlhttp.open("POST","url",true);
xmlhttp.setRequestHeader("Content-type","application/x-www-form-urlencoded");
xmlhttp.send("param1=Value1&param2=Value2");
1 - 1