Interested to Buy Any Domain ? << Click Here >> for more details...
why less number of records in loop?
why more number of records in traps?
- 1 Answers
- 3391 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / manveer
More no of records in trap because:
For example:
A >- B -< C
( Employees >-- Showroom --< Salary)
- Each showroom has many employees
- Each showroom has many annual salary figures
The number of employee records should not impact the total salary on the report.
If a query is written that spanned all three of those tables the data from table A and C, there would be duplicated and the measure values would be exaggerated. For example,
- X rows on the left
- Y rows on the right
- X * Y rows in the combined set
Less no of records in loop as there is an extra join in a loop, that means one more restriction to the data. That extra join filter out the data and restrict the no of rows retrieved
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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:
Give some information on report bursting?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What is the difference between condition & filter?
how to create metric universe ?
how many reports have u created ? explain a few.
Can more than 1 metric be applied on an analytic in business objects?
What is the difference between slice and dice and cross tab report?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how get the grand total in master-detail report?
What are the steps to do to use alerts in bo?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
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
Explain what is the difference between slice and dice and cross tab report?
