sid tables

[Former Member]

Hi all.

we know that sid's will be stored in sid table like /bic/s(info object)...will the sid values of all master datas(attributes ,text,and hierarchy) be stored in this table???in this  sreen shot i can see the hierarchy tables.

1).will only  the hierarchy sid (values) get stored in the K table shown ?

2)what will then H and I tables strore???

3)difference between hierarchy and hierarchy structure shown in K and I table

pls explain in detail

regards

[former_member184494]

Kiranjith,

All you needed to have done would be :

open the table - look at the contents and compare it with the hierarchy you loaded - the data should have been pretty easy to understand.

[Former Member]

Hi Kiranjith,

1) The Hierarchy SID table stores the SID value for each of the hierarchy node & its values.

2) The H table stores the entire hierarchical structure along with the values and the link between the parent & child nodes along with node number whereas I table stores the structure of the SID of entire hierarchy.

3) The hierarchical structure shown in K is for hierarchy nodes & value informaion whereas I is to know the SID values.

Regards,

Indhu.

[Former Member]

Hi ,

we have 3 options for integrating Hierarchies into our data model :

1) internal hierarcies from characteristics in dimension table

2) hierarchies from characteristic attributes

3) external hierachies from hierarchy tables

The H-table is used to store hierarchial relationships between characteristic values if external hierarchies are used for characteristics

H-table contains all hierarchies.

H-table :base table for hierarchies and contains all hierarchies.

K-table :if we select "with hierarchies" option ,this table is generated.(SID table)

J-table :if we select "intervals permitted in hierarchy " option ,this table is generated

I-table :if we select "time dependent hierarchy structure" option then this table will be generated.(Hierarchy structure is displayed)

Regards,

Ramitha