Hi All,
we have a epma based on premise planning application. The metadata of this application is being maintained using shared library. Any changes to the metadata is being sent across to us by the users in an excel format, which we as of now are adding manually in the shared library. Just wanted to know if it is possible to create an ads file using this information. I could use macros/vba to manipulate this information sent by users and generate an ads file in the required format. Also, changes include both creation of new dimension members as well as moving of a member to a new hierarchy.
Thanks,
Dev