This content has been marked as final. Show 11 replies
You should first check in the logfile which physical query has been fired to the Oracle Database.
Is this the statement you would expect to be fired?
I checked the log files but unable to identifies the cause of error.
Your error message is typical when you have a query that will return a large amount of data, are you sure your single ORG_ID link is sufficient to produce meaningful results, if you recreated the same query using SQL directly would you get a meaningful result?
more specifically, We are having views called OE_ORDER_LINES_V,OE_ORDER_HEADERS_V , ARFV_CASH_DISTRIBUTIONS, AR_PAYMENT_SCHEDULES_V and one custom Fact table. If generate report with columns from same table then able to generate reports.
If use columns more then one table then getting same error.Please help on this.
"FIN"."".""."Dim ARFV_CASH_DISTRIBUTIONS"."ORG_ID" = "FIN"."".""."Sales Fact"."ORG_ID"
"FIN"."".""."Dim OE_ORDER_HEADERS_V"."ORG_ID" = "FIN"."".""."Sales Fact"."ORG_ID"
"FIN"."".""."Dim OE_ORDER_LINES_V"."ORG_ID" = "FIN"."".""."Sales Fact"."ORG_ID"
"FIN"."".""."Dim AR_PAYMENT_SCHEDULES_V"."ORG_ID" = "FIN"."".""."Sales Fact"."ORG_ID"
Edited by: 867932 on Dec 12, 2011 9:47 PM
Edited by: 867932 on Dec 12, 2011 10:00 PM
increase the table space. and at the same delete the all the cache from the OBIEE.
Can you please provide the steps to increase TEMP table Space in OBIEE.
will you please look at this. this may be help you how to increase the temp table space.
I already checked the link which you provided me. My question is 'is this possible to do in OBI Env?' If Yes,Please share the inputs.Thank you!
There are some views you shouldn't use for querying. These views are optimised by Oracle to retrieve specific records and not for larger volumes. You should try to use the base tables instead. Have a look at etrm.oracle.com. Oracle recommends not to use these views for querying.
These views are custom views contains less then 4k records.Please advise me.Thank you!
You have to ask your DBA to increase the temp table space you cannot do it from OBIEE.1 person found this helpful
What you can also try is to remove any uncessary sorting from your queries because it's done in the temp segment:
NB: please assign point if it's helpful and close the thread when your question is answered