Re-intregrate characteristic data in BPS

[Former Member]

Hi,

I have a question about integration data in BPS

in my model, on first step, a manual planning layout is filled with some characteristic date (such as description and texts) and a ratio (amount) and save the data

on the second step, i want to create a layout where each line can be validated by modifying a characteristic to a value

it looks like that once the data is saved, it is not possible anymore to modify the characteristic value in the manual planning

do someone has encountered the same issue ?

thanks in advance,

regards,

Chea-Lie

[Former Member · Accepted solution]

Chea-Lie ,

Let's see if I understood correctly.

With BPS you just can't sustitute a characteristic value for another in a layout, regarless whether data is saved or not in the cube.

Let's see: If you enter for cost center 1000 an amount of 500 USD you just can't modify the cost center in the layout and set it to 2000.

BPS however offers several alternatives:

1. Delete the row with the icon (available both in Excel and Web) and create a new row.

2. Set the current row to 0 and create a new one.

3. You could even use an allocation function.

Hope it helps,

Alberto Sabate

[Former Member · Accepted solution]

Hi,

To complete what Alberto explained, you could also use a "Repost" function that allows to change the caracteristic value (repost from CC1000 to CC 2000).

Hope it helps

Anthony

[Former Member]

I'd Like to add a requirement:

I have the need to select the characteristic:Supplier and choose several products marked for that Supplier the data exists in BW how can I filter this info to BPS

And simulate some purchasing alternatives?

Thanks a lot

Luciano Gonzalez

lgonzal@us.ibm.com

[Former Member]

Hi,

in fact, I do not want to modify even if your explanations are accurate to my issue

if I take your example

i'd like first time

put on

cost center 1000,

1000 euros

second time

cost center 1000

status OK

1000 euros

[Former Member]

Chea-Lie,

Your request can be done but only in a Web interface because it allows line selection and executing a function over a single line.

In a web interface you can do the following thing:

You can have i.e. 20 entries with 20 cost centers and 20 amounts. A user can click any row in this layout and execute the function validate.

The function will copy the cost center to the same cost center and characteristic "OK" as you said. We can also delete the amount at the same cost center and characteristic validate = "#".

In the layout component you will need to use the component "Row/Cell selection".

This could also be done with excel by filtering variables but not by selecting a row of your layout.

Hope it helps,

Alberto Sabate