Skip to Content
Author's profile photo Former Member

Full data load without PSA

We are having certain data sources which are not supporting delta. So we need to run full data load on daily basis. Sometime this full data loads are multiple time in a day.

Some Full Data loads are:

  1. Master data load
  2. Master data text load
  3. Full load to DSO
  4. Full load to Infocube after every full content and PSA deletion

This full type of data loads are keep increasing our data base size. As PSA will hold this data and we cannot override PSA. In other hand we are having one solution to delete this PSA after every successful data load to target. This consumes extra time as well as this is extra burden on Application server with database server. 🙁

BW 7.3 powered by HANA is come up with new feature where we can skip PSA data load. Our data is directly getting loaded throw DTP itself.

In DTP maintenance screen we can specify that to not extract data from PSA. So now we can directly load data from datasource without loading to PSA using InfoPakage.

The flag “Do not extract from PSA; use direct access to data source” will display if the DTP source is a DataSource from operational source system. PSA layer becomes optional now.

This option reduces load of BW housekeeping activity. 🙂

DTP_Option_Load_without_PSA.gif

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      just a small note:-

      i have seen this feature available for DTPs set to 'Extraction Mode' Full even before BW 7.3

      Author's profile photo Sandeep a
      Sandeep a

      @duncan : it was available in 3.x modeling .

      and new feature came in sap hana @ dtp level.

      Regards

      Sandeep

      Author's profile photo Sandeep a
      Sandeep a

      Hi KJ

      Thanks for sharing your knowledge.

      Regards

      Sandeep

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Sandeep

      Author's profile photo Former Member
      Former Member

      Thanks for the valuable info

      Author's profile photo Antony Jerald J
      Antony Jerald J

      Hi,

      To leverage this option, what SP should we need to have?

      We're using BW 7.3 on hana with SP 09...

      Or is this option is from BW 7.4 onwards?

      Regards,

      Antony Jerald.

      Author's profile photo Mary Shilpa Balavendra
      Mary Shilpa Balavendra

      Hi,

      The Full DTP with "Do not extract from PSA" option is not a HANA dependant feature and it available from 7.30 release.

      Regards,

      Shilpa