Question: Management would like to use the data mart for drill-down online reporting. For example, a sales manager might want to view a report of total

Management would like to use the data mart for drill-down online reporting. For example, a sales manager might want to view a report of total sales for an agent by month and then drill down into the individual types of policies to see how sales are broken down by type of policy. What type of tool would you recommend for this? What additional tables, other than those required by the tool for administration, might need to be added to the data mart?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database Management Systems Questions!

Management would like to use the data mart for drilldown online reporting. For example, a sales manager might want to view a report of total sales for an agent by month and then drill down into the...

Fitchwood management would like to use the data mart for drill-down online reporting. For example, a sales manager might want to view a report of total sales for an agent by month and then drill down...

. Fitchwood management would like to use the data mart for drill-down online reporting. For example, a sales manager might want to view a report of total sales for an agent by month and then drill...

1-22 through 11-28 are based on the Problems and Exercises 11-22 through 11-28 are description of the Fitchwood Insurance Company that was in duced in the context of Problems and Exercises 9-46...

Final Paper Instructions/Guidelines: The final paper must be a minimum of 5 pages and a maximum of 7 pages in APA format. You can find APA guidelines in the Week Six folder under final paper tips....

Mehdi's Department Store Case background Hassan Moe, the Manager at Mehdi's, understands the importance of a department store's sales force, especially when it comes to the sales force of a premiere,...

THE CASE T he Tasteless Tea Company (hereafter, Tasteless) is a market leader in the expanding U.S. market for tea (processed tea leaves), tea-related consumer beverage products, and tea- 1 related...

The OB/HR Matrix Organisational Behaviour Concept HR Management Function The Link to HR Management Organisational Culture Employee Involvement and Relations Ethics Management Organisational Design...

Answers should be 250 words long and not copied from somewhere else. Write it in your own professional words. References should be provided if material used from outside. I have attached pictures...

Transaction Number 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Last Name Enriquez Carder Angelo Bibb Rodman Matchtolff Macnai Mensik...

A company is using the Economic Order Quantity (EOQ) model to manage its inventories. Suppose its annual demand doubles, while the ordering cost per order and inventory holding cost per unit per year...

At the beginning of the current season, the ledger of Highland Tennis Shop showed Cash $2,500; Inventory $1,700; and Common Stock $4,200. The following transactions were completed during April. Apr....

A self - assessment can tel you whether or not you should be a manager and if you "Thare what if takes." True False

Phoenix Plastic Inc. has accumulated the following data over a six-month period: Separate the machine-related costs into their fixed and variable components, using the high-lowmethod. Machine Hours...