Uploading or Pasting multiple values in variable in BI 7X

[former_member209700]

Hi Experts,

We got a strange requirement from the user asking for they want to upload or paste the multiple values in company code variable for example 100 values.They are running the reports from the portal and we are at BI 7.31 Version.

We have checked any option given by sap for this , have this option in Analyzer when the variable is defined as selection option or multiple single values. This will not help us since all users are running the reports from portal only.

Requesting all ,share your suggestions how can we achieve this or if anyone worked on similar requirement help me.

Thanks ,

venkat.

[cornelia_lezoch · Accepted solution]

Hi Venkat,

since multiple values in variable entry will be divided by ";" your users could make up their list of values as one string of values, all divided by ;

then they input the whole string into the selection field.

regards

Cornelia

[former_member209700 · Accepted solution]

Thanks Cornelia for your reply.We already suggested that option .They are not agreeing to that and saying it is time consuming process every time.

They want to upload it from notepad or excel directly .

Thanks

venkat.

[Loed · Accepted solution]

Hi Venkat,

You can make a TEMPLATE in excel where they can paste all their values in column A for example then just concatenate all the values posted with ";" between each value, to avoid the "time consuming" thing..

Regards,

Loed

[former_member209700 · Accepted solution]

Hi Loed,

Thanks for your reply.We have created simple macro to concatenate values with ; .

Thanks,

Venkat.

[sapna_jgurudutt · Accepted solution]

Hi Venkat,

What is the Release and  SPS level  you have applied to ABAP Stack and Java Stack here?

Can you please refer the following SAP Notes and check whether it helps you:

1737417 - BEx Web 7.x: upload selections from file or clipboard

1781924 - BEx Web 7.x: selector dialog enhancements and usability

2064268 - BEx Web 7.3x: Support for multiple hierarchy node selection

1887762 - BEx Web 7.x: updated selector dialog enhancements

Also, please refer the following SAP KBA Note:

1899396 - Patch Level 0 for BI Java Installation - Detailed Information

Thanks & Regards,

Sapna

[former_member209700 · Accepted solution]

Hi Sapna,

Thank you so much and sorry for late relpy. I made the changes as per the below note .Copy and paste option is working perfectly but upload from file not working.

However it served our requirement and we are quite happy.

1737417 - BEx Web 7.x: upload selections from file or clipboard

Thanks a lot once again.You are the best in Web reports area since many of my issues in this area were solved by your suggestions. I am assigning full points.

Regards,

Venkat.

[former_member186053]

Hi Venkat,

If understood correctly, ask client to personalize the variable values and save the query in his/her favorites in portal. So that original query would not affect.

Regards,

Vengal.

[former_member209700]

Thanks Vengal for your reply.We already suggested that but they are saying the input values will change every time.