Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 slice and dice and cross tab report?

1111


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2472


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1057


When we use aggregate awareness function in designer?

1021


How to generate the report from excel sheet?

1246


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

2109


Can we create universe with no cache??

2573


Explain how many universes can be created in a project?

1113


What is the dense rank?

1328


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2046


Explain what task is 98% of the required work of a business analyst?

1175


What is aggregate table and aggregate fact table ... Any examples of both?

1107


How we drill up week to month?

1115


(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.

1577


Explain difference between zabo and webi?

1146