on 01-05-2010 9:19 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
Variants are specific to System, not Transportable.
Regards
ReddY A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.