Upgrade 3.0B to NW04s - Existing variant missing in new frontend!

[Former Member]

Hi all

We have upgraded our system from BW 3.0B to Netweaver 2004s BI with Support Package 12 installed. On the frontend, we are using the new BEx Analyzer with SP14 (rev 797).

Our existing query variants from 3.0B are no longer visible in the new BEx Analyzer 2004s, while new variants can be saved and used.

The existing variants are only visible and usable from RSRT or from BEx Analyzer 3.x.

We have applied: Note 1003481 - Variant Migration - Migrate all variants

and ran 'RSR_VARIANT_XPRA', before running 'RSR_MIGRATE_VARIANTS' but to no avail.

We have looked at Note 1054634 - Query variants are not found or are not listed for selection as well.

But we have tested with queries with technical names shorter than 25 characters but it is not working as well.

Looking at:

https://weblogs.sdn.sap.com/cs/user/view/cs_msg/14320

it seems like an unresolved issue..

Can anyone help us?

[Former Member]

UPDATE:

After the RSR_MIGRATE_VARIANTS program was run, the variants were migrated over to the RSRPARAMETRIZA and RSRPARAMETRIZAT tables.

However, the variants are still not showing up in the new BEx Analyzer frontend. We also noticed the difference between newly created variants in the new BEx Analyzer and the migrated variants:

Newly created variants - use a !PERS47P* naming convention in the PARAMN field

Migrated variants - use the variant name itself.

Newly created variants - CONTENT field which contains XML information

Migrated variants - CONTENT field XML appear to be incomplete (<> tags not closed etc..)

Newly created variants - CONTENT field makes reference to generated ID

Migrated variants - CONTENT field XML tried to store actual variant selection data but is incomplete.

Has anyone used the migration programs successfully before?

Thank you