TM1 Forum

Hi..

Currently i'm using the bedrock process 'Bedrock.Cube.Data.Zerout' for clearing the data in the TM1 cubes. Now i want to exclude the particular dimension element for data clear.
It seems like the bedrock process not having exclude option.
Is it possible to exclude the particular dimension element in the zeroout process?

Thanks,
Mek

{Admin note: Moved to correct forum. Does not belong in General.}

MekalaC wrote: Currently i'm using the bedrock process 'Bedrock.Cube.Data.Zerout' for clearing the data in the TM1 cubes. Now i want to exclude the particular dimension element for data clear.
It seems like the bedrock process not having exclude option.
Is it possible to exclude the particular dimension element in the zeroout process?

It's kinda difficult to answer Bedrock questions given the licencing condition that "you may not reproduce or publish the information on any web site, online service or printed media without prior express permission."

Actually I'm not even sure to what extent the thing is being maintained any more; we had some contractors in here last year who used some Bedrock code, and rather than rewrite everything from scratch I kept it around, even though I only occasionally use it for new stuff. As a result I signed up to the e-mail updates, logged a couple of issues, but have never heard anything since. Also the last code update was over a year ago now so it's unlikely that you'll see a feature like that any time soon, would be my guess.

All that having been said, what I would suggest you do is consult the documentation. You'll find that there is a process to create a view (Cube.ViewAndSubsetsCreate), and you will also find processes to create subsets including one to EXCLUDE one or more elements from a subset. If you're used to using the Bedrock code you should be able to use these to create a view with the relevant element excluded, and then just write the ViewZeroOut line in your own process pointing to the view that you created.

Thank you so much.. It is working fine..