Question:
I am working on the EC-CS Consolidation cube (0ECCS_C01) in 3.0B system.
I read the following from help.sap.com on the cube....
The transaction data in Consolidation is dependent on a consolidation group hierarchy. Since this itself is time-dependent, the characteristics 0CS_HDATFR (Hierarchy from) and 0CS_HDATTO (Hierarchy to) must be transferred to the filter together with the variables belonging to it 0P_CSHF (Hierarchy from (SAP Exit)) or 0P_CSHT(Hierarchy to (SAP Exit)). These variables are derived from the query key date and replaced using a SAP Exit. Only this way can you guarantee that the correct data is displayed.
Furthermore, a variable 0P_CSDAT is defined for the query key date. If this variable is not used, the current date is automatically used as the query key date. Both the validity interval for a consolidation group hierarchy (that may be used) and the two variables mentioned above are derived from the query key date.
Based on the above explanation I did add the varaibles/filter for the CS group hierarchy to the Query. BUT when I try to add 0P_CSDAT variable (after activation) to Time filter, I noticed that the variable was not visible for the Time (FY/Period). Later I realised the variable is only for the date InfoObject. When I check the std InfoCube the 0CALDATE is not part of the cube.
Does that mean do I have do transaction enhancement to the cube to add the 0CALDATE and later add the variable in the query ?????
Anyone had the same issue or any thoughts on this would be helpful.
Thanks.
JB
Answer:
You needn't add a 0calday to infocube.
actually 0CS_HDATFR and 0CS_HDATTO are the ones.
system will calculate the SAP exit variable automatically from your keydate.
If you cannot see the variable, just activate it from your business content.
Regards,
Schuecking.