Synch local dimension members between models

[ThomasK]

Hi experts,

for each planning model I´ve a parallel backup model. Data actions are backing up data from the planning model to the backup model. This works as long as local dimension members are synched between both models. If not, data is not copied.

Now I´m searching for a generic solution how to replicate local dimension members from a planning model to the corresponding backup model.

My ideas:

a) Export job for dimension -> functionality not existing

b) Transport network -> not possible to import dimension data to a new local dimension

c) Create subscription on planning model -> Can only see option to read booked dimension members based on fact data, means it´s not a generic solution. Versions and measures might be added later to the model, but replication of local members should still work without a change. Or is there another solution with subscription / data export API / data import API?

d) API Scripting in a story: Haven´t checked this until now. However, if it´s possible how could it be executed scheduled within SAC?

Does anybody see a (generic) solution to replicate local dimension members between planning models?

BR Thomas

[ThomasK]

I´m now evaluating this:

1. Create dedicated version "LocalDim"
2. Data Action to create facts in this version with local dimensions booked
3. Export data
4. Import data

I´ll let you know. Any other solutions appreciated.

[ThomasK · Accepted solution]

Hi, I could now find the following solution to synchronize local dimensions between planning models.

1. Create a API Subscription in the source model
2. Create an OAuth Client
3. Create an OData Connection and connect to OAuth Client (connection to itself)
4. Create data model import from OData Connection and import master data of the local dimension

This technique works perfect and offers additional opportunities to replicate (master) data even between different SAC systems.

Will write a blog when I´ve some time and link it here.

Regards,

Thomas

[OzanCavusoglu · Accepted solution]

Hi @ThomasK,
I'm having a problem with creating OData connection step.

1. I'm creating an API subscription in my model

2. I'm creating an OAuth Client in Administration/App Integration with Purpose:API Access, Access:Data Export Service, Authorization Grant:SAML2.0 Bearer.

3. I create an OData connection with Connect to an SAP OData service checked and I'm entering the subscription URL into the Data Service URL, selecting Authentication Type: OAuth 2.0 Authorization Code, entering OAuth Client ID, Secret, Token URL and Authorization URL and I'm getting a popup displaying dead cloud icon with the error message "Uh oh. Something went amiss.". Selecting OAuth 2.0 Client Credentials results in the red error message "Connection to service failed: OData Services".

What do you use for Data Service URL? Do you keep the "?deltaid" part?

What Authentication Type do you use?

Thank you in advance for your time.

Ozan

[ThomasK · Accepted solution]

Hi @OzanCavusoglu ,

I´m currently checking details before I (hopefully) have time for the blog.

• Step 1 - creation of API subscription
  -> is not necessary
• Step 2 - Create an OAuth Client
  Yes, Purpose: Use API Access, Access: Data Export Service
• Step 3 - Create an OData Connection
  Don´t check "Connect to an SAP OData service" (yes, this is strange)
  Data Service URL: https://<systemurl>/api/v1/dataexport/providers/sac/<model>/
  Authentication Type: OAuth 2.0 Client Credentials
  OAuth Client ID and Secret: according to Step 2
  Token URL: taken from System / Administration / App Integration
  Purpose: empty in my case (because not configured in the OAuth Client)

This should allow you to create the OData connection to be used later in the import. If not you should use Postman to check details/errors.

A finding in the meanwhile: You can read id´s, description and attributes of a dimension, but not the hierarchy 😞

Hope this helps,

Thomas

[OzanCavusoglu · Accepted solution]

@ThomasK this works, thank you. I was also uncertain that subscription is needed.

[ThomasK · Accepted solution]

Please find my blog for this topic here

Load master data within SAP Analytics Cloud | Exam... - SAP Community