We have a limited need right now for the VC tool where we want to develop flex IViews for BW 3.5 queries.
The issue is that the queries which reside in BW Development do not exist in BW Prod. The BW Prod queries have different names. So the flex IViews wouldn't be associated with the correct queries.
Yet, this SAP doc makes it very clear that VC models should not be created in Prod.
<i>"To ensure file integrity and security of the production server when Flex models are generated by Visual Composer Storyboard, Visual Composer developers (assigned the VC Role) must perform their modeling on a development server only."</i>
What are some suggestions to address this? On one hand, we don't want to give our developers the ability to build queries directly in the Prod VC, but we also don't want to be charged with developing them on their behalf everytime they need to deploy one.