how can we retrieve particular number of rows from data ware
house?for EX: my report want to displayed with 10 records in
a report??how
Answer Posted / rohan
While creating the report you have an "OPTIONS" tab at left
hand side bottom. Please open that nad set the number of
columns you need to display in the report.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Give some information on report bursting?
Explain how to schedule the report in b.o?
Explain is there any other repository domains rather than universe, security, document?
What we need to discuss with designer before starting the universe designing.
what are the day to day activities of BO administrator ?
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...
How to schedule the report in b.o?
Explain what is the difference between slice and dice and cross tab report?
What are the join problems comes appart from loop,chasm & fan Traps
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
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?
In banking domain how many Fact tables,Dimension table are present?
How many universes can be created in a project?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
How to create Index to the table in the universe designer and how it improves the Query performence