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!

FDMEE ASO to BSO Cube Not getting Source Data

User_GA574Nov 20 2018 — edited Nov 21 2018

Hello,

I would appreciate your help on an issue moving data from ASO to BSO in Data Management on a PBCS Instance.

For Period on the ASO Cube is using a custom dimension, because it uses a daily hierarchy, and on BSO it uses the regular Period dimension. To map the “Periods” dimension with the “Period” dimension, I created period mappings, creating as Global Mappings, every day in the cube.

1.PNG

Then, created Application mapping for the target BSO Cube.

2.PNG

And after that, I created the Source mapping for the ASO –> BSO

3.PNG

The issue is that I am receiving that Data Management is not geting the Period Mapping correctly. I don't know why I get a warning error saying that there is no data on the source. I get the following error message:

Rows Loaded: 0

I even tried filtering the exact intersection on the source filters inside the Data Load rule where I know that there is data, but I still can't reach the data on the source.

Any advice on how I can address this issue? I’d appreciate the help.

Comments