Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 64583 Views
- TCS, UHG, I also Faced
- E-Mail Answers
Answer Posted / rahul tandon
Loop is a situation in the BO universe design process. A
circular path of joins is formed between the tables. The
SQL queries are not able to interpret the joins; this
results in the wrong results from the queries; often less
records are retrieved than the actual number of records.
A loop situation can be resolved by Aliases and Contexts.
Make sure to break the joins(circular path) by aliasing the
table(dimension table) which has 1n's coming out of it from
both the end. The path then gets broken and ends as two
different path, one ending at the original dimension table
and the other at the aliased table(of that dimension). Both
of the paths now convey a differnt business case scenario
and depending upon the scenario a particlar path(query has
to be fired).
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Explain is there any default username & pwd for bo designer & supervisor?
What are all difference between business objects 6.5 and xi r2?
What is the difference in creating filters in designer and business objects?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What is object stores?
What is the profile and package?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Give some information on report bursting?
Explain how many universes can be created in a project?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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.
explain in detail about type 3?
