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

OEP_PFP dynamically added projects not available in ASO

edited Dec 19, 2019 3:02PM in Planning 5 comments

Summary

Need dynamically added OEP_PFP project available in ASO without a refresh

Content

Currently OEP_PFP allows the user to dynamically add projects in the Project dimension.  We have created a custom ASO cube which pulls data from OEP_PFP.  The issue is that the new project is not available in the ASO cube without a refresh.  The new project's data seems to be stored as Project_1 (in the BSO cube) until the application is refreshed.

Unfortunately we cannot disrupt the entire application every time a user adds a project, thus our reporting cube is not accurate for long stretches of the day.  Our current approach calls for exporting and importing the data between cubes (due to inconsistent dimensionality) but the new project will not show up.  Does anyone have an idea of how to pass the data to the ASO cube without disrupting the rest of our application?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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