1 Reply Latest reply: Jun 18, 2010 7:08 PM by GlennS_3 RSS

    How to extract data in a format recognized by MS Access

    780252
      Hello

      I need a help to extract a database from Essbase (excel addin or esscmd) to a file and create
      a database to put inside a Microsoft Access, the model i want is:

      ** I WANT THIS MODEL **

      Country     Month     Value
      Brazil     Jan     1000,00
      Brazil Feb 1500,00
      USA     Jan     3000,00
      USA     Feb     3500,00



      ** I JUST KNOW HOW TO MAKE THIS ONE **
           
           Jan     Fev
      Brazil     1000,00 1500,00
      USA     3000,00 3500,00


      This example is a small base from my database, i cant format all base to the wanted model, please, im begin in a essbase
      and need a help.


      Thx a lot and sorry for my bad english


      Claudio G. Silva
      Brazil / Parana