Replacement Variable

[Former Member]

Hi,

I have a query say Q1 with characteristic Org. level 1(A).I personalized this characterstic variable with 3 values.

Say i created a new query Q2 with characterstic Partner Org. Level 1(B)which is a copy of A.Instead of loading this personalized values twice,can i create a varible on B of process type replacement path and assign Q1 as the replacement path.

So the personalied values will come up as user entry values for Q2.Is this possible?

Any suggestions would be of great help.

Best Regards,

Suresh.

[somnathkumar]

Hi Suresh,

I tried your scenario in my system and I am glad to tell you that it works.

Just some points to be noted, if the variable is of type replacement path, it will not come up the variables entry screen. So when you run your query Q2, you might get other selection options but not 'Partner Org. Level 1'. But when you run the query (Q2), the characteristic will be filtered by your personalised values in Q1.

[Former Member]

Hi Somnath,

Thanks for the reply.I tried to run the Q2 query,but i am getting a message that No applicabale data found.But in the cube i can clearly see the values.

Can you explain me what you did exactly,so that i can follow the same steps.

Best Regards,

Suresh.

[former_member188975]

Hi Somnath,

As Suresh mentions, he personalised the variable for Org Level, created a replacement type variable for Org Level, and then wants to use this for Partner Org Level. I understand that Partner Org Level may be a reference to Org Level. So did you test this scenario, with 2 chars..?

[former_member188975]

Hi Suresh,

I do no think it will work becasue you are using 2 different characteristics: Org Level and Partner Org Level, even though they may contain the same values and Partner Org level may be a reference char of Org Level...I just posed this question, and we can know for sure when he replies...

[somnathkumar]

Firstly are you sure that you are not getting any data because of your replacement variable?

Ok, here's what I did.

1. Created query Q1 with characteristic 0SHIP_TO and to this I added variable of type user entry.

2. Ran query Q1. The selection box came up for specifying values for 0SHIP_TO. I put 4 individual values and personalised the variable and cancelled the running of the query.

3. Created query Q2 and for characteristic 0SHIP_TO, I created a variable of type replacement path with Q1 in it.

4. Ran query Q2. It gave a selection box with other user entry variables but not 0SHIP_TO. Executed the query and the report was filtered with the personalised values of the user entry variable of 0SHIP_TO of Q1.

[former_member188975]

Hi Suresh,

For your scenario to work you would have to include the Org Level char in Query 2 (if it is available). You can put in in the free chars or the filter area and restrict it with the replacement path variable.

So when you run Q2, Q1 will get executed and supply Q2 with the values you have set up in personalization. This will restrict the output of Q2 to those values of Org Level, but the user will not be able to see it. You will have the Partner Org Level in the rows, and that is what will appear in the report.

Hope this helps...

[Former Member]

Somanth-

I am sure this is becoz of replacement variable.When i take out that variable then no probs with the Q2 query,shows result.

In your case becoz you created Q2 on same 0SHIP_TO char(not on a copy of it) it works.

Bhanu-

I didn't understand what you mean by your comments.

You mean to say that with reference or copy characteristic it is not possible to use the personalized vlaues via replacement variable.

Best Regards,

Suresh.

[somnathkumar]

Hi Bhanu/Suresh,

Good question Bhanu. The answer is that the variable will work for either of the referenced characteristics. As we all know, 0SHIP_TO and 0SOLD_TO are referenced out of 0CUSTOMER.

I did a variation to my steps. I created a variable of type replacement path on 0SOLD_TO instead of 0SHIP_TO, but during the creation, I chose the variable to be created for characteristic 0CUSTOMER.

Now when I run the query, whatever I personalised for 0SHIP_TO in Q1 is getting copied into 0SOLD_TO in Q2. This is eventhough I don't have 0CUSTOMER in either of the queries.

So Suresh, are the 2 Org levels in both the queries referenced out of a single infoobject (like 0CUSTOMER) or are they seperate (One copy of the other)? If former, it will work.

Bhanu, are we now on the same page?

[former_member188975]

Exactly Somnath...looks perfect now

[Former Member]

Thanks Bhanu & Somanth.In my case its different info object.

Best Regards,

Suresh.

[Former Member]

Hello suresh/somnath/bhanu

I am new to BW and was going through the posts.

I could not understand what personalization means? is it same as creating a variant? if different then how do we do it?

Thanks

Raj

[former_member188975]

Hi Raj,

Personalization is not the same as creating a variant. See this link for more info:

http://help.sap.com/saphelp_nw04/helpdata/en/3f/30ae3d47afd652e10000000a114084/content.htm

Hope this helps...

[Ashwin]

Hi raj!

it not creating avairant but automatically filling the values for variable. . By personalizing the variables, you assign values to them that are permanent until you remove the personalization.here is the sap help link for the personalization of the variable.

http://help.sap.com/saphelp_nw04/helpdata/en/3f/30ae3d47afd652e10000000a114084/content.htm

with regards

ashwin

[Former Member]

Hi Suresh,

I think only the result of your first query will be picked up automatically in the second query if you use this as a Replacement path.

Hope this helps.Please let me know if you have any issue

Regards,

-Ashish

[Former Member]

Hi!

don't quite think it works that way!!

The value that you have entered in the first one will be picked up automatically in the second but i dont think the personalised values will also be taken...

plz correct me if wrong!

MM