Running PB 2017 R3
I am hoping to find a way to easily manage a window that uses SharaData with multiple DW's. I have a master DW which has every column selected from the table that can be updated. I then create other DW's from this master and only paint the columns I need for that particular view. In the picture below I have just the PO columns painted but you can see there are 10 other DW's that will get swapped in. This works fine until I have a new column to add. I add it to the master and then I have to go to every DW and add the same column so the ShareData will work again which is a pain.
What I would like to do is be able to create the specific DW's (ie. Purchase Orders) with just the columns I need and then during runtime somehow refresh the column specs from the master DW so the ShareData will work (all the column names will be the same). I thought I could use SetSQLSelect but that does not work. Does anyone have a genius idea to do this or some other great way to make this work nicely without the maintenance headache?
Thanks - Chris Craft