1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

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

Question Posted / ayan

Answers were Sorted based on User's Feedback



I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so..

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

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so..

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

Post New Answer

More Business Objects Interview Questions

What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except

2 Answers   Nucleus Software,

how can u find the granularity in fact table

1 Answers   iGate,

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

Hi any done business objects certification.i am expecting some help from them.

6 Answers  

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,




am a fresher hw to get real time experience?

1 Answers   Cap Gemini,

How can you check the universe?

3 Answers  

Can we create universe with no cache??

1 Answers  

Explain what would you consider as your biggest achievement and why?

0 Answers  

When we are going for Shortcut join and why.

1 Answers   Cap Gemini,

Explain about derived tables?

2 Answers   Cap Gemini,

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

For more Business Objects Interview Questions Click Here
Categories