comparing the variable sequence number in BW need to follow the below steps.
Regarding comparing the variable sequence number in BW need to follow the below steps.
This document will help you to find the Variable number which we are using to create filters or to use default filters at the universe level,universe based on Bex query.
If Bex developer has changed the sequence of the Variables without Knowing the impact on the universe on Top of it,then as a universe developer you can check the variable number and then change accordingly at the universe.
Suppose i have a filter at universe
<OPTIONAL><FILTER KEY=”[!V000026]”><CONDITION OPERATORCONDITION=”InList”><CONSTANT TECH_NAME=”@Prompt(‘User Hierarchy Variable’,’A’,’User2\LovHierUser Hierarchy VariableBase’, multi,primary_key)”/></CONDITION></FILTER></OPTIONAL>
IF suppose this user hierarchy variable sequence has been changed then you can do the following as part of analysis to find the issue
- Once you enter into BW please give RSRT T-code and u will enter into below screen and give the technical name of the (query on which universe build) and then click on Technical information.
In the next screen scroll down until u find the below screen about technical id of the query
Take that Techn. Definition name and open another screen enter SE16 T-code and open the table ‘RSZELTXREF’ by entering the table name in the given field. And then click on
Then give this tech name in 1st ID text box and say execute.
In the next screen select the column ‘LAYTP’ and right click and click on ‘Set Filter’ filter the value for ‘VAR’
Then in the same way filter for active version only i.e column V – type A.
And then sort the column ‘POSN’ in ascending. Then you will find all the variables and their position in BW.
Here we have issue with postion 26 object which is for ex‘4U8842555CL36669VY9QT’ to know the description of this tech id go to another table called “RSZELTDIR” and give the tech name in ID and execute.
Here you can confirm the description of the object
Then now you can compare the text of the variable here and the one which is there in the Universe as part of universe filter,if it is matching then it will not through any error.
Else it will pick wrong data and sometimes it will not run.