Interested to Buy Any Domain ? << Click Here >> for more details...
2.What is loop? How resolve the loop?explain it?
- 11 Answers
- 63902 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
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?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
How would you format some text using css to be verdana and bold?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what is xcelsius architecture?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain which versions are used in the bo dashboard work?
Explain when to use local filter and when to use global filter?
Can we Save (save as) WEBI Doc as DESKI?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
How to open a universe with out using the Designer ??
Which versions are used in the bo dashboard work?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain in detail about type 1?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
