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.
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
THANKS VIHAN
Hi Anand,
Have your resolved your issue on this.......?
Regards,
Vihan
Hi Vihan,
I have created the model by using et_ and sy_ tables and i am getting proper results.Thanks again.
Anand.