12. Report is running very slow and How do you increase its
performance?


13. In infoview, I want to provide the hyperlink to view the
report in pdf format or other format. is it possible to do it.


14. There is one report and need to add new cloumns which
are not there in database. what is your approach.?


15. Did you face any ambiguous queries and how do you fix it?

Answer Posted / gowthami

12. If the report is running slow check the query and correct the problems in joins and loops
Remove unwanted unused objects from report result objects
Remove unused variables from report
Try to use query level filters and not report level filters (Because query level filters restrict the data at DB level itself whereas report level filter allows all data to be executed which will take some time and then it will restrict it at report level)
Try to avoid derived tables at universe which will reduce the performance.

13. I think it is not possible to get the pdf view open through hyperlink. Navigation of one report to another report is possible through hyperlink functionality.
14. You can add columns by following the steps right click  add columns create a variable and assign that in that newly created column

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between business requirement document and use case document.

587


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1402


What is the dense rank?

679


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

695


Can you please send me the migration related issues .

1648






Explain the difference between union and group?

632


Explain how many universes can be created in a project?

617


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

3925


In banking domain how many Fact tables,Dimension table are present?

8383


how to create metric universe ?

1897


Explain what sort of existing documents should business analysts refer to when starting on a new project?

607


Explain which versions are used in the bo dashboard work?

635


What is the difference between slice and dice and cross tab report?

607


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


explain in detail about type 3?

631