Question:
Hi,
I have got a big problem, but I hope anybody can solve it. I created a Web Interface with 3 columns consisting of user, client and projekt. For each of this columns there is a reference to an InfoObject. All InfoObjects are located in one InfoCube. The InfoCube is filled with data and looks like:
User Client Project
me client1 prj1
me client1 prj2
me client2 prj3
you client3 prj4
I already created a WebInterface, where the values of the InfoObjects were shown in an dropdown menu for each InfoObject. Now I want it to make the following selections by itself, regarding to the function "add" ("hinzufügen"), which adds a dataset to the already existing ones:
If I choose the User (e.g. me), the WebInterface should adjust the valueentries of the dropdown menu for the Client. Means, that if you chose "me" as an user, you have only the possibility to choose "client1" and "client2". Further thes same shall work with the Client and Project drop down menus (By choosing client 1, only the selection of "prj1" and "prj2" shall be possible).
I hope I could explain this problem clearly. Otherwise I can answer all question, which are needed by you to solve this problem.
Just answer :-)
Thanks,
Peoples
Answer:
Hello,
This is what I understand from the description of your problem.
1. You have 3 info objects .. person, client and project
2. There is no relationship between the 3 at the info object level
3. The master data is loaded for the 3 info objects
4. The relationship between the 3 info objects is in a layout.
Based on the above understanding.. following are my thoughts.
1. You cannot restrict values in a drop down based on a relationship in a layout.
2. Drop down menus will reflect all valid master data for the info object.
One way to prevent users from choosing a erroneous value from a drop down list, is to create a validation rule, which would be based on the layout which creates the relationship between the three.
Hope this helps.
Sunil