You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Item description is created as a custom planning measure and is visible in Integerated demand and Su

Received Response
13
Views
6
Comments
Vatsala Bharadwaj-Oracle
Vatsala Bharadwaj-Oracle Bronze Medal
edited Jul 21, 2021 8:04PM in Supply Chain Planning and Collaboration 6 comments

Answers

  • Yogesh_P-Oracle
    Yogesh_P-Oracle Bronze Crown
    edited Jul 22, 2021 2:55AM

    Hi Vatsala

    Check if below setup will help your business requirement instead of custom measure.
    Configure Planning Analytics > Levels and Attributes > Member Identifier to Display= Select "Item Name and Description"

    its not showing up the Item description for all the Items after being added in the Planning Table
    >> Is it possible to share a screenshot?

    --Thanks, Yogesh

     

  • Sebastian Thomas
    Sebastian Thomas Silver Trophy
    edited Jul 22, 2021 3:19AM

    Hello Vatsala,

    Please check this table.column --> MSC_DIMENSION_PRD_DYD.DESCRIPTION for those part numbers

    Can you please check if the item description is the same for all item org combinations.

     

     

  • Vatsala Bharadwaj-Oracle
    Vatsala Bharadwaj-Oracle Bronze Medal
    edited Jul 22, 2021 11:57AM

    Hi SThomas,

    Yes the part numbers are present in MSC_DIMENSION_PRD_DYD

    and, Item description is same for all orgs.

     

    Regards.

    Vatsala

  • Vatsala Bharadwaj-Oracle
    Vatsala Bharadwaj-Oracle Bronze Medal
    edited Jul 22, 2021 12:00PM

    Hi Yogesh.

    Item name and description is giving us the concatenation of two, we require seperate columns.

    We have made the Level attributes to Item name as of now.

     

    Regards,

    Vatsala

  • Gururaman Subramanian-Oracle
    Gururaman Subramanian-Oracle Silver Medal
    edited Aug 16, 2021 11:32AM

    Hi Vatsala, Please check if you have created the custom measure at the lowest level - on dimensions (Item, Demand Class, Organization, Customer Site, Day and Sales Rep) with an expression “Attr(Item, Item Description)”, remove any measure that ends with 'year ago' and try. Earlier there was an issue in adding 'year ago' measures to the tables along with the custom measure to display item description, though i am not sure if the issue exists now. Thanks !

     

  • Vatsala Bharadwaj-Oracle
    Vatsala Bharadwaj-Oracle Bronze Medal


    User13107410-Oracle Hi, we were able to solve it, the granularity level had to be a bit lower and similar to the other measures and thus we chose Org+Time+Product and was able to solve it and the values are reflecting now.


    Thanks and Regards,

    Vatsala