Skip to Content
avatar image
Former Member

CDS view Join issue

Hello Everyone,

I am working on a scenario where I need to build a CDS view based on join between another CDS view and bsad table as shown in below code.

View activated successfully but showing below error

Invalid data source: No joins or unions supported

Please find the below screens for code part:

Thanks in advance

join-error1.png (37.4 kB)
join-error2.png (19.5 kB)
view.png (7.2 kB)
code1.png (62.1 kB)
code2.png (62.8 kB)
code3.png (61.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 08 at 07:25 PM

    Can someone please suggest me on this

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 05 at 02:59 PM

    Your view is of type consumption.

    Please change the view as basic or cube.

    It will work.

    Check Annotation VDMVIEWTYPE.

    Thanks

    Anup

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Sorry. My mistake.

      Check Annotation analytics.query: true.

      Union and join are not supported for analytics query.

      Refer to note#2551243

      Thanks

      Anup