Thanks Gianni, After changing the URL to below from the webservice side, i can pass the parameter value in the parameter box of my action set and can get the results in the excel download. http://172.16.2.85:9704/Application11-ViewController-context-root/jersey/excel?year=@{year} My next challenge is i need to pass this…

Gianni, If thats the case then i need to change the URL interms of accepting query part like something http://172.16.2.85:9704/Application11-ViewController-context-root/jersey? so that i can subsitute year paramater for the above query part of my URL. Is my understanding is correct. Saro

Dear Gianni, Where is this action set? >> I just created this action set directly and executed it from the saved catalog. Where does the year come from? >> As of now im giving the year directly as a value in the parameter box in the action set instead of giving it in the url directly. You mean you have that in an analysis…

Hi Gianni, If i invoke it in the web page with hardcoded parameter value 2009 than i can get my Excel sheet download with 2009 records, if i pass the url directly with the value like below http://remco.biapps.com:9704/Application11-ViewController-context-root/jersey/2009 But instead if i pass the value @ runtime then it is…

Oops, sorry for the wrong word. Thanks for letting me know about the Facts:-) Saro

Thanks Gianni and Angel for your opinions.

Hi Berg, Thanks for the reply. Custom link Export case is not possible like you have said and that is fine. My second thought option is: Is it possible to control the std export limit rows based upon the user. Like, for an example: If User A exports the report, it need to export only 2500 rows(irrespective of the number of…

w.r.t to time series for its abnormal behaviour, the wrong formation of chronological key is the main reason in my case. Regards, Saro

Hi Robert, The problem is because of wrong formation of time series calculation. After correcting the time dimension with the proper chronological key, the measures are appeared fine. Thanks, Regards, Saro

Hi Robert, I tried that also, but it results in the same way of behaving like an attribute. Regards, Saro

Hi Asim, Yes it is not aggregating properly in the union analysis. This is happening only for the time series measures(That too in the union analysis). But for the measure without any time series formula it is working fine. What could be the issue with the time series measure in the union analysis. Regards, Saro

Hi Asim, In my formula ifnull(TODATE("Fact_GL_balances"."Revopex BI Forecast", "Dim2_GL_periods"."2-Time"."Year"),0), i have my Forecast column with an aggregation rule of sum in both criteria. Regards, Saro

This syntax dint work joel ('@{v_period}['@']') Saro

Thanks christain and asim for your time/replies. Regards, Saro

Hi Asim, Im using obiee 11.1.1.7.150120. Why not find the last occurance of , and then take a substring from it? How can i do that. Kindly explain it. Thanks, Saro

Hi christian, This is what my real scenario and hence inorder to tackle this only im finding to get the string values in a variable inorder to use substring to get the last month name alone. Saro

Hi Gianni, If you set your prompt to also store the selected values in a presentation variable it will just do it by itself. The variable will have all the selected values. Yes i have a presentation variable assigned to the column period called v_period. What im trying to do is, suppose if i select multiple values in my…

Hi Asim, I mean the file name needs to be the Title view name which is inside the report. Regards, Saro

Hi Asim, Thanks for the reply. You mean that it will not work if i export in csv format and only with Excel export it will work. Even i tried by exporting in Excel. Soon after clicking the export link i can see the pop up appears open, save, cancel but that pop up shows the report name that i have given in the catalog, but…

Thanks Gianni, I used the below like you said and it worked FILTER("Fact-Capex BI"."Budget" USING (("Dim-Capex BI"."Year" IN ('FY'||cast(cast(substring(cast(2017 as char) from 3 for 2) as numeric)+1 as char))))) Regards, Saro