cancel
Showing results for 
Search instead for 
Did you mean: 

Analytical CDS Views - union associations is different in selections (3)

SriHarika
Discoverer
0 Kudos
165

Hi experts,

 we have a business requirement to merge Profit center analysis standard view with Journal Entry Analyser Standard view . 
When I am merging, I used union all in the cube view for the requirement . I am now getting syntax error saying association is different between selections. I checked multiple times , got checked with my team as well, the sequence of fields is same. No common associations between 2 Union all selects . Still the error doesn’t go away.

please find below screenshot and help me out. I don’t find much blogs on this topic.

SriHarika_0-1731609760305.png

 

 

Accepted Solutions (1)

Accepted Solutions (1)

junwu
Active Contributor
0 Kudos

don't know how you checked, the _user association is clearly different.

basically you have to make the cds you are trying to union to be "same"

Answers (1)

Answers (1)

SriHarika
Discoverer
0 Kudos

Hi Junwu 

thanks for the response.

the code is too huge so I have given just the error screenshot. 
Do you want me to paste the whole snippet. Pls guide me as I am posting in community for the first time 

junwu
Active Contributor
0 Kudos
at least you have to give us the standard cube cds you are using, and that _user association
SriHarika
Discoverer
0 Kudos

I am merging 2 views using Union ALL - One is I_GLACCOUNTLINEITEMCUBE in which I_USER is the target association with alias _USER and the second cube is I_FINANCIALPLANNINGENTRYITEM in which I_USERCONTACTCARD is the target association with alias _USER
And If I comment _User association exposure , the error is coming for the next exposed association . So I am believing that the error is not with _User association