CUBE vs Table

[Former Member]

Dear BW Experts,

All things reaming same, which one is faster to query.

An Infocube or

A tranparent table with same selections and output.

For simplicity assume 6 dimensions in the Infocube

I am seeking an in general answer as I am aware the answer to such questions always "depends"

Thanks

BORAT

[Former Member · Accepted solution]

Hi Borat,

If I understood you correctly then a transparent table.

Assuming that this transparent table is available in BWA using a DSO in BW 7.3.

Assuming because you have asked the question in BWA forum.

My answer is T Table, because you don't have to look at different table indexes in the Accelerator compared to Cube. Hence this should be faster.

Regards,

Sujit.

[Former Member · Accepted solution]

Thanks Sujit for the reassurance.