Database Memo I wanted to review the database tools we have at our disposal and explain what each is for, when each is appropriate, and some improvements we are pursuing to make these tools easier to use and more powerful. For the sales organization we have three database options available; Hyperion®, Access®, and our most widely used tool, BusinessObjects by SAP.Hyperion: This database is less understood by the sales team because Hyperion® is only used to collect financial data (Pinnacle Titan Technology Partners [Titan], n.d., p 1 ). As a sales team we only use it once a year to create our annual sales and operating budgets. The system is not easy for us to use, due to its layout and duplication of data lines. However, the database is designed to collect and generate reports for accurate forecasting, monitoring and reporting of corporate finance. This system generates everything from trial balances and audit reports to the reporting required for Sarbanes-Oxley financial statements (Titan, n.d., p. 2). So while it's harder for us to use it once a year, it meets many more financial requirements year-round. In an effort to make this system easier for all of us to use, there are some changes that the management team has recommended to institute. Duplicate line entry points are the most frustrating and problematic in the budgeting process. We have required that sales and margin values be separated by product grouping and our program name so that we can validate accurate forecasts and data entries. Because Hyperion® uses general ledger account numbers, we often have budgeted items in the wrong accounts. This creates problems in budget reconciliation and in some cases err...... middle of paper...... will improve the tool for immediate needs while creating an additional benefit for selling future services. The database applications discussed bring value to our organization. We want you to feel comfortable using each and know which one you should use for a given application. At the same time these tools help us better manage our business, we must take appropriate measures to ensure that the data presented is complete and accurate for its intended purpose. Using the tools will make you more competent and continue to bring value to you, your customers, and your company. Works CitedMicrosoft. (n.d.). Improve the performance of an Access database. Retrieved from http://www.microsoft.comPinnacle Titan Technology Partners. (n.d.). HyperionFDM. Retrieved from http://www.pgww.comSAP. (n.d.). Crystal Reports Server. Retrieved from http://www.sap.com
tags