Preview

Sddfdsf

Powerful Essays
Open Document
Open Document
5033 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sddfdsf
A Different Approach to Implementing Time Calculations in SSAS
David Shroyer OLAP Business Solutions April 2007 (Revised) Applies to: Microsoft SQL Server 2005 Analysis Services SP2 Summary: Analysis Services 2005 now includes built-in time intelligence enhancements which make it quick and easy to add time calculations to OLAP cubes. This paper will discuss the problems associated with the built-in enhancements and suggest a different approach for implementing global time calculations. Included with this paper is a .zip file called TimeCalculations.zip which includes the sample data mart and example SSAS project files. Contents Introduction The Business Problem The Built-In Time Intelligence Wizard Built-In Time Calculations Seen From a User Perspective Advantages to Using Built-In Time Intelligence Disadvantages to Using Built-In Time Intelligence How Does the Time Calculation Dimension Work? Creating a Shell Dimension Adding the Time Calculation Dimension to the Cube Adding the Time Calculations to the Cube Verifying the Prior Year Calculation Verifying the Year to Date Calculations Adding a Different Type of User Defined Hierarchy Adding the Attributes to the Dimension Adding the Calculations Conclusion

Introduction

AS2K5 offers developers a built-in wizard which will automatically add global time calculations to SSAS cubes. These built-in MDX scripts are very limited in their calculation scope and prove to be cumbersome for end-users to use. Fortunately it is very easy to create your own time calculation dimension which can then be customized to the application’s requirements.

The Business Problem

The fictitious company used in this example is called Sub Palace. Sub Palace is a small retail sandwich company headquartered in Northern California. The company has small retail outlets which have a limited sandwich and soda menu. The company has had some growth in the past few years and now has 10 retail outlets. The owner, Mr. Hanson, is trying to get

You May Also Find These Documents Helpful

  • Powerful Essays

    Spa Works

    • 2686 Words
    • 11 Pages

    As Spa Works continues to grow by expanding to new locations and acquiring competitors, this has resulted in a lot of legacy systems which are still in place among various locations. This slows down the day-to-day operations and reporting functionalities which delays critical decisions related to customer satisfaction and retention. By developing this new IS system we are looking to forge together existing systems and to better integrate and produce reports in a more timely fashion and also to assist in day-to-day operations by providing a reliable and accurate source of information. This new system will allow Spa Works to better allocate resources to address customer issues, generate real time financial and human resource reports to see the cost and value of people involved in day-to-day operations and to better forecast future requirements to better suit the customer preferences.…

    • 2686 Words
    • 11 Pages
    Powerful Essays
  • Good Essays

    Sdfasdasd

    • 712 Words
    • 3 Pages

    Question: Compare and contrast the depictions of the deity in the first (Gn 1:1-2:4a) and second (Gn 2:4b-25) creation narratives.…

    • 712 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    The intended users for this system are employees and managers. The employees will need to be able to clock in and out of specific projects in order to give accuracy to the system when the manager runs the report. The managers will also need to have the ability to clock not only themselves in and out, but the employees as well.…

    • 829 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Wdfqsdf

    • 1827 Words
    • 7 Pages

    MacPherson Refrigeration Limited (MRL) is a Canadian company specialized in commercial refridgeration. They were established 30 years ago and currenly have sales of about $28.5 million. Ten years ago they opened a new 300,000 square foot plant in Stratford, Ontario to difersify into consumer refrigeration. Linda Metzler has recently been appointed as its planning manager. She has been asked to submit an production plan for the next calender year. Each year MRL’s marketing and sales department produces a forcast of appliances by month for the next year, which the production planning department uses to plan production. The first step in the planning process is to construct an aggregate production plan, which consists of the planned gross production by month for the year but does not indicate numbers of specific appliace types, sizes or models to be made each month but is an aggregate as each type of appliance requires roughly similar materials and labour resouces. As the production periods approach later in the year, master production plans will be formulated which would be specific regarding appliance type, model number etc.…

    • 1827 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    * Use the schedule performance index (SPI) to estimate how long it will take to finish this project.…

    • 410 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Kudler Fine Foods is a company composed of a workforce of approximately 100 employees divided in three different locations. Each office handle manage their own employee’s data base. The timekeeper and attendance records are done manually that causes errors and time consuming. Kudler Fine Foods requires a timekeeper analysis process for finding a feasible solution for the company.…

    • 456 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    You are responsible for managing information system development projects at AAA Systems. To better track progress in completing projects,you have decided to maintain a simple database table to track the time your employees spend on various tasks and projects with which they are associated. It will also allow you to keep track of employees' billable hours each week. The table below provides a sample data set.…

    • 255 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Manzana

    • 993 Words
    • 4 Pages

    Processing times: A revision of processing times is required since as current figures are based on data from 1986 which did not assume computer usage. As a result, policy writing and rating processing times will have changed significantly since then. Since these processes are the basis of several operational calculations, measures should be revised annually.…

    • 993 Words
    • 4 Pages
    Good Essays
  • Better Essays

    In Table 1.0 you will find the results of our initial analysis which includes the optimistic (O), most likely (M), and pessimistic (P) estimation for duration times it will take to complete each task (A-J). Additionally, when taking the estimated numbers of O, M, and P and applying the equation “E = (O + 4M + P)/6 provided by Wysocki (2009, pp. 152) we are able to obtain the results of (E).” Furthermore, Table 1.0 provides the results of the ES to FS procedure “which consists of the earliest times at which a task can start and finish” (Wysocki, 2009). This process is known as the “forward pass through the network diagram” (Time management). Also the “LS to LF procedure “which consists of the latest times at which a task can start and finish without delaying the completion date of the project” is calculated (Wysocki, 2009). This process is known as the “backward pass through the network diagram” (Time management). Both the ES to FS and LS to LF procedures were calculated based on all the dependencies between each of the tasks outlined below.…

    • 1185 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Supply Chain software

    • 617 Words
    • 3 Pages

    t. Under the In-house production time in days fields, record the value for the fields Processing time _15.48_, setup time _0.07_, interoperation time _3.71_, Base quantity _100_. View F1 for field definitions for each..…

    • 617 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Three different time estimates for various activities of a project are given in the below table.…

    • 392 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Marketing Objectives

    • 333 Words
    • 2 Pages

    * Time specific - When are you hoping to achieve these objectives, you need to define a timing plan with target timing for each specific objective?…

    • 333 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    E-Job Cards

    • 28107 Words
    • 113 Pages

    Using an intuitive web based timesheet entry interface to the employees will be able to capture their time in a quick and efficient manner, reducing data entry times and speeding up the cost collection and reconciliation processes.…

    • 28107 Words
    • 113 Pages
    Powerful Essays
  • Satisfactory Essays

    NOVA time a group system developer, on last May 2007, the system that will give management the power to not only utilize the tools we have available to us today, but will continue to grow and evolve, giving it the capability to incorporate and utilize the tools the new millennium promises to bring us. NOVA time has brought a system designed for growth while maintaining the maximum in flexibility. Where the sophistication lies within the programmed mechanism of the system, allowing for a quick and simple implementation and employee training cycle, after all the true test of a system is not only in the production and wealth of reporting, but in the simplicity and ease of its operation in conjunction with a simple and accommodating implementation program.…

    • 249 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Collection Of Work

    • 258 Words
    • 2 Pages

    The timetabling of observations is dependant on the type of observation. e.g. checklist over 10-15…

    • 258 Words
    • 2 Pages
    Satisfactory Essays