in report level u find from which context u use,why it
appears,what is the reason,how u resolve in report level
Answers were Sorted based on User's Feedback
Answer / rekha
When a query is ambiguous, BusinessObjects or
WebIntelligence displays a
dialog box that prompts the user to select one of two
contexts. When the user
selects a context, the corresponding tables and joins are
inserted into the SQL
query.
This should be resolved at universe level by selecting
proper options in universe parameters>SQL>Multiple Paths
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / tanvi
Can u clearly specify which amongst the given options should
be checked:
1.Multiple SQL statements for each context
2.Multiple SQL statements for each measure
3.Allow selection of multiple contexts
Since allowing multiple contexts will return incorrect
results i.e. combining results from the queries of both the
contexts
| Is This Answer Correct ? | 0 Yes | 0 No |
what is document design in boxi,have u participate in that
I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same
What is detailed Object
what is local filter
what are the documentations u r created?
What are the data types present in bo? What happens if we implement view in the designer and report?
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
What is maximum number of promts we can give in a BO report?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
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