TM1 Forum

Is there any way(TI code or Function) to clear data from the cube (dynamically), i.e, without creating a view at the highest consolidation levels for the data that you want to clear?

Let suppose:

If I want to clear the values for the Region sales assumptions entered by business for the regions which starts with alphabet 'A'?
If I want to clear the values entered by business for a particular period (based on the element in period dimension)? and so.

I appreciate if any one could help me in providing a proto-type code or function that would be helpful for me.

Thanks in advance.

Seems to me that Dynamic Subsets should do what you want. Read the eponymous section in the User Guide.

ryan wrote:Is there any way(TI code or Function) to clear data from the cube (dynamically), i.e, without creating a view at the highest consolidation levels for the data that you want to clear?

If you're happy to use TI is there any particular reason why you want to steer clear of viewcreate and viewzeroout? It's quite simple to create a generic process that will handle any cube or dimension. You don't have to create subsets for all the dimensions in the cube, only the ones that you want to restrict.

If that'd work for you I (or half a dozen others) could jot up some sample code

Martin