Transformer - Why use SQL code as Source

[Sagae]

I have taken over some cubes that use the actual SQL code as the data source. Why wouldn't they have created and Impromptu report and saved as iqd? Will the SQL code run when the cube is built? Is it faster?

Thanks.

 

[gset]

HI,

I would be interested to know how do they use directly SQL.

Can you tell me?

Many thanks,


Graham.