Hi All, My query take long time for running query/report. How to manage time for running fast report/query?

lionskashif

 Profile Answers by lionskashif Questions by lionskashif

• Aug 28th, 2012

Query Performance: I would say you should check first SQL and run against directly to the database and note that it is taking the same time to fetching the data. 2) Try to avoid extra prompt in your r...

Krishna

• Dec 1st, 2011

Check your Sql Query for all Data providers in your report

In Groupby is there any measure you have.

If you have measure objects in groupby then it will take too much time run the report.

Answer Question  Select Best Answer

Aditya

• Dec 7th, 2014

Section is a master and detail functionality in Bo. It slice and dice the report. It divides the report into separate blocks.for example we have year, emp name, salary and if we apply section on year....

shashank

• Dec 13th, 2012

Section provide the analysis in sub group vise, suppose we have thee column country, region, revenue, if we apply section on country the table structure change (table structure not change in break) an...

Answer Question  Select Best Answer

VigneshRajagopal

 Profile Answers by VigneshRajagopal Questions by VigneshRajagopal

• Jun 21st, 2011

If the join between two table in structure pane is double clicked we get an popup window where in we can specify the cardinalities and joins(left outer join)

Amjad

• Nov 13th, 2007

While detecting the cardinality relationship between  two tables,you find two tabs one is right outer join and the other is left you need to select out there.

Answer Question  Select Best Answer

Ankit Sahu

• Jun 18th, 2015

Yes it is possible to achieve this by using a merge dimension concept. Create 2 different queries for both the data providers and then create a merge dimension on a common dimension, and then create a single report .

Anyone

• Oct 19th, 2011

Yes the 2nd one is possible only if it is R3(i.e external source).

Answer Question  Select Best Answer