What is Drill up/down/by/through
Explain what is meant by the Drill up/down/by/through?
Expert
a) Drill mode enables you to analyze the data from several angles and on the different levels of detail.
b) Drill down exhibits the next level of detail in the hierarchy.
c) Drill up goes back up through the hierarchy in order to display the data over the less detailed levels.
d) By using the Drill through the option you may move to the other hierarchy in order to analyze other data which belongs to the different hierarchy.
e) Drill Through - If lowest level of detail you require is not currently available within the report, you may drill through to the database directly from the drill mode and obtain the data you require. You do not need to edit the query within the Query Panel.
Illustrates the recursive stored procedures?
Explain the difference between expression and aggregator?
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Illustrates architecture of reporting services?
In Sybase illustrates the term Table Partitioning?
Specify the System variables?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Why not the PHENIX, the Zelinka or Otwinoski libraries and so forth?
Elucidate what are the tasks which Load manger process will do?
Describe about generating a report tool by utilizing the report tool and the report wizard?
18,76,764
1956674 Asked
3,689
Active Tutors
1447322
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!