Registering the Designer database to trigger the update

The update of the Budgeting & Planning model requires a connection to the OLAP database which is named DEPM. This workaround is required to be able to change the OLAP configuration of the model:

  1. Start Microsoft SQL Server Management Studio.
  2. Edit the tlbSystemProperties table.
  3. Delete these fields:
    • COSAPM
    • COSConnectString
    • COSConnectType
    • COSProject
  4. Start Designer.
  5. Register the Designer database.
    See "Registering a Designer database" in the "Designer" section for further information.
  6. Click Yes when prompted to update the repository. This step updates the repository to version 12.0.x.
  7. Start the Repository Setting Wizard.
  8. Connect to the database.
  9. From the Choose a project list, select DEPM.
  10. Complete the Wizard.
  11. Connect to the farm.
  12. Select File > Settings.
  13. Click the Models tab.
  14. From the OLAP Server list, select DEPM.
  15. Click the Logging tab.
  16. From the Logging level of the event list, select Debug.
  17. Select File > Create Database to publish the Designer model.