Forum Stats

  • 3,817,322 Users
  • 2,259,312 Discussions
  • 7,893,749 Comments

Discussions

ADS file creation using an excel

User_YZQL2
User_YZQL2 Member Posts: 62 Blue Ribbon
edited Feb 17, 2019 12:47PM in Essbase On-Premise

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

Tagged:

Answers