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
- 7671 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
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What would you consider as your biggest achievement and why?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain what are the steps to do to use alerts in bo?
Can we Save (save as) WEBI Doc as DESKI?
Can more than 1 metric be applied on an analytic in business objects?
Explain when we use aggregate awareness function in designer?
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)?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain about a tricky situation for which you found a very simple solution?
What is the profile and package?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
What are the steps to be taken to schedule the report?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
