What is Data_Package in 3.5

[naresh_babu3]

Hi All,

We have two Boxes in current Project, One is 3.5 and another is 7.3.

We are Re Designing the solution in 7.3 based on the 3.5 system with new enhancements,

In one of the data flow from DSO to Cube, They written a Start Routine which is mentioned below.

loop at DATA_PACKAGE.

   if DATA_PACKAGE-CALYEAR LE '2008'.

      delete DATA_PACKAGE.

   endif.

endloop.

Can any one help what is meaning of above code,and let me know how i can implement in New 7.3 solution

Thanks in Advance

Regards,

Naresh

[RamanKorrapati · Accepted solution]

Hi naresh,

While loading data from DSo to Cube, filtering the records which are less than 2008 as calyear.

means which records have calyyear lessthan or eequal to 2008 those are are deleting and loading remaining data into cube. mean your cube may have the data calyear greather 2008 mean 2009 onwards only.

by using routine just deleting records which are created or changed in the calyear of 2008 or below.

Thanks

[naresh_babu3 · Accepted solution]

Hi Raman,

Thanks for your reply,

I understand the logic, but how to write in 7.3 version transformation is the question.

Can I write like this .....

loop at Source_PACKAGE.

   if Source_PACKAGE-CALYEAR LE '2008'.

      delete Source_PACKAGE.

   endif.

endloop.

[Former Member · Accepted solution]

Hi ,

If you want to load the data using the same logic i,e want to load data >2008 then you can use the same logic.

[anshu_lilhori · Accepted solution]

Hi,

Yes this seems to be correct as DATA_PACKAGE has to be replaced by SOURCE_PACKAGE in 7.X flows which you have already done.

So it should work.

Regards,
AL

[naresh_babu3 · Accepted solution]

Hi Aakash,

I need the systax in 7.3, as we don't have Data_package in 7.3, how to write the logic for the data >2008

[Former Member · Accepted solution]

Hi Naresh,

Thats what i said your syntax seems to be right you can use the same logic. Data>2008 means calyear data>2008 to be loaded. This is not a code

loop at Source_PACKAGE.

   if Source_PACKAGE-CALYEAR LE '2008'.

      delete Source_PACKAGE.

   endif.

endloop.

[former_member186445 · Accepted solution]

delete source_package where calyear LE '2008'.

BR,

M.

[former_member182516 · Accepted solution]

Hi Naresh,

You can simply write the logic in single line as suggested by Tibollo.

DELETE SOURCE_PACKAGE WHERE CALYEAR LE '2008'.

Simply copy and paste the code in start routine and execute the load and check . this should work.

Regards

KP

[former_member182470]

This is a simple code to delete/filter the data package if the calyear=2008. Hope you know that the data gets loaded into BW by package wise.

That means, you are not loading into your infoproviders of 2008 data,