Subset "XXXX" is being used by a view and cannot be
-
- 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
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
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
-
- 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
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.
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.
-
- 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
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
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
-
- 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
Sorry , I missed to tell you , That the error is occuring in the Prolog TAB
-
- 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
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.
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.
-
- 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
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.
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.
-
- MVP
- Posts: 3123
- 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
That's correct. Thanks for bringing up this topic, let me add a link to a generic process to list views and subsets: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.
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
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
- 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
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
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
-
- MVP
- Posts: 3123
- 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
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
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