1 Reply Latest reply: Dec 27, 2012 7:52 AM by HyperionNewbie RSS

    How to dump SQL tables into Essbase Cube

    887598
      Hi Experts,

      I am new to Hyperion Essbase, Can any one please help me on "How can we import tables from SQL database into Essbase Cube".

      Please let me know the different ways to do the same.


      Thank you in advance

      Ram
        • 1. Re: How to dump SQL tables into Essbase Cube
          HyperionNewbie
          884595 wrote:

          "How can we import tables from SQL database into Essbase Cube".
          Hi Ram,

          We dont import tables into Essbase, we define mapping from the source tables columns with the dimensions in outline using Rules files.
          Within Rules file you can define complex SQL queries and can do handful tranformations for data coulmns.
          Once you have defined the rule, you can reuse it.
          Note that you need to define an ODBC for your SQL database on Essbase server.

          You can also think of Essbase studio to import SQL tables and define mapping and load to Essbase cubes as well.

          Hope it helps.