blog




  • Essay / Database Memorandum - 1227

    Database Memorandum I wanted to review the database tools we have 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: Hyperion®, Access® and our most widely used tool, BusinessObjects by SAP. Hyperion: This database is the least understood by the sales team because Hyperion® is only used to collect financial data (Pinnacle Titan Technology Partners [Titan], nd, 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 gather and generate reports for financial forecasting, tracking and accurate reporting. This system generates everything from trial balances and audit reports to the reports required for Sarbanes-Oxley financial statements (Titan, nd, p. 2). Therefore, although it is more difficult to use once a year, it meets many more financial requirements throughout the year. In an effort to make this system more user-friendly for all of us, the leadership group has recommended some changes. Duplicate line entry points are the most frustrating and problematic of the budgeting process. We have requested that sales and margin values ​​be separated by product group and by our program name so that we can validate accurate forecasting and data entry. Because Hyperion® uses general ledger account numbers, we often have items budgeted on the wrong accounts. This creates budget reconciliation issues and in some cases the error...... middle of paper ...... will improve the tool for immediate needs while creating additional benefit for the sale future services. The database applications discussed provide value for our organization. We want you to be comfortable with each one and know which one you should use for a given application. At the same time these tools help us manage our business better, we must take appropriate steps to ensure that the data presented is complete and accurate for the intended purpose. Using the tools will make you more competent and continue to provide value to you, your customer, and your business.Works CitedMicrosoft. (nd). Improve the performance of an Access database. Retrieved from http://www.microsoft.comPinnacle Titan Technology Partners. (nd). Hyperion FDM. Retrieved from http://www.pgww.comSAP. (nd). Crystal Reports Server. Retrieved from http://www.sap.com