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.
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 ?
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.
Великолепно !
ReplyDeleteтолько я не уловил , каким инструментом происходите генерация скрипта ?
ER@essbase.ru
Thanks!
Delete#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
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 ?
ReplyDeleteYes, 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
DeleteYou 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.
I can't stop
ReplyDeleteCould you please provide full script generated from yours tool?
This log should give you an idea.
Deletehttps://drive.google.com/open?id=0B5kPaPeqTH0xRy1lNWhYVUxoV1k
Dmitry, from what planet are you? Still can't believe the deepness of your analysis. Sounds truly crazy. Congrats!
ReplyDelete