Metadata management
Team Am new to the Onestream. Can someone please guide me how to extract and load metadata in Onestream using flat files/Excel files. Regards Varun
Forum Discussion
Rhankey, Thanks for the detailed explanation. Even I am doing the similar excersise where i have to compare the UD1 dimension (Customer) with the mapping in SQL and change mapping as per the SQL. Recenlty we have downloaded the Mindstream Meta Data Manager and tried to alter existing mapping in the OneStream. However, It is ending up in adding new relationships. For instance I have existing cutomer C1 in Washington and i want to move it to New york. The OneStream is adding the customer C1 in bot Washington as well as New york.
I hope OneStram API call would help me here. Could you please share bussiness rule (by hiding any sensitive information) ?
As I mentioned in my prior response, when importing members or relationships, OS adds or modifies. It does not delete. You are adding a new relationship. You have to take care of removing the old relationship. You can do so manually, or you can use the API to do so. I have been using a utility I built a number of years ago that will delete orphaned members. I manually "remove relationship" of the member(s) I no longer want, then run my utility to clear them out of orphans without risking the live hierarchies. Remove relationships allows you to select parent or child members and select multiple members at once, so in a couple key clicks I can remove thousands of members, unlike delete member which is one base member at a time.