Code Only and Description Attribute update for Loews

Code Only and Description Attribute update for Loews

This is how you can update the Code Only and Description Attribute for Loews -
  1. Open the Dim Manager on Loews SQL
  2. Open the PMS Rate Code dimension
  3. Click on the Attribute button at the top of the screen
  4. At the bottom of the Attribute screen, there is an option to paste in your clipboard of the Attributes you want to update
    1. This format must be in AllElements, Description, CodeOnly format, where each of these is a separate column in your spreadsheet.
    2. The headers of each column must be copied as well and must be spelled as AllElements, Description, and CodeOnly
  5. Click on Update Attributes
  6. Save the dimension as you would any other rollup and process the dimension

    • Related Articles

    • Steps to Fix Rigid Relationships Error

      First search and open Visual Studio        ·         Go to “File” in the top left corner, then go to “Open”, and click on “Analysis Service Database” ·         Select the Datavision Database and click “OK” ·         It will take a couple of minutes ...

    • 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 ...

    • DV Server - Windows password updates

      Update the password in all Services running under this user Update the stored password in all Windows Scheduled Tasks (running whether logged in or not) For DVmarket Web properties, update the password stored in \programs\DVmarket\web.config If SQL ...

    • 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 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 ...