Loading the attributes for sparse as well as dense Dimension in HPCM essbase cube

Hello,

In our project, we have 2 dense and 10 sparse dimensions and currently we are not handling the attribute dimension within the essbase.

Business want to see the attributes in the OBIEE reports which we are loading through the RDBMS to OBIEE.We recieve the file for attributes and we have ODI package to load these files into the relational table which will then get fetched by the OBIEE reports.

Now we want to do the improvement in this long process and want to load the attributed directly from essbase to OBIEE instead of handling it with the sepreate process via RDBMS tables.