Need to extend 2 or more subject Areas by joining with same Dataset(uploaded excel file)
Description (Required):
I am trying to extend a subject area by creating a join between the subject area and the uploaded dataset(excel file).
This works fine when the dataset is joined to a subject area in a workbook but when the same dataset is used in a different workbook to join with a different subject area the joins in the previous workbook disappear.
So the behavior shows that 1 dataset can only be joined with only one subject area when using the same columns for joining.
Use Case and Business Need (Required):
I understand as of now the Blending relationships are stored in the tables and not in the workbook. So any blending matches that we add or remove impact the other datasets that use the same tables.
But we have a scenario where the same dataset(uploaded excel file) is required to join with 2 subject areas in seperate workbooks, one for each subject area join. And the join columns are same for both subject areas.
So can there be an extention to the current functionality where we can use the same dataset to join with 2 subject areas using same columns for joins.
Enhancement Request / Service Request: ER
Comments
-
Each DV workbook needs to be able to join datasets independently of another. This is causing major issues on my team where we create one dataset that should be able to be used for multiple purposes. If someone creates a workbook with joins, they think their work is done. Then someone comes in and creates another workbook with the same dataset, it's going to break someone else's work. This is atrocious design. And to the point of the submitter, I have multiple datasets that all have "Customer" in it. By creating a join to one of them, it breaks the join of the previous. This dramatically limits the ability to have multiple datasets in the same workbook. I'm going to have to go back to OBIEE and use presentation variables again.
0 -
Agreed @Branden Pavol . Thanks for your view on it.
0
