OBIEE Pre-Builts Loading one year at a time

Hippy

Hi All,

We are in a situation where we need to load one year at a time into the DWH (warehouse).

We have 7 years of data to upload and we need to upload one year at a time.

JDK   1.8.0_x

Oracle WebLogic Server   10.3.6

OBIEE   11.1.1.9

OBIA   11.1.1.10.2

ODI   11.1.1.9

OHS   11.1.1.9

Oracle Analytics Cloud   5.8

Oracle Data Gateway   5.8

Oracle RDBMS   12.2.0.1.0

Do you have any detail as to how to do this?

Gianni Ceresa

Hi,

Is this question about OBIA loading (using the ODI mappings to load from your source into the OBIA warehouse)?

Because in OBIEE you don't load any data, therefore not fully sure about what you want to do in OBIEE itself...

Hippy

Hi Gianni,

yes we have obie to perform the load plan. So pre-built ETLs from oracle.

We have 7 years of data to upload and we need to upload one year at a time.

Do you have any detail as to how to do this?

Thanks Anto

Gianni Ceresa

Your thread is now in the OBIA category, hopefully somebody here will be able to answer your question.