While configuring the connections in CJA, I am adding multiple datasets. And for some strange reason, I see some field overlaps get identified correctly, but this only happens for some fields. While creating the schema in AEP, do I need to create the fields in a specific manner so that CJA identifies them correctly? I tried keeping the same name, the same type -> but this is not working as expected.
Because of this, I cannot combine two datasets and generate a consolidated report. E.g., The brand field is present in two datasets.
Am I missing anything, or is this a product bug?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
@Anil_Umachigi, I have connected the two datasets with the unique id (say customer id). I have two brand name fields in the dimensions, one from each dataset (ideally column gets tied together there will be only one combined dimension field).
While configuring the connection, if the CJA understands that these columns are the same type, I can easily derive stats combining two datasets.
Views
Replies
Total Likes
@ChetanyaJain Trying to understand the end report you are trying to get to, will you use brand field to unify data from both datasets?
Also irrespective of what field name or type (every matching names and types) fields from both dataset will be ingested into CJA, these can then be filtered within data view to either include both or either within workspace UI.
Now coming to consolidated report, this will be purely based on the connection ID you have chosen while creating the connection and not individual fields.
Each of the brands field will be independent dimensions within the UI.
Views
Replies
Total Likes
@Anil_Umachigi, here's the setup:
Here are some observations:
Since it's shown as two fields, the dimensions we create will be linked with respective datasets.
When we drag brand dimension on reports (say table format) - and add metrics from appointments & invoice fields/events -> it doesn't stitch together or create a consolidated report for a brand.
Views
Replies
Total Likes
right ok this helps.
ok how about you try this, use the unique id ( used for connection to stich together the event data sets) in dimension with metrics you need.
Now break down the unique id by brand and hopefully this should do the trick.
let me know if that helped
Views
Replies
Total Likes
@Anil_Umachigi, I have connected the two datasets with the unique id (say customer id). I have two brand name fields in the dimensions, one from each dataset (ideally column gets tied together there will be only one combined dimension field).
While configuring the connection, if the CJA understands that these columns are the same type, I can easily derive stats combining two datasets.
Views
Replies
Total Likes
@ChetanyaJain Are you sure the same column name will get tied together? i doubt this is the case unless it's a new feature.
Does it create a new column with stiched brand details?
Views
Replies
Total Likes
Currently, it doesn't and I wish we can tie them together. It does tie a few columns - so not sure how it decides which columns to tie... but I definitely wish to tie an event-type column.
Views
Replies
Total Likes