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

Ajay Taneja

It appears that in your detail jsff you have not dropped it as a child VO and that's the reason it is unable to identify the primary/parent key

Could you give screen shot of both bindings of the page for us to confirm.

It should look similar to

pastedImage_0.png

What is the transaction property of the TF ?

Ajay

Okan Sutcuoglu

Actially I do the same think you mentioned.

This is master binding:

veh.PNG

This is detail binding:

dam.PNG

Ajay Taneja

What is the transaction property of the TF ?

Have you made single selection by default on your table ?

Also, you can pass on current selection of your master table the current row key and pass it to the second tf child as  a parameter

and in second TF you can use setcurrent row key as the default activity before your view gets executed. This shall help you to keep the inline

PS: Are you able to see filtered record in your detail child tf by default. ?

Okan Sutcuoglu

I did not touch anything from the Transaction it looks like :

trans.PNG

Yes the table is single selection. It includes selectionListener makeCurrent method. Also i tried something like that:

I binded both tables in a bean. I changed selectionListener method of the master table. Method looks like this:

    FacesContext facesContext = FacesContext.getCurrentInstance();

    ELContext elContext = facesContext.getELContext();

    ExpressionFactory expressionFactory =

    facesContext.getApplication().getExpressionFactory();

    ValueExpression exp =

    expressionFactory.createValueExpression(elContext, "#{bindings.ArntDocumentVehiclesView1.collectionModel.makeCurrent}",

    Object.class);

    AdfFacesContext.getCurrentInstance().addPartialTarget(this.getDocumentVehiclesDamagesTable());

When i select a master record, it refreshes the detail table but not filtering the table.

Okan Sutcuoglu

Sorry thats my fault. When i create the assosacion. I selected wrong columns

Ajay Taneja

It happens, kindly close the thread

Ajay

1 - 6