Page 1 of 1
Tracing views that are using specific subsets
Posted: Fri May 03, 2013 2:56 pm
by 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
Re: Tracing views that are using specific subsets
Posted: Fri May 03, 2013 2:58 pm
by 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.
Re: Tracing views that are using specific subsets
Posted: Fri May 03, 2013 3:04 pm
by declanr
mecheng wrote: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:
And then make your view and subsets all equal sProcessName, that way you can guarantee they wont be used anywhere else.
Re: Tracing views that are using specific subsets
Posted: Fri May 17, 2013 9:44 pm
by jstrygner
mecheng wrote:
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.
Re: Tracing views that are using specific subsets
Posted: Fri Jul 12, 2013 3:03 pm
by mecheng
Hi Everyone. Thanks for your replies. This has been very helpful!
Re: Tracing views that are using specific subsets
Posted: Fri Jul 12, 2013 3:09 pm
by mecheng
jstrygner wrote:mecheng wrote:
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.
Re: Tracing views that are using specific subsets
Posted: Sat Jul 13, 2013 10:24 am
by Wim Gielis
declanr wrote: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:
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:
Re: Tracing views that are using specific subsets
Posted: Sun Jul 21, 2013 5:15 am
by 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...