Hi Salman, but why i m getting the DWH database has been closed. why the weblogic is closing the session.

hi Gianni, we can understand but would there be any workaround while playing with css statementas below:- < script type="text/javascript"> var tds = document.getElementsByTagName("td"); for(var i = 0; i < tds.length; i++) { if(tds.innerText == "Value Total") { tds[i].parentNode.style.display = "none"; } } < /script> but…

but if I use calculated items and I have ine more column after emp name say emp id if I use total of that emp name its repeating for all the emp id

hi gianni, i tried to lookup into the usage tracking subject area we observed only reports related to section condition are working other analysis records are not inserted into the s_nq_acct table. can you please let me know reason.

hi, yes we have 2016 as default value in dashboard prompt and so forth we have data related to these intersection in db

Hi, my requirement is that i have some columns in prompt and there we have written sql query so its sql based prompt and also in our prompt there are some columns which are directly coming from subject area and that columns are limited by some other column. so what happen is when i select any value say for ex year ='2016'…

one more question is there any way to run physical sql in obiee analytics and create report apart from that

so, suppose seed the direct db request analysis so would it fetch fresh data from db or it will fetch from cache

so, whether cache seeing is possible or not using direct db request analysis

we trying to generate the cache entries for the direct database request analysis using cache seeding

hi, actually we are facing issue as "Exceeded configured maximum number of allowed output colunns,rows ,section" so to remove these error we have set the limit as ony 200 records in table and while exporting we should be able to see whole data as you are saying if i try to export the whole data in second analysis then it…

yes we are on dev

hi, i have one question if we increase no of max visible section from 500 to say 5000 and cube max records to 1000000 then whether obiee will put load on server /impact the performance

to remove this error as Exceeded configured maximum number of allowed input records we just one to show 200 records so as while exporting we can see more records in different format .

hi, we dont want to increase the section size in the instanceconfig.xml file as its impacting the performance of obiee . so what we have new req is just show 200 section in report level and if suppose we have more than 200 section records then while exporing it should show all the records in the export. please let me know…

can u give me the steps because i m not ablle to access this doc

hi, i have recreated the report next time but the error still exist

in rpd, if you go the logical table source in the table -> content tab-> check on select distinct values option -> save it and try to see the results now

recreating is the solution but if we have couples of reports where wwe ae getting this error again and again then we need workaround for this

but its not recreated