Question: The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business

The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business intelligence tools generate SQL to retrieve the data they need to produce the reports and charts and to run the models users want. Go to the Apply & Do area on the Teradata University Network main screen and select MicroStrategy, then select MicroStrategy Application Modules, and then the Sales Force Analysis Module. Then make the following selections: Shared Reports -» Sales Performance Analysis -» Quarterly Revenue Trend by Sales Region -» 2005 -» Run Report. Go to the File menu and select the Report Details option. You will then see the SQL statement that was used, along with some MicroStrategy functionality, to produce the chart in the report. Cut and paste this SQL code into SQL Assistant and run this query in SQL Assistant. (You may want to save the code as an intermediate step to a Word file so you don't lose it.) Produce a file with the code and the SQL Assistant query result (answer set) for your instructor. You have now done what is called screen scrapping the SQL. This is often necessary to create data for analysis that is beyond the capabilities of a business intelligence package.

Step by Step Solution

★★★★★

3.50 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Most BI software generates SQL to retrieve the data from a database to do the analysis requested in the report or graph SQL may not have the output fo... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

613-CS-DB (1955).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...

J. Paul Getty was an American industrialist who made his fortune in the oil business. He made his first million at age 25 in 1916, and later became the world's first billionaire. Getty viewed art as...

If you need a hard-to-find automobile part for a European import, you could probably find it in a catalog published by the ETAI Group in France. The ETAI catalog includes over 30 million parts for...

. The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business intelligence tools...

The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TUN. Most business intelligence tools...

Take the query you scrapped from Problem and Exercise 22 and modify it to show only the U.S. region grouped by each quarter, not just for 2005 but for all years available, in order by quarter. Label...

The database you are using was developed by MicroStrategy, a leading business intelligence software vendor. The MicroStrategy software is also available on TSN. Most business intelligence tools...

Case Study World Bank: Behind the I.T. Transformation Baseline Magazine To provide technical assistance and developmental knowledge to fight poverty and disease, the World Bank first had to overhaul...

These are the applications that will form the scope of this year's audit: SAPHandles all accounting and general ledger transactions. SAP's server is SapAppServ1, and its operating system (o/s)...

Communications of the Association for Information Systems Volume 15 Article 5 1-26-2005 Outrigger Hotels and Resorts: A Case Study Gabriele Piccoli Cornell University, gp45@cornell.edu Follow this...

Derive the mathematical relationship between v(t) and i(t) using KVL and/or KCL for the following circuit. (Points: 10) v(t) (+ - R=1 Q W i(t) C = 1 F L = 1 H v(t) +1 i(t) = 1 H (b) C = 1 F R = 10

Oblique asymptote y = x - 1?

What is the advantage of using an uncoded format for a scale variable in a questionnaire, rather than coding it into groups?

Draw graphs to illustrate the difference between a decrease in quantity supplied and a decrease in supply for condominiums. Give a possible reason for change in each graph.

What is fragmentation transparency?

Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customers of rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named...

Create a class diagram for the Premiere Products database, as shown in Chapter 1, Figure 1-5. If you need to make any assumptions in preparing the diagram, document those assumptions.

2) Peter is a salesman for Kroner industries which specializes in making of natural gas furnaces. Peter has told you that your current furnace needs to be replaced and he offers the following...

Sims & Company is brainstorming on if it is a good idea to invest in a short-term installation project. The investment has the following projected cash flows seen below: Required Initial Investment...

Prepare a Cash Budget for the months of January to March 2019 6 Sales information for November and December of 2018 and Sales forcast for January to March of 2019 are as follows 8 November (2018)...