Forum Discussion

alexmoreno's avatar
alexmoreno
New Contributor
22 days ago

Dimension members loading process using SIC

Hi all,

I'm quite new to OS integration pieces and being struglled with a request from my client to load dimension members using their data lake, so the memebers would be updated automatically or by a scheduled event.

The database is already configured at SIC and working fantastically well, however, I can't figure how to use it's features to load the metadata members to one of our UD dimensions.

I read a lot of topics here in the forum, but couldn't find anything that matches my case.

I already tried to create a Extender BR, but I'm getting a "Object variable or With block variable not set" error message when running the "api.Parser.ProcessSQLQuery" function. Not sure if I'm doing something extremely wrong, so I"m assuming that this part of the api must be used only within Connector BR's.

I also trie to create a connector rule to do the job, but when setting it up at the dimension property, nothing happened (not sure if I missed something here).

Any help on this will be really appreciated!

Regards

Connectors
Extenders
  • SimonHesford's avatar
    SimonHesford
    Contributor
    16 days ago

    Hi,

    Metadata loads are quite different from data loads in how they are processed. Take a look at the ACM (Application Control Manager) Marketplace solution as this offers a method for syncing metadata from an external source into the OneStream dimension model. Similar to data loads you would have to create a connector rule to source the metadata from your data lake and populate the staging tables in ACM, however from that point onwards it is all configuration using ACM's pre-built functionality

    Solution Overview