Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using Period as Condition in Data Load Mapping

R.BrambillaAug 30 2019 — edited Sep 9 2019

Hello! This is my first post here, this is one of the few questions I haven't been able to find an answer elsewhere, so I hope someone will be able to help me!

What I need to do sounds pretty straightforward: I need to set different target values on a Multi Dimension mapping based on the period I'm importing data from.

But we do have one requirement: no SQL scripts, since our client will be constantly updating it, so it must remain as user friendly as possible.

To make it clear, I've put it on a sheet:

 ![pastedImage_1.png](https://objectstorage.us-phoenix-1.oraclecloud.com/p/BqK85Rn1zA5MP0vYiqbAdPgs7Z6OmMxw8SD3WCFVm5kY8uReidZ1KPIKkgJ1hCkG/n/axciphqpnohg/b/forums-legacy/o/uploads/jive_attachments/9/3/3/93358754egami.png)

So, we are importing all the data from Oracle's Financials Cloud to PBCS, and there's this specific dimension that only exists in PBCS, so we need to create a mapping to it.

The whole point is, the target member within this dimension, depends solely on when the data is from. If we are importing data from 2018, the target member needs to be "Year2", however, if we're importing from 2019, the target member is now "Year1", as an example.

And this would be a mapping that would be updated every year, since in 2020, "Jan-20" would be "Year1", and "Dec-19", "Year2", and so on... Hence the "user friendly" requirement.

I'm afraid this is beyond Cloud Data Management's capabilities, but I wanted to hear some expert's opinions about this!

Thank you very much for your time!

Comments