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
Answer Posted / gowthami
You can get the 7th column data also in the report by using free hand sql by following the below steps
assume name of the 7th column is "new"
1.Add some dummy object and go to sql and remove the dummy object field name and put your actual "new" field name
1a. if the dummy object and "new" column is from same table
then no need to change the where clause of sql query
1b. if the dummy object and "new" column is not from same table then need to update the correct join condition in where clause of sql query
2. check 'donot generate sql query based on the result objects'
3.run the report
this way is not advisable. you have to create a object in universe and use it in a report
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is universe null
Explain about a tricky situation for which you found a very simple solution?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain difference between zabo and webi?
Explain how to execute the plsql procedure from the report by clicking with mouse?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is xcelsius architecture?
Which versions are used in the bo dashboard work?
What is object stores?
What is thumbnail?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Can anybody tell me what are the tuning problems?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Can more than 1 metric be applied on an analytic in business objects?