Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to remove Fact Joins

Greetings, I'm trying to remove couple of Joins (previously made by another party):
Out of these 11 Joins, I would like to remove
the Date Join:
Neither can I click on dropdown nor can I click on "x". When I hit "Delete All Matches" and hit OK, it still remains as is.
I would suspect if it would be because of this:
Please let me know if there is any more to the story and your suggestions to remove the join will be highly appreciated.
Best Answer
-
Hi @Vismay Barot ,
You don't have admin privileges on the datasets. That's why all options are greyed out in the Blend Data dialog, and the Access tab is not displayed in the Inspect dialog for the dataset.
0
Answers
-
Not ideal but have you attempted to delete the entire join and recreate it with just the 10 joins that you require?
0 -
Is there any Data Flow mapped to this Dataset if yes try to remove the dataset first from Data Flow and then make your modifications and re-map it again to Data Flow
Or if this Dataset results are saving in ADW could also cause an issue
0 -
@Federico Venturin , you're right. I do not have access rights to this dataset which is why I cannot modify. I replicated this dataset and that did the work.
Thank You @Federico Venturin , @Joel and @Mostafa Morsy-Oracle for your inputs.
0