Forums/Community/General Questions
Answered
How to remove a join ?
Cimballi
asked this on May 28, 2010 14:31
How to remove a join between 2 DataSets once it has been created ?
Comments
Hi Cimballi,
It is not currently possible to remove a join between 2 data sets. However, we are working on a feature that will allow what we call "fluid" data models, allowing removing joins and basically allow you to iteratively work on the data model within the application. Unfortunately, this feature is still a ways off. I will post back here as we progress on this feature.
Ray
One additional note, another way to remove a join is to delete one of the data sets. This would remove any connections.
A detailed example of this is with two data sets, A and B. By joining these two data sets, say with attributes A1 and B1, both A1 and B1 would be replaced by a new "joined" attribute, C1.
If you were to delete data set B, then attribute C1 would also be removed, but attribute A1 would be restored, allowing you to join a future data set to it.
This is a rather roundabout solution, but I thought I would mention it, just in case it helps.
Hi Ray ! Yes, for now we retain the solution "remove the dataset". Thanks !
Thanks for the alternate suggestion, Ray. Much easier to delete a small dimension data set vs. a fact table data set. But it would be nice to be able to use MAQL-update to remove the relationship.
I noticed that when I deleted the data set, updated the schema, and refreshed the data, that all reports using fields from that data set as How/Filter Variables were also deleted. Is there a way to prevent this? Or a way to extract report definitions to re-import/re-create later?