DWC : Analytical dataset vs Relational dataset

[albertosimeoni]

Hello Expert,

I would like to understand which is the difference between Analytical dataset and Relational dataset,

At database level.

Beccause we had an example of a SQL Script view with a cross join that If used as Relational dataset it does OOM error for a simple data preview.
Instead if used as Analytical dataset, it gives a correct preview.

Are there any difference in the execution engines involved?

Thank you

update:

it seems related to the key definition rather than the "Semantic usage".

[reyemsaibot · Accepted solution]

Hi Alberto,

when you click on F1 you get the help from Data Warehouse Cloud. And the only difference I know is that an Analytical Dataset needs at least one Keyfigure and a Relational Dataset not. And you need the Analytical Dataset for consumption in SAC

I hope this will help you.

Best regards,

Tobias