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?
Answers were Sorted based on User's Feedback
Answer / gs2kumar@gmail.com
Manasa enti ee Nasa qustion enti nuvvu cheppe answer enti?
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / manasa
12A.we increase the performance of the report first of all we resolving join path pbms.These are loops,chasmtrap,fantrap.Resolving these pbms we use alias's for tablas and provide context's for that tables then we resolving join path pbms,after that performance of the record is automtically increses.
13A.In infoview we use hyperlink for navigate from one document other document,from one report to other report,and from one block to other block.
14A.we want to add new columns to the report these are the steps: goto the toolsmenu -> click on new -> create one report after that in resultobjects click at the end of the column of the table -> rightclick -> click on insert new columns to the right.
observe the result on resultsobjects.
Is This Answer Correct ? | 1 Yes | 3 No |
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..
What sort of existing documents should business analysts refer to when starting on a new project?
Explain is data mart?
how many user were there
normally we get many contexts when resolving loops or traps,how do u take them to reports.
How to open a universe with out using the Designer ??
How to create universe in business objects enterprise 11.5
Can Bo generates the Report from the cubical data Explain?