HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO
YOU LINK THEM?
Answers were Sorted based on User's Feedback
Answer / augustine
Yes. When you pull data from different data souces, if the
dimension name is same then they get linked automatically.
Ex. You have "Month" in one DP1 and Month in another DP2
they get linked automatically. i.e. a Join is created
between the two. If the name is not same then we need to
link them in Data Manager.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sateesh
we have to take two data providers dp1,dp2
first we have to do in webi report
eg in our database emp,dept we have generate two
connections and export it
then
take dp1 ename,dept,sal then run query
after u can click edit query option then u click on
addquery then in the screen appers dilog box with 3 options
in that u have to select any option like 2nd onr then
click ok query2 ename,dept.com then run it
then
in that report panel insert one column then drag and drop
another measure comm
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shiva shankar sheela
you can create different universe for different sources and
link them in BO.
| Is This Answer Correct ? | 1 Yes | 6 No |
What task is 98% of the required work of a business analyst?
I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?
what is custom sorting?how we can do this expalain with procedure???
how can u find the granularity in fact table
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
0 Answers Banking, Genpact, TCS,
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
HOW TO INSTALL BOXI
what is report tracing in bo
what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what are the complex reports you have created. Tell me with example?