How to Remove rule of a cube via TI process

[mce]

Hi,

How can I remove rule from a cube via a TI process?
I know I can load an empty rule file, but this does not remove the rule completely.
I want to completely get rid of the rule file.
One option could be to delete the .Rux file via command line and then unload the cube but I do not like this option.
Is there any easy way to do this via any TI function?

Thanks

[tomok]

The only ways I know of to remove a rule is to 1) right click on it in Server Explorer and choose "Delete" or 2) remove the .blb and .rux files for the cube in question and then recycle the TM1 service. You may be able to remove it via an API program, haven't tried that. No way to do it in TI.

[Steve Rowe]

You should be able to use the TI function

RuleLoadFromFile(Cube, TextFile);

To load an empty text file as the rule sheet. Not quite the same as deleting the rule sheet but it should have the same effect.

Not though that all ruled values will disapper when you do this, not sure if this is what you are after...
Cheers

[mce]

You should be able to use the TI function

RuleLoadFromFile(Cube, TextFile);

To load an empty text file as the rule sheet. Not quite the same as deleting the rule sheet but it should have the same effect.

Not though that all ruled values will disapper when you do this, not sure if this is what you are after...
Cheers

I am already using RuleLoadFromFile to load an empty text file as rule. This is not what I am after. I want to completely delete the rule and rule file from the cube.
Thanks anyway.

[Martin Ryan]

You could do as tomok suggests (delete .rux and .blb files then recycle) by using a batch file that you call from a TI process with the cube name as a parameter.

That's the closest I can think of. Or, if you want to get crazy, I guess you could create a temp cube, copy all the data, delete the old cube (which will delete its rule), recreate the original cube (now ruleless) and copy all the data back. But I can't see that being the greatest idea I've ever had.

Martin

[mce]

Thanks for the responses. It looks there is no easy nice way of removing rule from a cube via a TI process. I will continue doing it via empty file, as it is done temporarily within a full refresh process. I am avoiding to delete and recreate the cube in order not to loose any private or public views defined.

[Martin Ryan]

(My 1000th post, happy postday to me)

Sounds like the most sensible approach to me.

Instead of a blank file you might want to ensure that the file has "SkipCheck;Feeders;" in it. A long time ago I had a ridiculously slow cube because I had an empty rule. It may well have been fixed since 2002 (but given that we're still waiting for subix and TI data sources I wouldn't put much money on it), but having those two lines will ensure that the rule doesn't slow things down.

Martin