Skip to Content
avatar image
Former Member

BPS Metadata

Hello....does anyone know if there is a repository containing all BPS objects we created in our model, similar to the metadata repository in RSA1 for BW? That is, a listing of our planning areas, levels, packages, functions, layouts etc? I need to compile a list of objects.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 08:41 PM

    Can you elaborate what do you mean by texts?

    These tables also have texts descriptions.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 06:21 PM

    There is none like a metadata repository in BW.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 07:48 PM

    Try the following tables:

    UPC_AREA, UPC_PLEVEL, UPC_DATASLICE, UPC_VAR.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:00 PM

    This is excellent.

    The tables contain the technical names.....do you know where the descriptions would be found? In another text table?

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:03 PM

    They are the tables.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:39 PM

    I only see the Technical names in these tables.....not the descriptive name that you also see in BPS. Technical names are a big help for me...but i also need the plain english name.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:50 PM

    Sure.....what i mean is we have a planning level with a Technical name of REVBUD. When this is created, you also assign a description to the object (for example: User Revenue Budget) which would appear in the BPS workbench along with the Technical name. Most of the BPS objects have both a technical name and a descriptive name. I don't see the descriptive name in the table you identified, only the technical name. I'm guessing maybe the descriptive names are in a text table to handle multiple languages.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 09:00 PM

    Actually i found the descriptions. They are in text tables. For example, the text table for UPC_PLEVEL IS UPC_PLEVELT.

    Thanks again.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 09:01 PM

    Not that I know of.

    May be Marc Bernard may answer that.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded