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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

U r project in which stage in implementation?

1950


What are the join problems comes appart from loop,chasm & fan Traps

1556


what is universe null

1991


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1400






Explain how many universes can be created in a project?

615


How to schedule the report in b.o?

564


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


What is the difference between condition & filter?

607


When we use aggregate awareness function in designer?

552


Explain how to schedule the report in b.o?

566


Which versions are used in the bo dashboard work?

603


What are the data types present in bo? What happens if we implement view in the designer and report?

622


What is a bo repository?

594


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1756