Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

Migrating Subscription Views

May 30, 2018 by neal Leave a Comment

One MDS question that comes up from time to time is how to migrate subscription views during deployments. Manually creating the subscription views can be a time-consuming process. A Version Flag is used to accomplish this task.

Create a Version Flag
1. Under the “Administrative Tasks” section of the home page, select “Version Management.”
2. Select “Flags” under the “Manage” drop-down list.
3. Select the model you are creating a Version Flag. For example, the “Products” sample model contains four Version Flags.

4. You can create a new Version Flag by selecting the model, clicking “Add” and entering a Name. The “Committed Versions Only” value is set to True by default and might need to be updated depending on your needs. Click “Save.”

Assign views to Version Flag
5. The Version Flags have been created and need to be assigned to the Subscription Views. To do this, select “Integration Management” on the home page.
6. Select “Create Views”
7. Select the Subscription Views that you want to update and click “Edit.”
8. Select “Version Flag” from the “Version Option:” list.
9. Select a Version Flag name in the “Version Flag:” list. In this case, the name is “Current.”
10. Click “Save.”
11. The Version Flag value is now populated. Repeat the process for any other entity you want to assign to a version flag.

Deployment
12. Deploy the model as would typically be done. If you are using the Model Package Editor, make sure you select the Subscription Views.
13. Once the model has been deployed and validated, set the Version Flag to “Current” and click “Save.”

14. Select “Integration Management” on the home page and select “Create Views.”
15. The Subscription Views should now be available for use.

Filed Under: MDS Tagged With: Deployment, Subscription View, Version Flag

Leave a Reply Cancel reply

You must be logged in to post a comment.

May 2018
M T W T F S S
 123456
78910111213
14151617181920
21222324252627
28293031  
« Apr   Jun »

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · Minimum Pro Theme on Genesis Framework · WordPress · Log in