Best ways to provide data extracts for external applications/data warehouses/dashboards
Hi everyone,
We have been receiving more and more requests for data extracts from our Planning application into various data warehouses, dashboards (such as PowerBI), etc. We created some Data Integration/Data Management exports that have been working well, but it requires a fair amount of maintenance because we map the member names to either their respective aliases or some other custom value so that the target can consume the extract as-is. Thus, as we update the hierarchies/metadata, we must also update those mappings
One approach we were thinking of was to stop mapping things on export and instead require the consuming system to use the dimension exports to get things such as aliases and other attributes (essentially using the dimension exports to populate reference tables)