We are using data source "2LIS_13_VDITM" in our SD cube. We have a weekly, yearly and monthly time characteristic.
Our business user would like to have a daily time characteristic so that they can review the sales on a daily interval instead of weeekly.
My question: Is it recommended to have a daily time variant from a system performance point of view. I mean we have a daily delta load for data source "2LIS_13_VDITM" . so why not have a daily time characteristic so that we can show the data in the query for each day.
Can you please let me know your thoughts.
thanks a lot for your support.
Have a nice day