Hi It sounds as though you are using dedicated connections for Dev1 and Dev2. If you just had a single OTBI connection, you could update the connection details when you migrate and then reload the data at the dataset level rather than having to create a new dataset and change it in the workbook. I don't think there is a…

Have you considered creating a new hierarchy that concatenates the child org and task at the detail level? There is a blog from Rohan Lobo that shows how to do this for cost centres. Maybe something similar could work in this area? Create a Custom Alternate Presentation Hierarchy in Oracle Fusion Data Intelligence |…