Tracing views that are using specific subsets

[mecheng]

Hi,
I have an implementation with a large number of cubes in TM1.
in some TI processes, i'm dynamically creating/deleting views and subsets. I run into an error saying "unable to delete subset because it may be used in a view". I know what this means but its very cumbersome to go through the masses of cubes and views to find the view that's using the specific subset.

is there a setting or function or technique in TM1 that i can use to figure out exactly which view is using the subset of interest? some sort of trace?

Thanks,

Mecheng

[jim wood]

One thing to keep in mind. Many of us have seen caching issues with views like this. I've seen on many occasions a subset that can't be deleted without being a member of any view,

Jim.

[declanr]

Hi,
I have an implementation with a large number of cubes in TM1.
in some TI processes, i'm dynamically creating/deleting views and subsets. I run into an error saying "unable to delete subset because it may be used in a view". I know what this means but its very cumbersome to go through the masses of cubes and views to find the view that's using the specific subset.

is there a setting or function or technique in TM1 that i can use to figure out exactly which view is using the subset of interest? some sort of trace?

Thanks,

Mecheng

Mecheng,

If you mean that you create the view and subset in the prolog of your TI and then delete it in the epilog of the TI, it can be a good idea to start the TI with a simple:

Code: Select all

sProcessName = <Process_Name>

And then make your view and subsets all equal sProcessName, that way you can guarantee they wont be used anywhere else.

[jstrygner]

is there a setting or function or technique in TM1 that i can use to figure out exactly which view is using the subset of interest? some sort of trace?

Hi mecheng, I think this you could find helpful.

[mecheng]

Hi Everyone. Thanks for your replies. This has been very helpful!

[mecheng]

is there a setting or function or technique in TM1 that i can use to figure out exactly which view is using the subset of interest? some sort of trace?

Hi mecheng, I think this you could find helpful.

Thank you jstrygner! this really helped solve my issues.

[Wim Gielis]

Mecheng,

If you mean that you create the view and subset in the prolog of your TI and then delete it in the epilog of the TI, it can be a good idea to start the TI with a simple:

Code: Select all

sProcessName = <Process_Name>

And then make your view and subsets all equal sProcessName, that way you can guarantee they wont be used anywhere else.

Actually, TM1 has a built-in function for that:

Code: Select all

sProcessName = GetProcessName;

[EvgenyT]

I also find it useful to have a While loop in epilog to go through each dimension in the cube to destroy subsets, that way you are sure not to miss one in your code...