Skip to Content

BPC tables in HANA

Hi SAP Wizards,

Can you please let me know where can I locate SAP BPC elements (Environment, Dimension & Models) in HANA studio? I know where the data is located in the BW side.

Sincerely

Nicky

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 24, 2014 at 03:10 PM

    Hi Nicky,

    When using BPC on HANA, underlying tables for the models created in BPC are created in HANA data base and BW just stores the structure ie., real time info cube.

    Info cubes created in HANA will be HANA optimized info cubes with fact table surrounded by master data table.

    1. For the model created in BPC, goto to RSA1 in BW, get the technical name of info cube generated.

    2. Goto to LISTSCHEMA, give the info cube technical name and execute. Fact table will be shown with technical name as /B28/F<Cube name>.

    3. All tables generated in HANA will be under a specific schema. To find the schema, goto SAP BW system, in menu system -> Status. You can see field owner. The value for this field is the schema name in HANA.

    3. Goto HANA studio, in SQL prompt, execute the query as

    SELECT * FROM "<SCHEMA_NAME>"."<TABLE_NAME>"

    4. If you want to create any models in HANA you can directly give the technical name of table in data foundation.

    Hope this may be useful.

    Thanks,

    Selva.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Yogendra,

      The data you see in the cube or in the HANA tables are based on SID values. If you need to see the actual values of the data that is contained in the table you have to do data modelling.

      You need to create master data view (Analytical view) based on each dimension and SID table of the dimension. Then you need to create a analytical view joining the analytical view and the attribute view to see the actual data in the cube.

      -- Selva.

  • Jan 17, 2014 at 05:26 PM

    Please help....

    Sincerely,

    Nicky

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Nicky,

      What is your purpose to find bpc element in HAna studio? First login with a user who has authorization to Netweaver db schema ( generally like SAP<SID> ) . Then expand the tables or filter tables with UJ*, generally bpc table has UJ prefixes.

      But if you want to make some modelling ( analytical or calculation view on top of bpc models ) then use RSA1 in SAP gui then check the technical names of the cube and then switch back to hana studio /CPMB/F<xxxxxx> is the fact table. Alternatively you can use LISTSCHEMA ( old transaction for data model of a cube but still you may use it with some assumptions, since data model in BW/BPC on HANA has changed )

      hope it helps,

      regards

      Baris.

      ps : please grant points if it is helpful!