Unable to refresh subsets

[pradeep.k.jagadeesan]

Hi,

When I tried to refresh a subset using TI process, Log generated an error statement such as Subset <Name> is being used by a view and cannot be deleted.

Please help me to resolve this issue.

Thanks in advance.
Pradeep J

[ellissj3]

Can you please post code? please make sure you delete the subsets /views before you establish it within your TI process.

[pradeep.k.jagadeesan]

Here is the code written in Prolog:

bookOfBusDimName = 'BookOfBusiness';
subsetName = 'tempSubset_Forecast_LoadActualData';

# remove the subsets
SubsetDestroy(bookOfBusDimName, subsetName);

Thanks
Pradeep J

[ellissj3]

Try logging out of your session, then logging back in and re-executing your TI Code.

[tomok]

SubsetDestroy(bookOfBusDimName, subsetName)

You can't destroy a subset if it is actively used in a view. if you want to destory the subset you will have to destroy all views that use it first. Of course this means you'll have to rebuild all the views after you are done rebuilding the subset.

[Michel Zijlema]

If the requirement is to clear the subset (by deleting and recreating the subset) you could use the SubsetDeleteAllElements function instead. This will not require you to delete any views.

Michel