DSO or Cube for reporting only characterstics values.
We have a requirement where a report only has characteristics and no key figures and this report is transactional report(transaction level Detailed).
My question is that as this is a detailed report with no key figures, does loading this data to cube will be of any use in terms of query performance or can I report directly on DSO as performance is achieved on cube as it aggregates or compress the key figures but we don't have any key figs here.
So in this case does it make any sense to load the data to cube from DSO to improve query performance as I don't want to utilize additional background process to drop the cube data and do a full load daily if there is no improvement in performance.
Please let me know if I didn't explain my query well.