How will solve a loop caused by lookup table without using alias?
Answer Posted / prasad
Context or shortcut join can be used to resolve loops.
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
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 the dense rank?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
is it possible to export the webi reports to crystal reports?with out using businessview?
What are all difference between business objects 6.5 and xi r2?
what is xcelsius architecture?
What would you consider as your biggest achievement and why?
What are the join problems comes appart from loop,chasm & fan Traps
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
what will be the contents for a functional requirements specifications
What is the difference between user and versatile user?
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
explain in detail about type 3?