Sunday, June 21, 2015

Video: Automatically Generated Focused Aggregations for Essbase


7 comments:

  1. Великолепно !
    только я не уловил , каким инструментом происходите генерация скрипта ?

    ER@essbase.ru

    ReplyDelete
    Replies
    1. Thanks!
      #I'll translate the question: which instrument is used to generate the script?

      The script is generated by Java. First a Java method identifies new transaction (or multiple transactions if they need to be lumped together). Then Essbase Java API is used to connect to essbase cube and get all relevant information (dimension association, ancestors, their generations). Finally another Java method uses described algorithm to generate focused aggregation.

      Cheers,
      Dmitry

      Delete
  2. are you using pure Essbase decision without Planning ? how you decide what this right time to run aggregation ? do yo try to use SET UPDATECALC to determinate changed cells ? I am still impressed you huge work . Do you have any plan to share this code with free (GPL ) license ?

    ReplyDelete
    Replies
    1. Yes, pure-native Essbase. You need to enable transaction logging in essbase.cfg. the property would look something like TRANSACTIONLOGLOCATION TST_FA FA1 /home/oracle/trlog/TST_FA NATIVE ENABLE
      You can trigger execution either automatically by watching changes in transaction file (Java Watch Service API would be one option), or by using ODI monitor that would watch the same file, or on a scheduled basis if you want to lump some transactions together. I imaging running it automatically when the log file changed would make most sense.

      Delete
  3. I can't stop
    Could you please provide full script generated from yours tool?

    ReplyDelete
    Replies
    1. This log should give you an idea.
      https://drive.google.com/open?id=0B5kPaPeqTH0xRy1lNWhYVUxoV1k

      Delete
  4. Dmitry, from what planet are you? Still can't believe the deepness of your analysis. Sounds truly crazy. Congrats!

    ReplyDelete