cancel
Showing results for 
Search instead for 
Did you mean: 

PaPM Cloud No Join Predicate

0 Kudos
399

Hello ,

I cant find join predicates in join settings. Screen shot attached. It is for PaPM cloud . Please help how to find and use join predicates.

Thanks

Suvendu

no-join-predicate.png

Accepted Solutions (0)

Answers (1)

Answers (1)

emanuele_fumeo
Product and Topic Expert
Product and Topic Expert

Hi Suvendu,

in PaPM Cloud you have to specify the relevant dimensions inside the Join rules. For instance, inside the "From" and the "left outer join" elements of your example, you have to specify the relevant dimensions to perform the desired join. Just take some dimensions from the "Field" section of your calculation model, then copy it with Ctrl+C and paste it inside the Join rule with Ctrl+V. Then you can create the orange link between the subelements of the join rules by dragging & dropping.

To better understand it, I suggest that you inspect an example of join function implemented in another environment (e.g. a sample content). Please also have a look at the screenshot attached (2023-03-20-10-02-14.png).

Hope it helps.

KR,

Emanuele