Skip to Content
author's profile photo Former Member
Former Member

Re-intregrate characteristic data in BPS

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

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2005 at 03:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2005 at 12:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2006 at 04:46 PM

    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

    Add comment
    10|10000 characters needed characters exceeded