topic Re: BW in Application Development and Automation Discussions

BW

naveen_inuganti2 — Sun, 08 Jun 2008 05:58:56 GMT

Hi....

what is the defference between tables and cubes?

Thank you,

Naveen Inuganti

Edited by: Naveen Inuganti on Jun 8, 2008 11:42 AM

Edited by: Naveen Inuganti on Jun 13, 2008 11:41 AM

Re: BW

Former Member — Fri, 13 Jun 2008 06:27:29 GMT

Hi Naveen,

Actually there is no difference between these two.

The only difference is in the way we store data.

Each infocube is a collection of various tables like Dimension tables, SID tables and Fact tables.

Whereas each database table is an independent table in itself.

Hope it helps.

Regards

Hemant Khemani

Re: BW

naveen_inuganti2 — Fri, 13 Jun 2008 06:36:31 GMT

HI...

So can i compare Cube with pooled and clusturd tables.. more than Comparision with transparant tables...?

Thanks,

naveen.I

Re: BW

Former Member — Fri, 13 Jun 2008 06:50:11 GMT

Hi Naveen,

I don't think you can compare them.

Pooled/Cluster table physically store the data related to many other tables whereas Infocube contains links between those various tables. The data is actually stored in Fact tables, Dim tables and SID tables.

Regards

Hemant Khemani