Can we load data From Multiple Odata Queries to Single Planning model ?

[lakkireddy_amarnathreddy]

Hi 

Can we load data From Multiple SAP SF Odata Queries to SAP SAC  Single Planning model ?

I Have 2 Odata Queries as below

1.Job Information Query

2.Compensation Query 

I want to bring  these 2 queries  data to a single planning models is this possible ?

Or we need to create per query per model   

[jmoon]

Yes, but. In a account model that is possible but in a measure (new model) that won't be possible until you get release 2025.7. The ability to combine queries was not possible until this release. But with 2025.7 Just like for account models, SAP Analytics Cloud now allows for combining multiple data sources during data preparation of models. This is available either via data import, or when transforming the data foundation data after you have created a model.

[lakkireddy_amarnathreddy · Accepted solution]

HI ,

I got the Solution for this ,

1.Go to Model > Data Management 

2. Select the Import Job  > Set up Import Job 

3.Under the Actions > Combined Data

4. Set the Joining Condition .

Regards,

Amarnath  

[Nithin17 · Accepted solution]

we have combine option only in classic model

[lakkireddy_amarnathreddy · Accepted solution]

Hi Nithin17 ,

I don't think we have that option in model level , if need to combine 2 Queries. we need to create 2 models and  do  Blending in Story level . 

Which i have given solution on New Model with import data.

Regards,

Amarnath.