FAQ
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. ...
Code Only and Description Attribute update for Loews
This is how you can update the Code Only and Description Attribute for Loews - Open the Dim Manager on Loews SQL Open the PMS Rate Code dimension Click on the Attribute button at the top of the screen At the bottom of the Attribute screen, there is ...
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 ...
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 ...
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 ...
Saving a report without formulas
First open the report and click into the DV addin, select “Save Without Formulas” Make sure you save it with a new name so you do not save over the live report. Once saved you can right click on the file and copy then paste the report down to on your ...
Key has already been loaded - removing duplicates from a dimension
From: Sudharshan Chary [mailto:schary@datavisiontech.com] Sent: Tuesday, October 23, 2018 10:06 AM To: installs@datavisiontech.com Subject: DV Internal: (FIXED) POS2 Discount Issue on MOBI Hello all, Just recapping how I fixed the issue with ...
DV Addin getting an error for SSPI Context
Hi all, So, you are getting an error about the SSPI Context in your addin, and you want to know what to do next. First check that users are not in a different domain. Cross domain authentication may cause the SSPI context error. Second, check if the ...
MOPRG- email protocol
Hi Team, MOPRG requested that we copy their team on all Spasoft issues. We have created an entry in Passpack- “MOPRG- Email Address for Data loading late”- please use that and copy the email list on each Spa issue- ...
Adding Users in Datavision CRM using DVMarket-Admin credentials found in passpack
Datavision CRM How to add users using the Admin login From Login Screen, it takes you to the screen where you can add the users. Click on Add user. The screen comes up and you add username, password, and email for each user. Click ok. For each user ...
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 ...
MOHG/MOBI Cloud Patch Process
MOBI Cloud Patch process 11 AM – 11:15 AM – Stop DVAlert services (There are three, DVAlert, DVAlert Market, DVAlert MOMLN) Login Open each manager, click the stop button, wait for clear Open services, stop each dvalert and set to Manual restart ...
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 ...
Steps to fix stuck writebacks on hosted properties (IHGMIA, IHGORD, AKA, Brasada, Balboa, Geneva)
Restart DVWriteBack Monitor Service - this will be located on each of the properties individual RDP sessions a.
DV WEB - Certificate Refresh (generally with Problem in rendering error)
While the certificates were set to expire 12/23/2017, Microsoft automatically created new certificates on 12/3/2017. Next year, I imagine it will update the certificates around 11/13/2018. This video takes you through the steps to: Verify that ...
DVAlert Error - Number of records don't match between tmp and inc...
So, DVAlert is failing, the message is something like this: "IdBatch: 658 The numbers of records between tmpfactPMSBOB and incfactPMSBOB not match for cube PMS BOB" The problem is most likely that one of more of the dimensions has duplicate All ...
Clearing 'stuck' data writes in DVUpload Status
Get a list of what is currently outstanding: select * from DVENTERPRISE.dbo.StagingRequests where StatusId < 4 Fail those currently outstanding records Update DVENTERPRISE.dbo.StagingRequests Set StatusId = 5 where StatusId < 4
DV Addin - Calling Alt-F9/DVUpload from a macro
Dear Developer Divas, I have a macro. It is a fine and cunning macro. I want to Alt-F9 my Datavision formulas from my macro. I want to DVUpload from my macro. How can I do this? Signed Just Jamming with Jamacros Dear Jamanda, Excellent question! ...