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 slice and dice and cross tab report?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
When we use aggregate awareness function in designer?
How to generate the report from excel sheet?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Can we create universe with no cache??
Explain how many universes can be created in a project?
What is the dense rank?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain what task is 98% of the required work of a business analyst?
What is aggregate table and aggregate fact table ... Any examples of both?
How we drill up week to month?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain difference between zabo and webi?