APD conversion options for BW/4 Hana

[former_member806658]

Hello,

We're currently on BW on Hana 7.5, and in the process of migrating to BW/4 Hana (in-place conversion). We have a number of APDs that need to be converted because of the migration. Below are the options for APD conversion:

1. Use BEx query as a datasource in transformation (query as a infoprovider).

2. Create new data flows to replace APD data models.

3. Use/Create Hana calculation views.

4. Use Hana Analysis process (HAP).

Using Bex query as dataprovider comes with limitations as we cannot use queries with input variables as source in transformation. HAP is a very scenario-based approach mainly working for custom datamart scenarios, so not very feasible. We are left with using Hana views or creating new data flows. Is one of these approaches better or recommended than the other? Are there other options for APD conversion that are not listed above?

Thank you!

[appel_solar_dk]

Hi Ajaykumar

I would say it depends a lot on what you are doing in your current APDs.

A special version of "Create new data flows to replace APD data models." would be to use AMPDs it is a very efficient way of combining data across sources. But it requires that you know SQL.

-Kristian

[MKreitlein]

Hello Ajaykumar,

good question, since it is a topic with which I will probably also have to deal soon...

I would probably prefer no. 1) with Bex Query and routines inside the transformation.

Could you replace the input variables by fixed filters, or at least customer exit variables?

BR, Martin

[former_member806658]

Thank you Martin. Yes, BEx query as source seems to be the most viable option, followed by using Hana views. Will review our variables in queries again - most of them might be using customer exit variables..