Question:
Hi All,
I have a cube in which Document Posting Date is fed to 0CALDAY.
Now, I have to build an ODS over this Cube, where I need the Positing Date as well. When I try to create the update rule, I can not see 0CALDAY for assignement.
Any suggestions how would i get 0CalDAY to the ODS?
Thanks and Regards,
Mit
Answer:
Hi,
It depends upon whether you have included the field 0CALDAY in your ODS creation as a data field or Key field.
If you had inlcuded the field as a data field then it directly appears onto your Update Rules screen, but since you cannot see it directly in your update rules i think you must have included it as an key field.
If this is the case then you can define a unique update rule for every data field based on the typical combination of your keyfield. On the tab where you specify the update type (Addition / Overwrite / No Update), there is a tab for keyfields where your 0CALDAY must be visible and you can map it there.
Hope this solves your query