Skip to Content
0

CDS view Join issue

Jan 02 at 12:48 PM

101

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Can someone please suggest me on this

Thanks

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 05 at 02:59 PM
0

Your view is of type consumption.

Please change the view as basic or cube.

It will work.

Check Annotation VDMVIEWTYPE.

Thanks

Anup

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Anup,

even after changing the annotation as u suggested it still showing the same error

Thank you

0
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

0