2 table is there , thats column is different name but data
type is same, 2 tables values are same. how to you findout
both values are same?
Answer Posted / chandru
In Designer,
in the file tab-->parameter-->Strategy
we join ---- in the join we have lot option to join .
option are match by column names,match by values etc..
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
U r project in which stage in implementation?
how to prepare the documentation in business objects and where to get the requirement?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain what would you consider as your biggest achievement and why?
How we drill up week to month?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Can we Save (save as) WEBI Doc as DESKI?
Differences between business objects and web intelligence reports?
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
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...
What is package in BO
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference between datawarehousing and businessintelligence?