cancel
Showing results for 
Search instead for 
Did you mean: 

ODS VS Cube Reporting.

Former Member
0 Kudos

Hi,

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,

MuraliManohar.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

HI Surendra,

Can i do Slice and Dice the the data from ODS?

Whether User experience would be different if i model a query out of ODS instead of Cube?

Thanks and Regards,

MuraliManohar.

arun_kumar75
Participant
0 Kudos

Hi Murali,

Instead of going another Cube, better have a multiprovider for that DSO and do the reporting on top it.

Regards

Arun S

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

For simple flat file reporting user experience would not be much different if you model a query out of ODS instead of cube.

Thanks,

Prakash

former_member181964
Active Contributor
0 Kudos

Hi,

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.

Thanks

Reddy