Manually copying Target GL Day Snap for Irvine

Manually copying Target GL Day Snap for Irvine

First go into Excel and browse to make sure there is no data copied into the snap date. If there is extra steps will be required and we have a Zoom Meeting with Chuck, dedicated to this topic (\\thepolice\support\_Support Recordings and notes\Deleting records from fact tables.mp4). Once the snap date on which you are going to copy is empty we can proceed to copy the data from the previous month. 

  1. Open SQL Management Studio and connect to Databases.
  2. Find the snapdatekey of the day onto which we are going to copy the data using the following query:
    1. select (select [SnapDateKey] from dim_SnapDates where DateValue='04/01/2018')as [SnapDateKey]
    2. Change the date but be aware that for Irvine it will always be the first of the month.
  3. Repeat the same step to find the snapdatekey of the day from which you are getting the data. In this case it came from 03/01/2018.
  4. The query to copy the data can be found at Irvine D:\Datavision\SnapCopyScript.txt.
  5. Inside there is information on how to delete records from the fact tables and queries to copy data into the write tables, but for this task we are going to be using the very last query.
  6. The first snapdatekey will be the date to where we will be copying the data.

  8. The second at the bottom will be the date from where we are copying the data.

  10. After executing it finishes run this query to verify that some data was inserted in the snapdatekey:
    1. select dmk from factTargetGLDaySnap where SnapDateKey in(select SnapDateKey from dim_SnapDates where DateValue='4/1/2018')
    2. Change the date to the one you are copying to and run the query to make sure it has date on it.
  11. Go to Analysis Services and and full process the Target GL Day Snap cube, and that should be it.



    • Related Articles

    • Bartell Duetto Interface

      The Duetto interface runs in the DataVision server. Every day we receive a .zip file from Angie Hughes (ahughes@bartellhotels.com). The interface has two parts. First part is called dvPop and it takes the .zip file, renames it to Duetto.zip, extracts ...

    • Loading Forecast to GL Period for SBE

      Here is a quick video showing the steps necessary to load the forecast to the GL Period cube for SBE.  The 2020 Actual+Budget file is stored in a Budget Uploads folder on SBE. ...

    • MOHG - Security settings for Property IT to access MObi cubes

      The three groups are mapped to the MOBI Cloud infrastructure.   Application – LMHKG – MOBI Base   This group gives access to the PMS, POS, Spa, and S&C data.   Application – LMHKG – MOBI GL Normal   This group gives access to the GL Cubes, but only ...

    • How to load missing dates for Givex

      Below is a brief description of what needs to happen when the Givex file is late or is not received by Givex.  I am typing this up for all in the office so they are aware of the steps.   Whenever we receive these types of messages, we need to deal ...

    • Purging PCI data from Old SMSMkt database

      Periodically, Pebble beach will find some PCI data in their Marketing Module.  This is the old Marketing Module, so it isn't checking for CC# in all the fields like comment or phone #, etc.   So Alan Fujii will send a list of tables with bad values ...