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
What is the difference between business requirement document and use case document.
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
What is the dense rank?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Can you please send me the migration related issues .
Explain the difference between union and group?
Explain how many universes can be created in a project?
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??
In banking domain how many Fact tables,Dimension table are present?
how to create metric universe ?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain which versions are used in the bo dashboard work?
What is the difference between slice and dice and cross tab report?
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:
explain in detail about type 3?