2.What is loop? How resolve the loop?explain it?

Answer Posted / srikanth

loop can produce instances of a query where too few rows of data..
by using able aliases and contexts to resolve the loop.
alliases means it breks the loop and it is same as the original table only differ in name..a table occurs twice in the query with the diff purpose.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in sap bi we have wad, then why we go for sap bo

3055


Explain difference between zabo and webi?

849


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1935


What are the steps to do to use alerts in bo?

865


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2188


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

774


Explain is there any default username & pwd for bo designer & supervisor?

795


In banking domain how many Fact tables,Dimension table are present?

8579


Explain what are the steps to be taken to schedule the report?

841


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1940


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3572


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1261


What is a bo repository?

794


Explain how to execute the plsql procedure from the report by clicking with mouse?

826


Explain when we use aggregate awareness function in designer?

786