Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 7457 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / saurabh
In my understanding you have to use deski not webi for free hand sql .in deski there is no bar for this you can design on your own way....not possible in webi (even if u use custom query also)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Where will you find the address of repository in Business Objects?
Can master data change???if yes then how it'll change.....please explain with example...... thanx
how we transport universes from business objects 6.5 to BOXI R2?
5.what is slowly changing dimension ?
Can any body tell me,What is the universe testing ? What is the report testing Explain?
When we are going for Shortcut join and why.
How to Implement the the Built-in Strategy Script in BO Designer?
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
can anybody explain me in detail about software development life cycle of business objects in detail?
HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
How to Analyise 'Join' problem and which method is the best to resolve that ?
Teradata 
