diff between cy and it tables in planning data mart

[babu babu]

Hi,

When i publish the application from CAC i can see the tables like cy_xxx and it_xxx for the same D-List with  the same structure.what is the main diff between these 2 tables.when i am linking the fact table et_xxx which i need to prefer cy_table or it_table.Please give me the solution.

Thanks!
Anand.

[vihan]

Hi Anand,

Differences are-
It_table(D-list Item table): One table is created for each D-list in the planning model. Each item table describes the contents
of a D-list. For Ex, you may find a month item table storing month details, such as Jan,Feb and Mar so on....

sy_table and cy_table(Hierarchy table): The two most commonly used hierarchy table are cy_(Calculated hierarchy) and
sy_(Simple hierarchy). In most of the cases, the contents of these 2 table will very similar.
Derived hierarchy lists found in sy_table allowing reporting tools to automatically generate summaries for each level
of the hierarchy. The complete hierarchy lists found in cy_table are intended to be used when a D-list contains complex
calculations between D-list items.

You can use complete hierarchy lists, which are already in the planning application,
Regards,
Vihan

[babu babu]

THANKS VIHAN

[vihan]

Hi Anand,

Have your resolved your issue on this.......?
Regards,
Vihan

[babu babu]

Hi Vihan,

I have created the model by using et_ and sy_ tables and i am getting proper results.Thanks again.

Anand.