Page 1 of 1

Views limits

Posted: Fri Sep 16, 2011 7:09 am
by ravi
Hi,

I have to build several views from a cube in PRODUCTION for data validation. After the data validation- I may have to delete them.

Just wanted to know - will it cause a issue in terms of performance? or any other side effects.

Please advise.
Regards,
Ravi

Re: Views limits

Posted: Fri Sep 16, 2011 10:04 am
by Christopher Kernahan
Hi Ravi,

It's quite common to create and delete Views on the fly for various purposes, for example as a datasource to a TI, and you should not be concerned that deleting a View created for this purpose would have a performance impact. If you create them manually, bear in mind it is possible a user may access the View which means you wouldn't be able to delete it until they closed it, so it may be best to create them in TI and delete them immediately when done.