tag:blogger.com,1999:blog-8071277508022745895.post6045963994897347618..comments2024-02-02T03:22:14.041-08:00Comments on Hooked On Hyperion: Video: Automatically Generated Focused Aggregations for EssbaseAnonymoushttp://www.blogger.com/profile/06422579905887903022noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8071277508022745895.post-69079366653029031752015-08-11T14:50:07.554-07:002015-08-11T14:50:07.554-07:00Dmitry, from what planet are you? Still can't ...Dmitry, from what planet are you? Still can't believe the deepness of your analysis. Sounds truly crazy. Congrats!Unknownhttps://www.blogger.com/profile/01563567546203726613noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-62688221154872531842015-07-10T20:56:28.598-07:002015-07-10T20:56:28.598-07:00Thanks!
#I'll translate the question: which in...Thanks!<br />#I'll translate the question: which instrument is used to generate the script?<br /><br />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. <br /><br />Cheers,<br />DmitryAnonymoushttps://www.blogger.com/profile/06422579905887903022noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-63989360735448095922015-07-10T20:55:41.405-07:002015-07-10T20:55:41.405-07:00This log should give you an idea.
https://drive.go...This log should give you an idea.<br />https://drive.google.com/open?id=0B5kPaPeqTH0xRy1lNWhYVUxoV1kAnonymoushttps://www.blogger.com/profile/06422579905887903022noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-46777061121395281322015-07-10T20:44:25.323-07:002015-07-10T20:44:25.323-07:00Yes, pure-native Essbase. You need to enable trans...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<br />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.Anonymoushttps://www.blogger.com/profile/06422579905887903022noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-78068073110534599732015-07-10T05:19:44.888-07:002015-07-10T05:19:44.888-07:00I can't stop
Could you please provide full ...I can't stop <br /> Could you please provide full script generated from yours tool? er77https://www.blogger.com/profile/02314036829317745809noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-60071197387257809042015-07-10T01:08:14.836-07:002015-07-10T01:08:14.836-07:00are you using pure Essbase decision without Planni...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 ? er77https://www.blogger.com/profile/02314036829317745809noreply@blogger.comtag:blogger.com,1999:blog-8071277508022745895.post-26993290763402921392015-07-09T07:24:04.068-07:002015-07-09T07:24:04.068-07:00Великолепно !
только я не уловил , каким инстру...Великолепно ! <br /> только я не уловил , каким инструментом происходите генерация скрипта ? <br /><br />ER@essbase.ruer77https://www.blogger.com/profile/02314036829317745809noreply@blogger.com