Skip to Content
avatar image
Former Member

how the data base records created in hana database

Hi ,

i am new to HANA and understand the concept of row storage and coulumn storage.i have migrated one bw infocube to hana optimised cube.

it has onl;y one key filed and rest all are master data sids.

when i see the data in the fact table the key filed values is repeating which should not be in a database table.

i found that the no of unique values which is repeating  is equal to the no of charcterstics in the cube.

could somone please explain how it gets generated and how it works.

examlple

key field     filed 1     field 2

1                 a                b

1                 a                 c

1                 b                 d

The key field contains the unique record equivalent to the number of charcterstics.

Thanks,

Ranjan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 20, 2013 at 11:32 AM

    Hi Ranjan,

    the question about the BW fact table design has nothing to do with how the table is stored internally.

    Whether the DBMS stored the data in rows, columns, squares or triangles - it really doesn't matter as the question of storing the data is dealt with on a completely different level than the question of schema design.

    However, for the in memory optimized infocube design on HANA, I guess, that you're just mistaken.

    What you typically see is something like this:

    KEY_LB_IMIC1PSID_0CALDAYSID_0CURRENCYSID_0TCTCONTCT1SID_0MATERIALAMOUNTSALESCOPAMRGN1/BIC/LBIOSMALL0            20.101.21560          78            7.294        1    680  440      0            

    The single "KEY_.." column here is NOT the key of this table, but a foreign key to a loading packet dimension.

    So, the table key would be the combination of all KEY... and SID... colunms:

    (KEY_LB_IMIC1P, SID_0CALDAY, SID_0CURRENCY, SID_0TCTCONTCT1, SID_0MATERIAL)

    Hope that's gives you a heads up. Anyhow, I think it would be a good idea for you to check the SAP BW documentation in order to understand the data design.

    - Lars

    Add comment
    10|10000 characters needed characters exceeded