Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Best ways to provide data extracts for external applications/data warehouses/dashboards — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Best ways to provide data extracts for external applications/data warehouses/dashboards

Accepted answer
11
Views
4
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!