Can i merge two dataproviders if they do not have common
column?
Answers were Sorted based on User's Feedback
Answer / madhu
We Merge to data providers to make them compatable and
present columns from both DP's in the report.We do that by
using Merge Dimension in XI 3.1 and Link to option in Data
Manager Tab till XIR2.
We need a common dimension to do soo..
If you try to merge with 2 uncommon dimensions the results
will be in acurate and the Data providers will be
incompatable when you try to place them in the report.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / romit kumar saha
No we cannot. We need to have common columns.
| Is This Answer Correct ? | 5 Yes | 2 No |
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
What is the strategies ? what is the need of the strategies?
what is crosstab reporting,slice and dise and drill mode??
What is the Computation error? how to solv it?
how we improve the performance of report and universe?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
What is the local filter and global filter in bo's?
what is traffic lighting in business objects?
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?
How to change font color of values in hyperlinked columns?