how should I model several time reference characteristics in an InfoCube? E.g. I have a characteristic "Post_Date" for the relevant posting data and a characteristic "Due_Date" for the payment relevant data in each of the records in InfoCube.
In this case, how should I assign these both time characteristics to dimensions?
thanks for your reply. Sorry that I did not describe my question clearly. My question was: How can I model two different time characteristics in the Time dimension of an InfoCube? Normally if I have only one time characteristic (e.g. Sales_Date) I can map Sales_Date to the different SAP standard time characteristics (e.g. 0CALYEAR, 0CALMONTH, etc.) in the transformation and they are automatically filled by a time conversion.
In my scenario, I have multiple dates (Post_Date, Bill_Date, Due_Date) in my data model and I am not sure how can I best model them in InfoCube.
Generally while assigning two infoobjects to a same dimension or a different dimesnio we analyze the relationship between the two char. That is if there is one to many relationship we assign them to the same dimension . If there is a many to many relationship we assign them to different dimension.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.