data source "2LIS_13_VDITM"
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
M Tibollo replied
normally this should have no impact on performance of your system. the only possible issue will be greater number of lines displayed. the more calculations you do in a query (ckf, formula's,...), the bigger the impact on the response time of the query