Problems and Exercises 19 through 26 deal with the Sales Analysis Module data mart available on Teradata University Network (www.teradatauniversitynetwork.com). To use Teradata University Network, you will need to obtain the current TUN password from your instructor. Go to the Assignments section of Teradata University Network or to this textbook’s Website to find the document “MDBM 10e SAM Assignment Instructions” in order to prepare to do the following Problems and Exercises. requested, use course password MDBM10e to set up your SQL Assistant account.
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 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.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.