cancel
Showing results for 
Search instead for 
Did you mean: 

Selection of Values in Free charcteristics

Former Member
0 Kudos

Hello,

Can some one please help me with the below:

Our users are asking if they can pass fixed values in to filters with in the free chracteristics of a web report. For example, the user runs a report and he has to select 70 Materials from the filter where we have around 3000 Materials.

Another user has to select 40 of his materials from the same 3000 Materails. Like wise each of the user delas with particular materials which are of his area. They are now complaining that it is very tough to select their materials from the list (3000) every time.

What is the best way, that each user can select his own list in the filter of free characteristics.......Like using an excel to upoad his list or book mark etc....It is likely that materials will change for the user and so book mark may not be very helpful.

Can you please suggets as how I need to go about this?

Regards,

TRA.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Godhuli,

Thanks a lot for the reply. Although your answer doesn't solve our user problem completely, it is a great idea. I will see if I can implement some reports in the way you have suggested and ask your opininon:-)

Thanks again for the answer.

Have a nice day.

Regards,

TRA.

Former Member
0 Kudos

Hi,

Well a user must be selecting his list of 'n' materials based on some criteria... what i mean is for a user, he must be interested in a logical group of materials.

For example :

A user is responsible for a certain brand, which has 'n' number of materials.

Include this logical group as a variable . In the above case it is Brand.

When the query is executed for the first time it takes up all the materials for the defined group (brand as in the eg).

Make this variable a multi select option as a user may have more than groups assigned to him.

In this case he will have a subset of materials from where he will have to select.

Hope this is of some use

Regards,

Godhuli

Former Member
0 Kudos

Hi,

From the report resreict the mateerial numbers required for one user and Save it as an View or work book.

The the user can open the view related to him. so that the user does not want to select 40 or 80 material numbers every time.

Also if you create it as a work book you cannot execute in Web.

Better create it as a View.

Regards

M.A

Former Member
0 Kudos

Hello MA,

The probelm is that the users are sent each week as which materials they need to look from the head office. So, this is never common/same. At the same time, it is difficult for them to select the materails from the total list. So, they are asking us if there is a way, where they can pass values from excel or .txt etc...because the values are received by them from head office and is not always constnat 70 or 40 etc. They might change. Sorry for not being clear in my initial question.

Regards,

Tra.

Former Member
0 Kudos

Hi

If the list is sent in Excel for the material number

Then create a multiple single entry varaible, or Variable with interval.

Then while executing the report the user will be asked to enter the values for variable.

Copy the material numbers from excel and then Paste it by pressing the Arrow icon and paste option.

Regards

M.A

Former Member
0 Kudos

Hello MA,

Is it wise to have 70 selections in the initial selection screen, if the sent list is not in the value range?

I don't think, the user will be happy to see this in selection screen.

Do you mean to say there is a way, where we can copy and paste all values at once in the selection screen, even if they are not in the value range?

Former Member
0 Kudos

Yes,

Execute the report.

It will display the variable screen.

Doesnt matter about the value range though the material number is not in the range.

Just click on the Arrow icon and it will open a small window.

bottom you can see the icons for delete, paste, cancel etc.

Just click on paste icon after copying the material numbers from Excel file.

It will paste all the copied material numbers in selection screen.then execute it.

Regards

M.A

I think with out variable there is no other way you can make it easier.

Former Member
0 Kudos

Hello MA,

I am sorry for asking again. I cannot see the buttons you have said. All I can see when I select the selections button in the variable screen are below:

Transfer

Close

Select All

Deselect All

Where do we see Paste? Can you please explain this. Are there any seetings in Web designer, we need to do inorder to see them. I can send you a mail to your ID (?) with screen shots. Please help me. We are using BW 3.5 version with SP 21.

Former Member
0 Kudos

Hi TRA,

Sorry i am talking about the report. But in the web these option is not available.

Regards

M.A