building multi selection for input schedule

[former_member597393]

Hi Guru,

I woul like to build a query based on different selection for each colunm , could advice me how to build this input schedule.

the structure should be like this :

Drop down list for each field selection , the user can do different selection for each column .

Field selection 1 Field selection 1 Field selection 1 Field selection 1

Field selection 2 Field selection 2 Field selection 2 Field selection 2

Field selection 3 Field selection 3 Field selection 3 Field selection 3

Field selection 4 Field selection 4 Field selection 4 Field selection 4

Field selection 5 Field selection 5 Field selection 5 Field selection 5

Field selection 6 Field selection 6 Field selection 6 Field selection 6

Field selection 7 Field selection 7 Field selection 7 Field selection 7

Field selection 8 Field selection 8 Field selection 8 Field selection 8

Key figure 1 1$ 2$ 1$ 2$

Key figure 2 1$ 2$ 1$ 2$

Key figure 3 1$ 2$ 1$ 2$

Key figure 4 1$ 2$ 1$ 2$

Key figure 5 1$ 2$ 1$ 2$

Key figure 6 1$ 2$ 1$ 2$

Key figure 7 1$ 2$ 1$ 2$

Regards

[Former Member]

Hi,

I am not sure whether I understood or not.

You can try to create a nested EVDRE. You can have multiple rows and multiple cols. However, you need to define which dimensions should appear in the rows and which should appear in the cols.

[former_member597393]

Hi nilanjan ,

I want :

in colum1 selection1 to have dropdown list

in colum2 selection2 to have dropdown list

in colum3 selection3 to have dropdown list

and so on.the list of data (I mean source data) in the dropdown list is the same for three columns , but the user may do different selections column1 column2 column3.

So when I click on send data , I get result list with different rows and coulms.

each rows are calculated diffrently, do I can add a FORMULA in my row dimension to achieve this ?

Thanks

[Former Member]

Hi,

I dont think this can be done.

In the columns, you can use EVMBR function. The user can select the member. Accordingly, the data cell should fetch the value using EVGTS. However, you need to make sure that your column represents only one dimension. So, you need to use the other dimensions judisiously in the EVGTS function.

The problem comes now. You cant override the data cell with some other value, because that cell has a formula. If you write some value in that cell, the EVGTS function gets overwritten. And if you cant write value in the cell, then what will you send.

Hope you got my idea.

[former_member597393]

Hi,

What if I added one Property Formula in my row`s dimension , but not directly in input schule as Excell formula.

so each row will have different PROPERTY FORMULA.

Do you think that will be calculated dynamically ?

Thanks

[Former Member]

Hi,

If you want to use formula on a member, that member becomes calculated. And you cannot send data to any calculated member.

[former_member597393]

Hi ,

I miss something , the structure will be

in colum1 selection1,selection2,selection3 ...each selection with dropdown list

in colum2 selection1,selection2,selection3... each selection with dropdown list

in colum3 selection1 selection2 selection3.... each selection with dropdown list

Regards

[former_member597393]

Hi ,

I dont want override my cell data, I want just to display the result for analysis based on my selection.

is there any capability to do this in sap bw ? what is the best choice ?

Thanks

[Former Member]

Hi,

Something just caught my eyes.

Have you been talking about BW or BPC?

[former_member597393]

Hi,

Yes first discussion is about BPC , but I am trying too to found any alternative in BW , to compare the two solutions .

Do you have any example , document,blog that explain how to build my case with nested evdre or other function in BPC.

Thanks for your help

[Former Member]

Hi,

As I said earlier, I dont think it will be feasible in BPC and I dont think there are any documents for this kind of scenario.