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 ment by For each For all function. In which case we use the option in BO?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
what is the difference b/w the refresh and buffered data?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
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.
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
what are the debuggings in the business objects?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
what is crosstab reporting,slice and dise and drill mode??
what do u mean by merged dimensions in Business Objects
2 Answers Business Intelligence Analytics, TCS,
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance