cancel
Showing results for 
Search instead for 
Did you mean: 

Can we transport BW QUERY VARIANT (created in DEV) to QAS and PRD?

Former Member
0 Kudos

Hi gurus,

I created a lot of QUERY VARIANT ( parameters saved when we execute queries ) in BW DEV.

I am using those variants in my Analisys Process Designer and i do not want to create again in QAS and PRD.

Somebody knows how to transport those variants?

Is possible to assign by SE03? What is the code that object?

Thanks for any Help!!!

Carlos Eduardo Olinto

Accepted Solutions (0)

Answers (4)

Answers (4)

Joachim_Umbeck
Explorer

Hello,

the described tables are used in BW 3.X, for 7.0 transport query variants by transporting relevant table contents of RSRPARAMETRIZA(T) - active version should be sufficient.

Regards

Joachiim

Former Member
0 Kudos

I transported my Query Variants.

- Variants must be created in DEV

- Download the records from:

> tables

RSRVARIANT

RSRVARIANTDIR

RSRVARIANTTXT

> Filter Field: VARI = "Query Variants Code"

- Create request in DEV

- Assign R3TR TABU <Table name>

Tables:

RSRVARIANT

RSRVARIANTDIR

RSRVARIANTTXT

- Save the contents in each table (Only KEY FIELDS)

- Verify the Lenght in each field, it must be correct (no spaces for each Field)

I hope it helps you!

Carlos Eduardo

Former Member
0 Kudos

Hi Eduardo!

have you done it on BW 3.X or on the 7.0?

Best Regards,

Eugene

Former Member
0 Kudos

hi,

Variants are specific to System, not Transportable.

Regards

ReddY A

Former Member
0 Kudos

Hi,

To my knowledge, you cannot transport query variants. You have to manually create them in each system. The reason being, when you try to create variants through RSRT -> Query Variants, you are basically trying to create variants for a temporary program generated during run time!

(Example Prog Name: GP3Z5G10XDNJS7A3PI4HL5H7SKD). As you can guess, these run time programs do not have TADIR entries (not transportable) and hence any sub elements (like variants) created on these programs are not transportable as well.

-Vikram