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
- 7465 Views
- I also Faced
- E-Mail Answers
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
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?
Is there any other repository domains rather than universe, security, document?
What is the dense rank?
What are all difference between business objects 6.5 and xi r2?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
what is the difference b/w the refresh and buffered data?
How to execute the plsql procedure from the report by clicking with mouse?
What is the difference between the public object&schema object?
What is the difference between datawarehousing and businessintelligence?
How to open a universe with out using the Designer ??
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
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
