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
- 7668 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 do you mean by Object qualification?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
what is diff between webi,deski,infoview
Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.
how many times can use the union operator in a report?
There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
can anybody explain me in detail about software development life cycle of business objects in detail?
Anyone suggest where can i get SAP Business Objects dumps for the below: C_BOE_30 C_BOWI_30 C_BOWI_40 C_BOBIP_40 C_BOBIP_41 C_BODI_20 C_BOSUP_90
how to test reports in businessobjects?
how will you move the universe/report from development to production?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
Teradata 
