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
Views limits
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: Views limits
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.
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.