TM1 Forum

Hi all,

I need guidance with ViewZeroOut function. I used this function in the TI process (Prolog lab) that loads a cube, but the cube does not get zeroed out when this TI process is run. I created the view that needs to be zeroed out in a TI window, I chose the required subset for each dimension elements. However, I think I haven't chosen the correct subset and hence the cube is not getting cleared out. Could you please guide me on the below questions when selecting the necessary subset to be zeroed out -

1) In case of dimensions with multiple levels of consolidation, which level of consolidation should be selected? I selected the top-most level.
2) Should I expand all the levels of elements before selecting the level of consolidation/leaf elements?

Thanks

It would really help if you post your code. That way we will be able to get a better idea of what is going on,

Jim.

First just put a processbreak after you created your view in your TI. Then look at the cube to see if the view is what you expected.

If I am not mistaken I dont think you can zero out a view at a consolidated level. You need to either:

1. Create a view of all N-level elements or some N-level elements (must be N level)
2. If you just want to zero out every cell in the cube you can use CubeClearData.

When using the ViewZeroOut function you only need to specify subsets for those dimensions in which you don't want to clear all the elements. If all elements should be cleared on a dimension then don't specify a subset for that dimension. When it comes to the dimensions where you want to pick only certain elements to clear, the subset must include only leaf-level elements. Picking consolidations will not work.

Hi Jim and uchow10,

Jim I'm trying to select the subset to be zeroed out in the attached window. Uchow10, thanks for the suggestion. I filtered at level 0 (leaf level elements) for each of the dimensions and it worked.

Thanks Tom for your guidance.