Not able to use Assosiations/inner join on 2 CDS views with Parameters

[former_member577076]

Hi All,

We have a requirement to calculated the Current Year and Previous KPIs based on Input Parameter Date.

So created 2 CDS views with Parameters to get Current Fiscal Year and Previous Fiscal Yr Data.

When trying to use join/associations on the 2 parameterized CDS view, it says "invalid datasource: No Joins or Unions Supported".

Please advice if We are missing anything.

Thanks in Advance.

Veera

[pfefferf · Accepted solution]

As the message comes from the Analytics engine area (... [Analytics] at the end of the message) I assume that you have annotated your view with Analytics.query: true. If that is true, the message is correct, cause on query view level no union or join is allowed. You have to do that in the underlying CUBE or DIMENSION views.

[former_member577076 · Accepted solution]

Hi Florian Pfeffer,

Removed the @Analytic.query:true annotation and the view got activated.

Thanks,

Veera