u drag 2 sources from 2 diff dataproviders,how we take
these 2 sources into 1 single report,
how we give the link these 2 sources
Answer Posted / suvarna
You can do a trick. Suppose u have different objects in
two data providers (lets dpA and dpB),dpA have product
related objects for example product code, product name and
dpB have customer related objects.U drag a object from a
dp, lets take dpA.Now when u try to drag a object from dpB
u will not be able.
For this , go to the tool bar->view data->definations->
link the object u want to drag(say customer name from dpB)
with any object from dpA ->select Ok.Now u will be able to
drag the customer name from dpB. U will see that data
displayed in the report is not correct.Now again go to view
data and unlink the objects->select Ok.
Now u will get the correct data in the report.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
any difficulitis have you phase while creating bo reports and how did u solve it
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
how to create metric universe ?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What would you consider as your biggest achievement and why?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is the difference between datawarehousing and businessintelligence?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain the difference between union and group?
What is top business?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is object stores?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?