Routines in infopackages

[Former Member]

Hi all!!

I have this question; Im loading data to an infocube from a generic extractor that dont have method delta; I load all the information and I want to others loads are the diference (like delta) I know that is possible to put a routine in the infopackage that only load this diference; but I dont know how to create this; I dont find some example to do that or maybe a how to...

Thanks for the help

Monica

[Former Member]

Hello Monica,

Technically, putting a routine in a InfoPackage doesn't cause your datasource to suddenly become delta enabled. However, you might be able to design the routines in your InfoPackage so that you actually load data that wasn't loaded to the BI System. For example, if you have a datasource that has a selection "Date created", then you might opt to create a routine in the InfoPackage so that it computes the current date and then use that as a selection for the DataSource.

Please tell us about the nature of your data and your DataSource so that we can help you more

[Former Member]

Hola Mónica,

In your generic extractor, add a field that contains "Date modified" or "Date created" and then use the selection tab to filter using a specific date. To suite your exact need, use a variable (in the selction tab of the infopackage) in the date field to filter to "yesterday".

This way you can just program your process chain to execute pass midnight and will only load up values created or modified during the day.

It's also important to consider loading first an ODS object and then to the InfoCube so it will get the correct Delta.

Hope this helps!

g.

Mónica: Mándame un correo (ggaona@intellego.com.mx) para que, en caso que lo necesites, detalle más la solución (¿Cual es tu correo electrónico?).

Message was edited by:

Gerardo Gaona