Limitation of Lookup/Custom class in AEP RTCDP B2B | Community
Skip to main content
A
Adobe Employee
Ankita5Adobe Employee
Adobe Employee
September 4, 2023
Solved

Limitation of Lookup/Custom class in AEP RTCDP B2B

  • September 4, 2023
  • 2 replies
  • 2069 views

Hi All, 

 

I wanted to check if there are any limitation/cons of having a custom class/lookup in the AEP B2B data model apart from below (features):

1. Lookup data is not visible in the profile store only its PID associated to profile record shows up in profile store. 

2. Lookup data cannot be exported to any destination, it's attributes can only be used to built segments when lookup is profile enabled.

3. Lookup tables can be up to 1 GB in size. (https://experienceleague.adobe.com/docs/analytics-platform/using/cja-usecases/b2b/b2b.html?lang=en)

 

Any other size restriction or cons of using a lookup if you have come across please let know, will be really helpful.

Thanks in Advance!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by arpan-garg

    Hi @arpan-garg , is there any documentation available on this for me to follow? Thanks!


    Hi @sharmilap  - https://experienceleague.adobe.com/docs/experience-platform/query/ui/query-schedules.html?lang=en

    2 replies

    arpan-garg
    Community Advisor
    arpan-gargCommunity Advisor
    Community Advisor
    October 30, 2023

    Hi @ankita5 - I think the first 2 limitations which you have cited are applicable not just to b2b but b2c as well.

      S
      sharmilap
      Level 2
      November 13, 2023

      Hello @ankita5/@arpan-garg ,

       

      We would like to export lookup attributes along with the profile attributes after segmentation. Is there any alternate way to achieve this functionality?

       

      Thanks.

        arpan-garg
        Community Advisor
        arpan-gargCommunity Advisor
        Community Advisor
        November 14, 2023

        Hi @sharmilap - In AEP only attributes associated with Individual profile class can be exported. For exporting lookup attributes after segmentation, the best way is to write a scheduled query that reads data from look table and export them to a dataset that is enabled for profile.

         

        By using the above way you can directly see the lookup attributes associated with a profile and can export it.

         

        Thanks,

        Arpan

          S
          sharmilap
          Level 2
          November 14, 2023

          Hi @sharmilap - Scheduled queries are just adding additional details to the profiles. You can add filter criteria in the queries to add the look up attributes to the selected profile criteria you want.

           

          If you don't add the criteria in your query then scheduled query update all profiles with the look up data.

          In either case the profile in the audience will have the attributes you are looking for.

           

          Thanks,

          Arpan 


          Thanks again @arpan-garg for your quick response. I have not worked with scheduled queries. Let me follow your advice and checkout if I can add the lookup attributes to the profile using scheduled queries. Will keep you posted. Regards.

            Terms & ConditionsAccessibility statement

            Loading footer...