I need to report on Transactional Data which is from Flat File.
I intend to load to ODS and Report on it.
Later if need be i can create Infocube depending on reporting requirement.
Is this ok?
Moreover what difference i see in reporting if i use ODS instead of Infocube?
i.e Any advantage of using Infocube instead of ODS in prespective of Reporting Output?
Thanks and Regards,
For simple Flat File data you can go either DSO or CUbe it is not a problem, in DSO you can't create a dimenstions , but in Cube you can create upto 13 dimensions and you can analyse the report in Multidimensional way in Cube reporting.
For simple flat reporting you can for DSO, it is very fast because it is like TWO demenstional Table.