In a report i want to fetch teh data from 2 data Providers.
which condetion wil satisfy to link the 2 data providers.

ex: Q1 have columns A,B,C
Q2 has a X,Y,Z columns.

requirement is like i want to get all the columns from
those 2 tables in report level..like A,B,C,X,Y,Z in a
single report.

Answer Posted / swetha

You can do by synchronising both data providers i.e.
you need to use LinkTo command buttion in ViewData option
by matching corresponding dimensions that have the same
data type.

by default Null Values also placed in the report.then you
can use NotIsNull option to avoid Nulls.

Thanks,
Swetha

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is aggregate table and aggregate fact table ... Any examples of both?

615


What is the difference between user and versatile user?

585


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?

1779


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9441


What is a bo repository?

596






What are all difference between business objects 6.5 and xi r2?

607


What is the difference between business requirement document and use case document.

587


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

1433


Explain how many universes can be created in a project?

620


What task is 98% of the required work of a business analyst?

581


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!!!

1761


What is package in BO

2687


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2404


What is difference between custom hierarchy and report based hierarchy?

553


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

1911