how many calculated columns and measures can I write in dataset with direct query

[Anonymous]

Hi,

I am building report with direct query to the underlying Oracle datasource.

Is there a limit on the number of calculated columns or measures that I can write in a direct query data set ?

Regards,

Ashish

[Seth_C_Bauer]

@Anonymous There is no hard limit, but you will need to watch performance as you develop the solution. I've found that it isn't really a question of how many, but more what the measures or calc columns are doing. I've seen a single measure slow down the reports significantly.