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
- 7573 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 |
What is the profile and package?
is there any limit for rows and columns in cross tab
can you use inputbox in BOXI. e.g. checkbox,textbox etc.
Tell me about linked universe ?
Can anybody tell me about issues faced while creating universe. thanks in advance
Explain difference between zabo and webi?
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....
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
what is the different between link and join ?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
Teradata 
