Subset "XXXX" is being used by a view and cannot be

Post Reply
Acc_Moonwalk
Posts: 32
Joined: Fri May 27, 2011 9:06 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Subset "XXXX" is being used by a view and cannot be

Post by Acc_Moonwalk »

Hi ,

I am getting the error "Subset "SUBSET NAME" is being used by a view and cannot be deleted".
I have 2 process here one is main process and other one is sub process. In the sub process i am using the datasource as 'VIEW'.

In the main process i am doing the below steps :

1) Declared cube ,view, and subset name
2) I am destroying the view and related subsets
3)Created the subsets
4)created the view and assign the subsets to the view
5)called the sub process
6) Destroyed the view .

When iam trying to run the process i am getting the above mentioned error .

can anyone help me on this.

Regards
Ashok
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: Subset "XXXX" is being used by a view and cannot be

Post by Christopher Kernahan »

Is the error occurring in the Prolog or Epilog?

Check the relevant cube. If the View exists, then delete it. Then delete the subset in the dimension. Rerun your TI and if you get the error again then you know it is

a) doing the deletions of subsets and views in the wrong order, or;
b) not deleting the views and subsets in the epilog.

You can always change the name of the View/Subset being created to get around this, too.
Acc_Moonwalk
Posts: 32
Joined: Fri May 27, 2011 9:06 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Subset "XXXX" is being used by a view and cannot be

Post by Acc_Moonwalk »

Thanks For your reply ,

I have changed the name of the SUBSET and rerun the process , It executed sucessfully . Will i face the same problem when i run the same TI after few days.

Regards
Acc_Moonwalk
Posts: 32
Joined: Fri May 27, 2011 9:06 am
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Subset "XXXX" is being used by a view and cannot be

Post by Acc_Moonwalk »

Sorry , I missed to tell you , That the error is occuring in the Prolog TAB
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: Subset "XXXX" is being used by a view and cannot be

Post by Christopher Kernahan »

Hi - you'll need to review the TI to check and see if it is completing those steps properly.

You can rerun it now - put ProcessBreak; at the end of the Prolog, it will then skip to the Epilog (skipping over any Metadata/Data steps). Or hash out anything that loads/destroys data so you can debug this without damaging the system.
Xavier 13
Posts: 10
Joined: Fri Aug 05, 2016 11:23 am
OLAP Product: Cognos TM1 Planning Analytics
Version: 10.2.2, 11.0
Excel Version: Excel 2019

Subset is being used by a view and cannot be deleted

Post by Xavier 13 »

Sorry for the modest contribution but might help some beginner, how to find the view using your subset.

If you are denied to delete a subset because it's used in a view but you've got many of them, use the Notepad++ / Search / Find in files... feature to spot in your data directory the .vue files using your subset.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Subset is being used by a view and cannot be deleted

Post by Wim Gielis »

Xavier 13 wrote: Thu Jul 19, 2018 6:05 am Sorry for the modest contribution but might help some beginner, how to find the view using your subset.

If you are denied to delete a subset because it's used in a view but you've got many of them, use the Notepad++ / Search / Find in files... feature to spot in your data directory the .vue files using your subset.
That's correct. Thanks for bringing up this topic, let me add a link to a generic process to list views and subsets:
http://www.tm1forum.com/viewtopic.php?f=21&t=13723
Any input is welcome.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: Subset "XXXX" is being used by a view and cannot be

Post by paulsimon »

Hi

If you upgrade to PA you can use temporary views that will only exist for the duration of the process so there is no need to delete them.

In 9.4 you could include a timestamp in the name of the view and subset so that it will be unique each time. Alternatively you could include the name of the user in the subset. Another option is to include the name of the process in the view and subset names.

Please be aware that creating and deleting views are subsets are meta data events that cause locking. That is best avoiding if you can.

Regards

Paul Simon
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Subset "XXXX" is being used by a view and cannot be

Post by Wim Gielis »

paulsimon wrote: Fri Jul 20, 2018 8:15 pmIf you upgrade to PA you can use temporary views that will only exist for the duration of the process so there is no need to delete them.
Upgrading to 10.2.2 FP4 is sufficient for temporary views and subsets.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply