ODTUG Aggregator ODTUG Blogs http://localhost:8080 Tue, 22 May 2018 09:45:21 +0000 http://aggrssgator.com/ Announcing the 2018 ODTUG Innovation Award Nominations @odtug https://www.odtug.com/p/bl/et/blogaid=803&source=1 Introducing this year's 2018 ODTUG Innovation Award Nominations! ODTUG https://www.odtug.com/p/bl/et/blogaid=803&source=1 Tue May 22 2018 08:38:16 GMT-0400 (EDT) Announcing the 2018 ODTUG Innovation Award Nominations https://www.odtug.com/p/bl/et/blogaid=803&source=1 Introducing this year's 2018 ODTUG Innovation Award Nominations! ODTUG https://www.odtug.com/p/bl/et/blogaid=803&source=1 Tue May 22 2018 08:38:16 GMT-0400 (EDT) Fixing Oracle BI Performance Issues: A Non-Technical Guide @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/obiee%20performance.jpg?t=1526938888034" alt="obiee performance" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>Nearly all Oracle BI customers we speak with have noticeable performance issues. Business users complain about having to wait too long for their reports, and developers are at a loss as to what their options are. And, no one wants to spend time tuning an environment instead of implementing direct business requirements. Unfortunately, there are no shortcuts or quick-fixes to improving the performance of an Oracle BI environment. Normal approaches involve either outsourcing the efforts to a consultancy or attempting to wade through the difficult process on your own. While both options initially seem fine, they’re not maintainable.</p> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ffixing-oracle-bi-performance-issues&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Nicholas Padgett https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues Mon May 21 2018 17:42:03 GMT-0400 (EDT) Fixing Oracle BI Performance Issues: A Non-Technical Guide https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/obiee%20performance.jpg?t=1526938888034" alt="obiee performance" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>Nearly all Oracle BI customers we speak with have noticeable performance issues. Business users complain about having to wait too long for their reports, and developers are at a loss as to what their options are. And, no one wants to spend time tuning an environment instead of implementing direct business requirements. Unfortunately, there are no shortcuts or quick-fixes to improving the performance of an Oracle BI environment. Normal approaches involve either outsourcing the efforts to a consultancy or attempting to wade through the difficult process on your own. While both options initially seem fine, they’re not maintainable.</p> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ffixing-oracle-bi-performance-issues&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Nicholas Padgett https://www.us-analytics.com/hyperionblog/fixing-oracle-bi-performance-issues Mon May 21 2018 17:42:03 GMT-0400 (EDT) Which Finance KPIs Should CFOs Be Watching? @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/top-finance-kpis <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/top-finance-kpis" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/top%20finance%20kpis.jpg?t=1526938888034" alt="top finance kpis" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>KPIs can help assess the health of your business and, ultimately, help CFOs keep track of their three most important goals — keeping track of the past, understanding the present financial situation, and planning for the future.</p> <p>Besides helping you track performance, KPIs serve to help you see if there are any potential issues and address them before they snowball out of control. In this blog post, we’ll look at the KPIS that CFOs should be watching.</p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ftop-finance-kpis&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/top-finance-kpis Fri May 18 2018 17:11:28 GMT-0400 (EDT) Which Finance KPIs Should CFOs Be Watching? https://www.us-analytics.com/hyperionblog/top-finance-kpis <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/top-finance-kpis" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/top%20finance%20kpis.jpg?t=1526938888034" alt="top finance kpis" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>KPIs can help assess the health of your business and, ultimately, help CFOs keep track of their three most important goals — keeping track of the past, understanding the present financial situation, and planning for the future.</p> <p>Besides helping you track performance, KPIs serve to help you see if there are any potential issues and address them before they snowball out of control. In this blog post, we’ll look at the KPIS that CFOs should be watching.</p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ftop-finance-kpis&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/top-finance-kpis Fri May 18 2018 17:11:28 GMT-0400 (EDT) FDMEE Multi-Dimension Mapping @ecapitaladvisor @orclEPMblogs @orclEPMblogs http://www.ecapitaladvisors.com/blog/fdmee-multi-dimension-mapping/ <p>In FDMEE the mapping functionality is a fundamental purpose of the tool. Member mappings act as the middle man between Source members...</p> <p>The post <a rel="nofollow" href="http://www.ecapitaladvisors.com/blog/fdmee-multi-dimension-mapping/">FDMEE Multi-Dimension Mapping</a> appeared first on <a rel="nofollow" href="http://www.ecapitaladvisors.com">eCapital Advisors</a>.</p> Amy Stine http://www.ecapitaladvisors.com/?p=9396 Fri May 18 2018 16:21:05 GMT-0400 (EDT) FDMEE Multi-Dimension Mapping http://www.ecapitaladvisors.com/blog/fdmee-multi-dimension-mapping/ <p>In FDMEE the mapping functionality is a fundamental purpose of the tool. Member mappings act as the middle man between Source members...</p> <p>The post <a rel="nofollow" href="http://www.ecapitaladvisors.com/blog/fdmee-multi-dimension-mapping/">FDMEE Multi-Dimension Mapping</a> appeared first on <a rel="nofollow" href="http://www.ecapitaladvisors.com">eCapital Advisors</a>.</p> Amy Stine http://www.ecapitaladvisors.com/?p=9396 Fri May 18 2018 16:21:05 GMT-0400 (EDT) ODTUG User Group Integrating New Tools to Be More Data Driven @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=802&source=1 ODTUG User Group Integrating New Tools to Be More Data Driven:Oracle Essbase Cloud and Data Visualization Support Annual User Group Conference Planning ODTUG https://www.odtug.com/p/bl/et/blogaid=802&source=1 Fri May 18 2018 14:36:56 GMT-0400 (EDT) ODTUG User Group Integrating New Tools to Be More Data Driven https://www.odtug.com/p/bl/et/blogaid=802&source=1 ODTUG User Group Integrating New Tools to Be More Data Driven:Oracle Essbase Cloud and Data Visualization Support Annual User Group Conference Planning ODTUG https://www.odtug.com/p/bl/et/blogaid=802&source=1 Fri May 18 2018 14:36:56 GMT-0400 (EDT) An Update Re: Oracle's EPM 11.1.2.4.900 Release @CheckPointllc http://blog.checkpointllc.com/an-update-re-oracles-epm-11.1.2.4.900-release <p>As an update to CheckPoint’s Blog on May 10th on the subject of Oracle’s EPM 11.1.2.4.900 release, we are posting our latest findings. The testing, and subsequent results are from our lab environment using simple test applications. The results may or may not be indicative of what we would expect to find in a “real-world” example. Your mileage may vary!</p> <p>The installation process itself is nearly identical to the 11.1.2.4.0 process, the absence of the Reporting and Analysis Framework &amp; Services and Disclosure Management selections being the only differences. Similarly the Configuration process is all but the same as well, save for the same absences. It is important to note that the elimination of the Reporting and Analysis components eliminates the option to do an “in place upgrade”.&nbsp;</p> <p>Requiring a new environment and installation also requires migrating/upgrading current EPM applications and content; the gorilla in the room! According to Oracle’s documentation there is no upgrade path, applications must be recreated. While we at CheckPoint don’t want to contradict Oracle’s official position, we have had some success migrating HFM, Planning, Essbase and Financial Reporting content from an existing 11.1.2.4 environment to an 11.1.2.4.900 instance. Again, these were simple test applications and reports, however our results lead us to the conclusion that it may be possible to upgrade a client’s applications from 11.1.2.4.x to 11.1.2.4.900 using common methods.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fan-update-re-oracles-epm-11.1.2.4.900-release&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Damon Hannah http://blog.checkpointllc.com/an-update-re-oracles-epm-11.1.2.4.900-release Fri May 18 2018 13:08:58 GMT-0400 (EDT) An Update Re: Oracle's EPM 11.1.2.4.900 Release http://blog.checkpointllc.com/an-update-re-oracles-epm-11.1.2.4.900-release <p>As an update to CheckPoint’s Blog on May 10th on the subject of Oracle’s EPM 11.1.2.4.900 release, we are posting our latest findings. The testing, and subsequent results are from our lab environment using simple test applications. The results may or may not be indicative of what we would expect to find in a “real-world” example. Your mileage may vary!</p> <p>The installation process itself is nearly identical to the 11.1.2.4.0 process, the absence of the Reporting and Analysis Framework &amp; Services and Disclosure Management selections being the only differences. Similarly the Configuration process is all but the same as well, save for the same absences. It is important to note that the elimination of the Reporting and Analysis components eliminates the option to do an “in place upgrade”.&nbsp;</p> <p>Requiring a new environment and installation also requires migrating/upgrading current EPM applications and content; the gorilla in the room! According to Oracle’s documentation there is no upgrade path, applications must be recreated. While we at CheckPoint don’t want to contradict Oracle’s official position, we have had some success migrating HFM, Planning, Essbase and Financial Reporting content from an existing 11.1.2.4 environment to an 11.1.2.4.900 instance. Again, these were simple test applications and reports, however our results lead us to the conclusion that it may be possible to upgrade a client’s applications from 11.1.2.4.x to 11.1.2.4.900 using common methods.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fan-update-re-oracles-epm-11.1.2.4.900-release&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Damon Hannah http://blog.checkpointllc.com/an-update-re-oracles-epm-11.1.2.4.900-release Fri May 18 2018 13:08:58 GMT-0400 (EDT) Emerging Tech Unconference Session & Changing Landscape Panels @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=801&source=1 The tech world is constantly evolving and so is ODTUG Kscope! This year, we are introducing a new Emerging Tech unconference breakout session and careers and changing landscape panels for DBA/Developers and EPM/BI. ODTUG https://www.odtug.com/p/bl/et/blogaid=801&source=1 Thu May 17 2018 13:38:59 GMT-0400 (EDT) Emerging Tech Unconference Session & Changing Landscape Panels https://www.odtug.com/p/bl/et/blogaid=801&source=1 The tech world is constantly evolving and so is ODTUG Kscope! This year, we are introducing a new Emerging Tech unconference breakout session and careers and changing landscape panels for DBA/Developers and EPM/BI. ODTUG https://www.odtug.com/p/bl/et/blogaid=801&source=1 Thu May 17 2018 13:38:59 GMT-0400 (EDT) The Importance of Oracle User Groups @opal_epm https://womaninepm.com/2018/05/17/the-importance-of-oracle-user-groups/ (credit: Google images) Oracle user groups are wonderfully diverse and knowledgeable technical communities. They&#8217;ve been around forever and they offer many benefits to their users. I&#8217;ve even read someone&#8217;s explanation on how being part of one has directly changed their life. My career is certainly forever changed based on my involvement, and I am thankful that &#8230; <a href="https://womaninepm.com/2018/05/17/the-importance-of-oracle-user-groups/" class="more-link">Continue reading <span class="screen-reader-text">The Importance of Oracle User&#160;Groups</span></a> OpaL http://womaninepm.com/?p=12085 Thu May 17 2018 09:30:58 GMT-0400 (EDT) The Importance of Oracle User Groups https://womaninepm.com/2018/05/17/the-importance-of-oracle-user-groups/ (credit: Google images) Oracle user groups are wonderfully diverse and knowledgeable technical communities. They&#8217;ve been around forever and they offer many benefits to their users. I&#8217;ve even read someone&#8217;s explanation on how being part of one has directly changed their life. My career is certainly forever changed based on my involvement, and I am thankful that &#8230; <a href="https://womaninepm.com/2018/05/17/the-importance-of-oracle-user-groups/" class="more-link">Continue reading <span class="screen-reader-text">The Importance of Oracle User&#160;Groups</span></a> OpaL http://womaninepm.com/?p=12085 Thu May 17 2018 09:30:58 GMT-0400 (EDT) ODTUG Kscope18 Update #3 @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=800&source=1 We are really counting down to the conference now. Less than four weeks to go until the best Oracle technical conference of the year! Are you ready? ODTUG https://www.odtug.com/p/bl/et/blogaid=800&source=1 Tue May 15 2018 14:24:52 GMT-0400 (EDT) ODTUG Kscope18 Update #3 https://www.odtug.com/p/bl/et/blogaid=800&source=1 We are really counting down to the conference now. Less than four weeks to go until the best Oracle technical conference of the year! Are you ready? ODTUG https://www.odtug.com/p/bl/et/blogaid=800&source=1 Tue May 15 2018 14:24:52 GMT-0400 (EDT) PBCS Bug Alert: LCM export contains planning security group xml file even if group has been deleted from Access Control @epminsight http://epminsight.com/547/pbcs-bug-alert-lcm-export-contains-planning-security-group-xml-file-even-if-group-has-been-deleted-from-access-control/ <p>I was trying to automate a PBCS security update process where in I download existing security from PBCS, have the admin update specific groups xml files and then re-upload the security back to PBCS. The planning security download contains one xml file for each group that has been provisioned. The xml file contains the member level security that has been assigned to the group.</p> <p>After a clean up of unwanted groups, I noticed that the planning security that gets exported also contained specific xml files for groups that had been deleted through access control. I also noticed that these groups were still present on the members on which they had been assigned as part of security setup. I removed the security manually and then re-exported the planning security. This time as well, the xml files were present however they did not contain the security definition.</p> <p>You can recreate this issue with the below steps:<br /> 1. Create a new Group in Access Control and assign access to one of the members in any dimension<br /> 2. Export Security &#8211; You can see the newly created group in LCM export.<br /> 3. Now delete the group from Access Control<br /> 4. Export Security again &#8211; The group that was deleted, is still present in the LCM export.</p> <p>I logged a call with Oracle Support and we concluded that this was a bug. A workaround (DOC ID 2077859.1) was given which is basically exporting a complete security back up using LCM and importing the same without any change. After this the new LCM export will not contain the deleted groups. Looks like an import operation was necessary to force the synchronization.</p> <p>I guess an on-prem equivalent of &#8220;Remove Non-Provisioned Users/Groups&#8221; option is needed to force the synchronization and may be an epm automate command so the synchronization could be automated. Better still, would be to auto synchronize every time a group deletion was performed.</p> <p>The post <a rel="nofollow" href="http://epminsight.com/547/pbcs-bug-alert-lcm-export-contains-planning-security-group-xml-file-even-if-group-has-been-deleted-from-access-control/">PBCS Bug Alert: LCM export contains planning security group xml file even if group has been deleted from Access Control</a> appeared first on <a rel="nofollow" href="http://epminsight.com">epminsight</a>.</p> Amit Sahasrabudhe http://epminsight.com/?p=547 Mon May 14 2018 20:39:20 GMT-0400 (EDT) PBCS Bug Alert: LCM export contains planning security group xml file even if group has been deleted from Access Control http://epminsight.com/547/pbcs-bug-alert-lcm-export-contains-planning-security-group-xml-file-even-if-group-has-been-deleted-from-access-control/ <p>I was trying to automate a PBCS security update process where in I download existing security from PBCS, have the admin update specific groups xml files and then re-upload the security back to PBCS. The planning security download contains one xml file for each group that has been provisioned. The xml file contains the member level security that has been assigned to the group.</p> <p>After a clean up of unwanted groups, I noticed that the planning security that gets exported also contained specific xml files for groups that had been deleted through access control. I also noticed that these groups were still present on the members on which they had been assigned as part of security setup. I removed the security manually and then re-exported the planning security. This time as well, the xml files were present however they did not contain the security definition.</p> <p>You can recreate this issue with the below steps:<br /> 1. Create a new Group in Access Control and assign access to one of the members in any dimension<br /> 2. Export Security &#8211; You can see the newly created group in LCM export.<br /> 3. Now delete the group from Access Control<br /> 4. Export Security again &#8211; The group that was deleted, is still present in the LCM export.</p> <p>I logged a call with Oracle Support and we concluded that this was a bug. A workaround (DOC ID 2077859.1) was given which is basically exporting a complete security back up using LCM and importing the same without any change. After this the new LCM export will not contain the deleted groups. Looks like an import operation was necessary to force the synchronization.</p> <p>I guess an on-prem equivalent of &#8220;Remove Non-Provisioned Users/Groups&#8221; option is needed to force the synchronization and may be an epm automate command so the synchronization could be automated. Better still, would be to auto synchronize every time a group deletion was performed.</p> <p>The post <a rel="nofollow" href="http://epminsight.com/547/pbcs-bug-alert-lcm-export-contains-planning-security-group-xml-file-even-if-group-has-been-deleted-from-access-control/">PBCS Bug Alert: LCM export contains planning security group xml file even if group has been deleted from Access Control</a> appeared first on <a rel="nofollow" href="http://epminsight.com">epminsight</a>.</p> Amit Sahasrabudhe http://epminsight.com/?p=547 Mon May 14 2018 20:39:20 GMT-0400 (EDT) A REST API Primer for EPM Users & Developers https://www.jasonwjones.com/2018/05/a-rest-api-primer-for-epm-users-developers/ There&#8217;s a lot of excitement in the EPM world these days when it comes to REST APIs – and rightfully so. As a developer heavily invested in the EPM space I am excited about some of the possibilities these new APIs offer – and what they will offer in the future. But all of this great [&#8230;] jason http://www.jasonwjones.com/?p=2117 Mon May 14 2018 11:21:52 GMT-0400 (EDT) A REST API Primer for EPM Users & Developers @jwj @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.jasonwjones.com/2018/05/a-rest-api-primer-for-epm-users-developers/ There&#8217;s a lot of excitement in the EPM world these days when it comes to REST APIs – and rightfully so. As a developer heavily invested in the EPM space I am excited about some of the possibilities these new APIs offer – and what they will offer in the future. But all of this great [&#8230;] jason http://www.jasonwjones.com/?p=2117 Mon May 14 2018 11:21:52 GMT-0400 (EDT) FDMEE/Data Management - Managing period mappings - Part 2 http://john-goodwin.blogspot.com/2018/05/fdmeedata-management-managing-period.html <div dir="ltr" style="text-align: left;" trbidi="on">In the last part, I went through Data Management/FDMEE period mappings and possible methods to automate populating them. The solution concentrated on the cloud but could still be used with on-premise, the idea was to update the XML period mapping files generated by snapshots and then import them back to generate the new mappings.<br /><br />With Data Management in the cloud there is currently no custom Jython scripting allowed, so this pushes you to develop some solutions outside of the cloud. With on-premise FDMEE it is a different story, as you are able to build the solutions into the product using custom scripting. Also with on-premise FDMEE you have the option of the Excel interface which allows you to directly load files to the FDMEE database tables.<br /><br />In this post I am going to go through a couple of possible methods to update period mappings directly from FDMEE.<br /><br />In the FDMEE, all the period mapping in the UI are populated by reading the information from a database table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-z_6o9nPFv10/WvhgEyYmQBI/AAAAAAAAJss/neOoGHTVyRU__Yjq-9xx2polF0KsTdSeACLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="259" data-original-width="826" height="200" src="https://2.bp.blogspot.com/-z_6o9nPFv10/WvhgEyYmQBI/AAAAAAAAJss/neOoGHTVyRU__Yjq-9xx2polF0KsTdSeACLcBGAs/s640/image001.png" width="640" /></a></div><br />For global period mappings, these are populated from a table named “<b>TPOVPERIOD</b>”<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-ISHXR1kWod8/WvhgEwmqmnI/AAAAAAAAJsw/LcxadS7PHaUmPcSN1DTOfzSTtRjCWdzrACLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="171" data-original-width="884" height="122" src="https://2.bp.blogspot.com/-ISHXR1kWod8/WvhgEwmqmnI/AAAAAAAAJsw/LcxadS7PHaUmPcSN1DTOfzSTtRjCWdzrACLcBGAs/s640/image002.png" width="640" /></a></div><br />To be able to update the mapping table directly you can go to the Excel interface in the UI and select the entity type as “Period Mapping”. Select a file and location and download.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-JbyBqQTvlM0/WvhgExNgOdI/AAAAAAAAJs0/LX2o1T7X8wo1Fvq4CykW8Z_cwMC7eGndQCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="404" data-original-width="732" height="353" src="https://3.bp.blogspot.com/-JbyBqQTvlM0/WvhgExNgOdI/AAAAAAAAJs0/LX2o1T7X8wo1Fvq4CykW8Z_cwMC7eGndQCLcBGAs/s640/image003.png" width="640" /></a></div><br />You can then populate the Excel template.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-VnYgB6S8bGk/WvhgFhgpwzI/AAAAAAAAJs4/PRyEIkWdbS4mXybDFhfJl7v3oLtuLqTzACLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="86" data-original-width="875" height="62" src="https://4.bp.blogspot.com/-VnYgB6S8bGk/WvhgFhgpwzI/AAAAAAAAJs4/PRyEIkWdbS4mXybDFhfJl7v3oLtuLqTzACLcBGAs/s640/image004.png" width="640" /></a></div><br />Before uploading the file, it is worth pointing out the following rules with the Excel interface:<br /><ul style="text-align: left;"><li><b>Data is only inserted. It cannot be updated or deleted.</b></li><li><b>Data is not validated.</b></li><li><b>When FDMEE encounters a duplicate row, the row is skipped.</b></li></ul>Once you are happy, the Excel file can be uploaded.<br /><br /><div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-1qoc6I2Z2lY/WvhgFufeqAI/AAAAAAAAJs8/BxLC-tRgWi8mfBJ_xOvxcLRVYMtNotXwwCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="292" data-original-width="729" height="256" src="https://4.bp.blogspot.com/-1qoc6I2Z2lY/WvhgFufeqAI/AAAAAAAAJs8/BxLC-tRgWi8mfBJ_xOvxcLRVYMtNotXwwCLcBGAs/s640/image005.png" width="640" /></a></div><br />The FDMEE database table has had information from the Excel file inserted.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-a5BF3vXiaqk/WvhgF-C6jCI/AAAAAAAAJtA/v3HOEMGSq7oy2UwF0KOxUuRpW9HdCSyLgCLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="131" data-original-width="888" height="94" src="https://3.bp.blogspot.com/-a5BF3vXiaqk/WvhgF-C6jCI/AAAAAAAAJtA/v3HOEMGSq7oy2UwF0KOxUuRpW9HdCSyLgCLcBGAs/s640/image006.png" width="640" /></a></div><br />Back in the UI, the global period mappings now contain the two new mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-vVRBWBzophU/WvhgGE-g-KI/AAAAAAAAJtE/8EM5DXZX7tInW44_MxZDIRfBc1UwOi6SwCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="159" data-original-width="801" height="127" src="https://2.bp.blogspot.com/-vVRBWBzophU/WvhgGE-g-KI/AAAAAAAAJtE/8EM5DXZX7tInW44_MxZDIRfBc1UwOi6SwCLcBGAs/s640/image007.png" width="640" /></a></div><br />This is all fine, but what if you want something more dynamic where you don’t have to be bothered with populating Excel files? Well this is where a bit of custom scripting could help.<br /><br />I am going to go through an example of updating the global and application period mapping tables by using a custom script, this will have parameters to define the start month/year and number of months to generate.<br /><br />The application period mappings are stored in a table named “TPOVPERIODADAPTOR”, the only difference from the global mapping table is the “intsystemkey” column which holds the target application name.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-zTui0qHkl2Q/WvhgGo-l5uI/AAAAAAAAJtI/zDkkYxmQMjUZHT9OzEmF4r0U4DtjJWg5gCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="131" data-original-width="942" height="88" src="https://3.bp.blogspot.com/-zTui0qHkl2Q/WvhgGo-l5uI/AAAAAAAAJtI/zDkkYxmQMjUZHT9OzEmF4r0U4DtjJWg5gCLcBGAs/s640/image008.png" width="640" /></a></div><br />First a new script is registered in FDMEE, I will get on to the details of the Jython script later.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-wm7yXSUdnD8/WvhgGshkZQI/AAAAAAAAJtM/UWIo1hq27JcxyzkorbJvPT8Dos2QDUOQQCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="244" data-original-width="1050" height="148" src="https://4.bp.blogspot.com/-wm7yXSUdnD8/WvhgGshkZQI/AAAAAAAAJtM/UWIo1hq27JcxyzkorbJvPT8Dos2QDUOQQCLcBGAs/s640/image009.png" width="640" /></a></div><br />There are four parameters, one which defines which defines the start month, instead of allowing direct input to minimise errors, a query type has been used to generate the periods (based on Oracle database).<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-YSE2IwiVY6Y/WvhgGzW24lI/AAAAAAAAJtQ/TijjRSJvG7sUz7nGzee3NlA0Mlpi64FoACLcBGAs/s1600/image010.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="777" height="143" src="https://4.bp.blogspot.com/-YSE2IwiVY6Y/WvhgGzW24lI/AAAAAAAAJtQ/TijjRSJvG7sUz7nGzee3NlA0Mlpi64FoACLcBGAs/s640/image010.png" width="640" /></a></div><br />Another query has been created to generate years where a start year can be selected.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-6s-r4ik5jRQ/WvhgHI19XEI/AAAAAAAAJtU/7sdL9FenKsMZzRI8OMIX7WYfRKe8VpTegCLcBGAs/s1600/image011.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="553" src="https://1.bp.blogspot.com/-6s-r4ik5jRQ/WvhgHI19XEI/AAAAAAAAJtU/7sdL9FenKsMZzRI8OMIX7WYfRKe8VpTegCLcBGAs/s1600/image011.png" /></a></div><br />The number of months parameter has been set as static so they are manually entered.<br /><br />The target application name is defined by a SQL query, there is one already by default with FDMEE.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-IIp-g1GK0t4/WvhgHJxjaXI/AAAAAAAAJtY/yamNmtF82wUtmMpJTa1PWzs_tHEqKlhuQCLcBGAs/s1600/image012.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="182" data-original-width="734" height="157" src="https://2.bp.blogspot.com/-IIp-g1GK0t4/WvhgHJxjaXI/AAAAAAAAJtY/yamNmtF82wUtmMpJTa1PWzs_tHEqKlhuQCLcBGAs/s640/image012.png" width="640" /></a></div><br />On to executing the script, the group and script are selected.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-eIvg1q--Q_4/WvhgHg7T6oI/AAAAAAAAJtc/Rlzht84CrX0o_6dGlPEkWC4L_bA1DIncACLcBGAs/s1600/image013.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="195" data-original-width="273" src="https://3.bp.blogspot.com/-eIvg1q--Q_4/WvhgHg7T6oI/AAAAAAAAJtc/Rlzht84CrX0o_6dGlPEkWC4L_bA1DIncACLcBGAs/s1600/image013.png" /></a></div><br />When the script is executed a window is displayed with the available parameters.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-tfwNBp1eQLI/WvhgHj2V7ZI/AAAAAAAAJtg/9JQzXD823EkkMuRnl9iJWo7OI0mpDZs2gCLcBGAs/s1600/image014.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="148" data-original-width="468" src="https://2.bp.blogspot.com/-tfwNBp1eQLI/WvhgHj2V7ZI/AAAAAAAAJtg/9JQzXD823EkkMuRnl9iJWo7OI0mpDZs2gCLcBGAs/s1600/image014.png" /></a></div><br />If start month is selected, a list of months is displayed for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-uteAkfEGcKA/WvhgHzXiF4I/AAAAAAAAJtk/fC0Axm4a1VMZJZVuIKXCMXqn7QE9psYgQCLcBGAs/s1600/image015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="298" data-original-width="162" src="https://1.bp.blogspot.com/-uteAkfEGcKA/WvhgHzXiF4I/AAAAAAAAJtk/fC0Axm4a1VMZJZVuIKXCMXqn7QE9psYgQCLcBGAs/s1600/image015.png" /></a></div><br />If start year is selected, a list of years is displayed for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Rgey87ujLes/WvhgIEGjjWI/AAAAAAAAJto/bizyGAePnf8fLHmvMr5oroA6Geu_WsFOwCLcBGAs/s1600/image016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="317" data-original-width="164" src="https://2.bp.blogspot.com/-Rgey87ujLes/WvhgIEGjjWI/AAAAAAAAJto/bizyGAePnf8fLHmvMr5oroA6Geu_WsFOwCLcBGAs/s1600/image016.png" /></a></div><br />For this example, I am going to generate four months of period mappings, any number can be entered.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Jt9xkKoYRlk/WvhgIRO1DQI/AAAAAAAAJts/27vy01jt2Ys57z7U6ooklIonN_nq_HrewCLcBGAs/s1600/image017.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="148" data-original-width="316" src="https://2.bp.blogspot.com/-Jt9xkKoYRlk/WvhgIRO1DQI/AAAAAAAAJts/27vy01jt2Ys57z7U6ooklIonN_nq_HrewCLcBGAs/s1600/image017.png" /></a></div><br />I have left the target application blank as I just want to update the global mapping period table.<br /><br />After executing the script, a message is displayed to inform how many rows have been inserted into the period mapping table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-hViRXodcsz4/WvhlquBMbrI/AAAAAAAAJvU/XBo8acU8GBYS5kqF-7qviEvugk_5j-_jwCLcBGAs/s1600/amap1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="95" data-original-width="293" src="https://1.bp.blogspot.com/-hViRXodcsz4/WvhlquBMbrI/AAAAAAAAJvU/XBo8acU8GBYS5kqF-7qviEvugk_5j-_jwCLcBGAs/s1600/amap1.png" /></a></div><br />The database table has been populated with the 4 months of mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-zV9U-HdoAzE/WvhgIkrzRQI/AAAAAAAAJt0/wVgImvoy6Y0nLvJHz3ohWXevK7UZJB3sQCLcBGAs/s1600/image019.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="840" height="132" src="https://2.bp.blogspot.com/-zV9U-HdoAzE/WvhgIkrzRQI/AAAAAAAAJt0/wVgImvoy6Y0nLvJHz3ohWXevK7UZJB3sQCLcBGAs/s640/image019.png" width="640" /></a></div><br />These are available in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-FM_UktRsmd4/WvhgI6AK7nI/AAAAAAAAJt4/yqtI_8F7XMgp941Uj-noHDedn5zfNsJMwCLcBGAs/s1600/image020.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="187" data-original-width="869" height="137" src="https://1.bp.blogspot.com/-FM_UktRsmd4/WvhgI6AK7nI/AAAAAAAAJt4/yqtI_8F7XMgp941Uj-noHDedn5zfNsJMwCLcBGAs/s640/image020.png" width="640" /></a></div><br />If I run the script again and this time select the application, a list of target applications is available for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-7hYlkyDQyKc/WvhgJacNFZI/AAAAAAAAJt8/o0WHv9zEUEccYE-2Jfrp4anfgti1TGgvQCLcBGAs/s1600/image021.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="317" data-original-width="309" src="https://3.bp.blogspot.com/-7hYlkyDQyKc/WvhgJacNFZI/AAAAAAAAJt8/o0WHv9zEUEccYE-2Jfrp4anfgti1TGgvQCLcBGAs/s1600/image021.png" /></a></div><br />I selected the Vision application and to generate 3 months of mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-cujee3n2YXA/WvhgJcGdesI/AAAAAAAAJuA/sV8c-NYVe6cyksFFR71uC8euAUs3U7sEQCLcBGAs/s1600/image022.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="150" data-original-width="489" src="https://1.bp.blogspot.com/-cujee3n2YXA/WvhgJcGdesI/AAAAAAAAJuA/sV8c-NYVe6cyksFFR71uC8euAUs3U7sEQCLcBGAs/s1600/image022.png" /></a></div><br />Once executed, a message confirms 3 rows have been inserted into the mapping table.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-9Ys-jAxJZBs/Wvhl3lnhXSI/AAAAAAAAJvY/Oy4x9pGWt8Mtvdx_vL2PzCVRfI4t0VzugCLcBGAs/s1600/amap2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="96" data-original-width="299" src="https://1.bp.blogspot.com/-9Ys-jAxJZBs/Wvhl3lnhXSI/AAAAAAAAJvY/Oy4x9pGWt8Mtvdx_vL2PzCVRfI4t0VzugCLcBGAs/s1600/amap2.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>The application period mapping database table has been updated with the 3 new mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-0NZGbqjPQhc/WvhgJ5AMjmI/AAAAAAAAJuI/sUP6crHMiVM61CXQ3UFNDxuOLxLv4oZLACLcBGAs/s1600/image024.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="150" data-original-width="905" height="106" src="https://3.bp.blogspot.com/-0NZGbqjPQhc/WvhgJ5AMjmI/AAAAAAAAJuI/sUP6crHMiVM61CXQ3UFNDxuOLxLv4oZLACLcBGAs/s640/image024.png" width="640" /></a></div><br />These are then available under application mappings in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-ZmyydSegpG4/WvhgKNFEWoI/AAAAAAAAJuM/nR6syBDXMBAeuPXq6jpT0-JstQ4OaK41wCLcBGAs/s1600/image025.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="213" data-original-width="881" height="154" src="https://3.bp.blogspot.com/-ZmyydSegpG4/WvhgKNFEWoI/AAAAAAAAJuM/nR6syBDXMBAeuPXq6jpT0-JstQ4OaK41wCLcBGAs/s640/image025.png" width="640" /></a></div><br />If I run the script again with the same parameter values, the message this time informs that no rows were inserted as the period keys already exist.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-rYMbdXz92l0/Wvhl9WBM-eI/AAAAAAAAJvg/LYjSQE_r2Q8arHubo38_lrHyRxZLDWljACLcBGAs/s1600/amap3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="96" data-original-width="759" height="80" src="https://3.bp.blogspot.com/-rYMbdXz92l0/Wvhl9WBM-eI/AAAAAAAAJvg/LYjSQE_r2Q8arHubo38_lrHyRxZLDWljACLcBGAs/s640/amap3.png" width="640" /></a></div><br />On to the Jython script that does all the work to populate the mapping tables.<br /><br />I am not going to go through it in detail as the script is already commented so should give you a good idea what is happening.<br /><br />In summary, the start month, year, number of months and target application parameter values are retrieved and stored.<br /><br />There are similar SQL statements depending on whether a target application has been selected or not.&nbsp; There is a query to count if there are duplicate period mappings and an insert statement to the relevant period mapping table.<br /><br />The start month and year are converted into a valid date.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-BiONmbdTrpU/WvhnfPHrcRI/AAAAAAAAJv4/ZbXsQHlcGxEXh7szWqJEcwYGU35ImLuXQCLcBGAs/s1600/amap5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="775" data-original-width="684" src="https://2.bp.blogspot.com/-BiONmbdTrpU/WvhnfPHrcRI/AAAAAAAAJv4/ZbXsQHlcGxEXh7szWqJEcwYGU35ImLuXQCLcBGAs/s1600/amap5.png" /></a></div><br />A loop cycles through the number of months that need to be populated into the mapping table.<br /><br />The period key is generated by calculating the last day of the month for the current date and appended to the SQL parameters.<br /><br />The last period key, period description and year target are generated and appended to the SQL parameters.<br /><br />The target period quarter, year and day are not used in this example so nulls are generated in the SQL parameters.<br /><br />The query is executed to check if a period key already exists for the current period key that will be inserted into the mapping table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-IHYxHEP2dj0/WvhgKmYZ2pI/AAAAAAAAJuY/y4pAVEU9vaMpdWlzQJPzOF3cdjI-Mb4ogCLcBGAs/s1600/image028.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="665" data-original-width="608" src="https://1.bp.blogspot.com/-IHYxHEP2dj0/WvhgKmYZ2pI/AAAAAAAAJuY/y4pAVEU9vaMpdWlzQJPzOF3cdjI-Mb4ogCLcBGAs/s1600/image028.png" /></a></div><br />If there is already an existing period key, store the duplicate key.<br /><br />If there is not an existing period key, insert the period information into the mapping table.<br /><br />Then the date moves forward one month and the process is repeated until all months have been looped through.<br /><br />Finally, a message is displayed to inform how many rows were inserted and if there were any period key duplicates.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-GuXOmQaKGSM/WvhmB-JvSgI/AAAAAAAAJvk/pjYjrF64i8s3RBIkA9cRCaIGHWV88RXmQCLcBGAs/s1600/amap4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="410" data-original-width="767" height="342" src="https://2.bp.blogspot.com/-GuXOmQaKGSM/WvhmB-JvSgI/AAAAAAAAJvk/pjYjrF64i8s3RBIkA9cRCaIGHWV88RXmQCLcBGAs/s640/amap4.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><br />If you are running FDMEE 11.1.2.4.210+ then you can take advantage of the REST API to execute the custom script, I have covered the FDMEE REST API in detail and you can read about it starting <b><a href="http://john-goodwin.blogspot.co.uk/2016/12/fdmee-and-rest-is-up-to-you-part-1.html">here</a></b><br /><br />An example using a REST client to generate 12 months of mapping starting from January 2021 would be:<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-wGj3LxUBiuE/WvhgLC7IGCI/AAAAAAAAJug/naEHD3oRTGotvwWEkkgESwYpxOHhrYHJgCLcBGAs/s1600/image030.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="252" data-original-width="666" src="https://2.bp.blogspot.com/-wGj3LxUBiuE/WvhgLC7IGCI/AAAAAAAAJug/naEHD3oRTGotvwWEkkgESwYpxOHhrYHJgCLcBGAs/s1600/image030.png" /></a></div><br />Once the script has completed the period mappings will be available in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-8NJu1S0u3NQ/WvhgLKFxTcI/AAAAAAAAJuk/-7DugvfZra03Ja7Jccq2k7tw7QA3syLeACLcBGAs/s1600/image031.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="860" height="290" src="https://4.bp.blogspot.com/-8NJu1S0u3NQ/WvhgLKFxTcI/AAAAAAAAJuk/-7DugvfZra03Ja7Jccq2k7tw7QA3syLeACLcBGAs/s640/image031.png" width="640" /></a></div><br />This could be converted to a script where input is taken, the REST API is called to run the custom script which then generates the period mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-YpVIC50dHVU/WvhgLkVpFmI/AAAAAAAAJuo/KaVjDGs7EOkMO33cP6dHlj2WpIJqBSetACLcBGAs/s1600/image032.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="583" data-original-width="659" src="https://1.bp.blogspot.com/-YpVIC50dHVU/WvhgLkVpFmI/AAAAAAAAJuo/KaVjDGs7EOkMO33cP6dHlj2WpIJqBSetACLcBGAs/s1600/image032.png" /></a></div><br />The period mappings will then be available under application mapping.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-hxklIhYT9iA/WvhgMOfE3YI/AAAAAAAAJus/FpFUx4vYpfEleG7l-mVaXOwSib72RyDsQCLcBGAs/s1600/image033.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="424" data-original-width="923" height="292" src="https://4.bp.blogspot.com/-hxklIhYT9iA/WvhgMOfE3YI/AAAAAAAAJus/FpFUx4vYpfEleG7l-mVaXOwSib72RyDsQCLcBGAs/s640/image033.png" width="640" /></a></div><br />Well that concludes the two-part look into managing FDMEE/Data Management period mappings.</div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-2222435006589918323 Mon May 14 2018 02:54:00 GMT-0400 (EDT) FDMEE/Data Management - Managing period mappings - Part 2 @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs http://john-goodwin.blogspot.com/2018/05/fdmeedata-management-managing-period.html <div dir="ltr" style="text-align: left;" trbidi="on">In the last part, I went through Data Management/FDMEE period mappings and possible methods to automate populating them. The solution concentrated on the cloud but could still be used with on-premise, the idea was to update the XML period mapping files generated by snapshots and then import them back to generate the new mappings.<br /><br />With Data Management in the cloud there is currently no custom Jython scripting allowed, so this pushes you to develop some solutions outside of the cloud. With on-premise FDMEE it is a different story, as you are able to build the solutions into the product using custom scripting. Also with on-premise FDMEE you have the option of the Excel interface which allows you to directly load files to the FDMEE database tables.<br /><br />In this post I am going to go through a couple of possible methods to update period mappings directly from FDMEE.<br /><br />In the FDMEE, all the period mapping in the UI are populated by reading the information from a database table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-z_6o9nPFv10/WvhgEyYmQBI/AAAAAAAAJss/neOoGHTVyRU__Yjq-9xx2polF0KsTdSeACLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="259" data-original-width="826" height="200" src="https://2.bp.blogspot.com/-z_6o9nPFv10/WvhgEyYmQBI/AAAAAAAAJss/neOoGHTVyRU__Yjq-9xx2polF0KsTdSeACLcBGAs/s640/image001.png" width="640" /></a></div><br />For global period mappings, these are populated from a table named “<b>TPOVPERIOD</b>”<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-ISHXR1kWod8/WvhgEwmqmnI/AAAAAAAAJsw/LcxadS7PHaUmPcSN1DTOfzSTtRjCWdzrACLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="171" data-original-width="884" height="122" src="https://2.bp.blogspot.com/-ISHXR1kWod8/WvhgEwmqmnI/AAAAAAAAJsw/LcxadS7PHaUmPcSN1DTOfzSTtRjCWdzrACLcBGAs/s640/image002.png" width="640" /></a></div><br />To be able to update the mapping table directly you can go to the Excel interface in the UI and select the entity type as “Period Mapping”. Select a file and location and download.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-JbyBqQTvlM0/WvhgExNgOdI/AAAAAAAAJs0/LX2o1T7X8wo1Fvq4CykW8Z_cwMC7eGndQCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="404" data-original-width="732" height="353" src="https://3.bp.blogspot.com/-JbyBqQTvlM0/WvhgExNgOdI/AAAAAAAAJs0/LX2o1T7X8wo1Fvq4CykW8Z_cwMC7eGndQCLcBGAs/s640/image003.png" width="640" /></a></div><br />You can then populate the Excel template.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-VnYgB6S8bGk/WvhgFhgpwzI/AAAAAAAAJs4/PRyEIkWdbS4mXybDFhfJl7v3oLtuLqTzACLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="86" data-original-width="875" height="62" src="https://4.bp.blogspot.com/-VnYgB6S8bGk/WvhgFhgpwzI/AAAAAAAAJs4/PRyEIkWdbS4mXybDFhfJl7v3oLtuLqTzACLcBGAs/s640/image004.png" width="640" /></a></div><br />Before uploading the file, it is worth pointing out the following rules with the Excel interface:<br /><ul style="text-align: left;"><li><b>Data is only inserted. It cannot be updated or deleted.</b></li><li><b>Data is not validated.</b></li><li><b>When FDMEE encounters a duplicate row, the row is skipped.</b></li></ul>Once you are happy, the Excel file can be uploaded.<br /><br /><div></div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-1qoc6I2Z2lY/WvhgFufeqAI/AAAAAAAAJs8/BxLC-tRgWi8mfBJ_xOvxcLRVYMtNotXwwCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="292" data-original-width="729" height="256" src="https://4.bp.blogspot.com/-1qoc6I2Z2lY/WvhgFufeqAI/AAAAAAAAJs8/BxLC-tRgWi8mfBJ_xOvxcLRVYMtNotXwwCLcBGAs/s640/image005.png" width="640" /></a></div><br />The FDMEE database table has had information from the Excel file inserted.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-a5BF3vXiaqk/WvhgF-C6jCI/AAAAAAAAJtA/v3HOEMGSq7oy2UwF0KOxUuRpW9HdCSyLgCLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="131" data-original-width="888" height="94" src="https://3.bp.blogspot.com/-a5BF3vXiaqk/WvhgF-C6jCI/AAAAAAAAJtA/v3HOEMGSq7oy2UwF0KOxUuRpW9HdCSyLgCLcBGAs/s640/image006.png" width="640" /></a></div><br />Back in the UI, the global period mappings now contain the two new mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-vVRBWBzophU/WvhgGE-g-KI/AAAAAAAAJtE/8EM5DXZX7tInW44_MxZDIRfBc1UwOi6SwCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="159" data-original-width="801" height="127" src="https://2.bp.blogspot.com/-vVRBWBzophU/WvhgGE-g-KI/AAAAAAAAJtE/8EM5DXZX7tInW44_MxZDIRfBc1UwOi6SwCLcBGAs/s640/image007.png" width="640" /></a></div><br />This is all fine, but what if you want something more dynamic where you don’t have to be bothered with populating Excel files? Well this is where a bit of custom scripting could help.<br /><br />I am going to go through an example of updating the global and application period mapping tables by using a custom script, this will have parameters to define the start month/year and number of months to generate.<br /><br />The application period mappings are stored in a table named “TPOVPERIODADAPTOR”, the only difference from the global mapping table is the “intsystemkey” column which holds the target application name.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-zTui0qHkl2Q/WvhgGo-l5uI/AAAAAAAAJtI/zDkkYxmQMjUZHT9OzEmF4r0U4DtjJWg5gCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="131" data-original-width="942" height="88" src="https://3.bp.blogspot.com/-zTui0qHkl2Q/WvhgGo-l5uI/AAAAAAAAJtI/zDkkYxmQMjUZHT9OzEmF4r0U4DtjJWg5gCLcBGAs/s640/image008.png" width="640" /></a></div><br />First a new script is registered in FDMEE, I will get on to the details of the Jython script later.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-wm7yXSUdnD8/WvhgGshkZQI/AAAAAAAAJtM/UWIo1hq27JcxyzkorbJvPT8Dos2QDUOQQCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="244" data-original-width="1050" height="148" src="https://4.bp.blogspot.com/-wm7yXSUdnD8/WvhgGshkZQI/AAAAAAAAJtM/UWIo1hq27JcxyzkorbJvPT8Dos2QDUOQQCLcBGAs/s640/image009.png" width="640" /></a></div><br />There are four parameters, one which defines which defines the start month, instead of allowing direct input to minimise errors, a query type has been used to generate the periods (based on Oracle database).<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-YSE2IwiVY6Y/WvhgGzW24lI/AAAAAAAAJtQ/TijjRSJvG7sUz7nGzee3NlA0Mlpi64FoACLcBGAs/s1600/image010.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="777" height="143" src="https://4.bp.blogspot.com/-YSE2IwiVY6Y/WvhgGzW24lI/AAAAAAAAJtQ/TijjRSJvG7sUz7nGzee3NlA0Mlpi64FoACLcBGAs/s640/image010.png" width="640" /></a></div><br />Another query has been created to generate years where a start year can be selected.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-6s-r4ik5jRQ/WvhgHI19XEI/AAAAAAAAJtU/7sdL9FenKsMZzRI8OMIX7WYfRKe8VpTegCLcBGAs/s1600/image011.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="553" src="https://1.bp.blogspot.com/-6s-r4ik5jRQ/WvhgHI19XEI/AAAAAAAAJtU/7sdL9FenKsMZzRI8OMIX7WYfRKe8VpTegCLcBGAs/s1600/image011.png" /></a></div><br />The number of months parameter has been set as static so they are manually entered.<br /><br />The target application name is defined by a SQL query, there is one already by default with FDMEE.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-IIp-g1GK0t4/WvhgHJxjaXI/AAAAAAAAJtY/yamNmtF82wUtmMpJTa1PWzs_tHEqKlhuQCLcBGAs/s1600/image012.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="182" data-original-width="734" height="157" src="https://2.bp.blogspot.com/-IIp-g1GK0t4/WvhgHJxjaXI/AAAAAAAAJtY/yamNmtF82wUtmMpJTa1PWzs_tHEqKlhuQCLcBGAs/s640/image012.png" width="640" /></a></div><br />On to executing the script, the group and script are selected.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-eIvg1q--Q_4/WvhgHg7T6oI/AAAAAAAAJtc/Rlzht84CrX0o_6dGlPEkWC4L_bA1DIncACLcBGAs/s1600/image013.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="195" data-original-width="273" src="https://3.bp.blogspot.com/-eIvg1q--Q_4/WvhgHg7T6oI/AAAAAAAAJtc/Rlzht84CrX0o_6dGlPEkWC4L_bA1DIncACLcBGAs/s1600/image013.png" /></a></div><br />When the script is executed a window is displayed with the available parameters.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-tfwNBp1eQLI/WvhgHj2V7ZI/AAAAAAAAJtg/9JQzXD823EkkMuRnl9iJWo7OI0mpDZs2gCLcBGAs/s1600/image014.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="148" data-original-width="468" src="https://2.bp.blogspot.com/-tfwNBp1eQLI/WvhgHj2V7ZI/AAAAAAAAJtg/9JQzXD823EkkMuRnl9iJWo7OI0mpDZs2gCLcBGAs/s1600/image014.png" /></a></div><br />If start month is selected, a list of months is displayed for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-uteAkfEGcKA/WvhgHzXiF4I/AAAAAAAAJtk/fC0Axm4a1VMZJZVuIKXCMXqn7QE9psYgQCLcBGAs/s1600/image015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="298" data-original-width="162" src="https://1.bp.blogspot.com/-uteAkfEGcKA/WvhgHzXiF4I/AAAAAAAAJtk/fC0Axm4a1VMZJZVuIKXCMXqn7QE9psYgQCLcBGAs/s1600/image015.png" /></a></div><br />If start year is selected, a list of years is displayed for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Rgey87ujLes/WvhgIEGjjWI/AAAAAAAAJto/bizyGAePnf8fLHmvMr5oroA6Geu_WsFOwCLcBGAs/s1600/image016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="317" data-original-width="164" src="https://2.bp.blogspot.com/-Rgey87ujLes/WvhgIEGjjWI/AAAAAAAAJto/bizyGAePnf8fLHmvMr5oroA6Geu_WsFOwCLcBGAs/s1600/image016.png" /></a></div><br />For this example, I am going to generate four months of period mappings, any number can be entered.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Jt9xkKoYRlk/WvhgIRO1DQI/AAAAAAAAJts/27vy01jt2Ys57z7U6ooklIonN_nq_HrewCLcBGAs/s1600/image017.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="148" data-original-width="316" src="https://2.bp.blogspot.com/-Jt9xkKoYRlk/WvhgIRO1DQI/AAAAAAAAJts/27vy01jt2Ys57z7U6ooklIonN_nq_HrewCLcBGAs/s1600/image017.png" /></a></div><br />I have left the target application blank as I just want to update the global mapping period table.<br /><br />After executing the script, a message is displayed to inform how many rows have been inserted into the period mapping table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-hViRXodcsz4/WvhlquBMbrI/AAAAAAAAJvU/XBo8acU8GBYS5kqF-7qviEvugk_5j-_jwCLcBGAs/s1600/amap1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="95" data-original-width="293" src="https://1.bp.blogspot.com/-hViRXodcsz4/WvhlquBMbrI/AAAAAAAAJvU/XBo8acU8GBYS5kqF-7qviEvugk_5j-_jwCLcBGAs/s1600/amap1.png" /></a></div><br />The database table has been populated with the 4 months of mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-zV9U-HdoAzE/WvhgIkrzRQI/AAAAAAAAJt0/wVgImvoy6Y0nLvJHz3ohWXevK7UZJB3sQCLcBGAs/s1600/image019.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="174" data-original-width="840" height="132" src="https://2.bp.blogspot.com/-zV9U-HdoAzE/WvhgIkrzRQI/AAAAAAAAJt0/wVgImvoy6Y0nLvJHz3ohWXevK7UZJB3sQCLcBGAs/s640/image019.png" width="640" /></a></div><br />These are available in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-FM_UktRsmd4/WvhgI6AK7nI/AAAAAAAAJt4/yqtI_8F7XMgp941Uj-noHDedn5zfNsJMwCLcBGAs/s1600/image020.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="187" data-original-width="869" height="137" src="https://1.bp.blogspot.com/-FM_UktRsmd4/WvhgI6AK7nI/AAAAAAAAJt4/yqtI_8F7XMgp941Uj-noHDedn5zfNsJMwCLcBGAs/s640/image020.png" width="640" /></a></div><br />If I run the script again and this time select the application, a list of target applications is available for selection.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-7hYlkyDQyKc/WvhgJacNFZI/AAAAAAAAJt8/o0WHv9zEUEccYE-2Jfrp4anfgti1TGgvQCLcBGAs/s1600/image021.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="317" data-original-width="309" src="https://3.bp.blogspot.com/-7hYlkyDQyKc/WvhgJacNFZI/AAAAAAAAJt8/o0WHv9zEUEccYE-2Jfrp4anfgti1TGgvQCLcBGAs/s1600/image021.png" /></a></div><br />I selected the Vision application and to generate 3 months of mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-cujee3n2YXA/WvhgJcGdesI/AAAAAAAAJuA/sV8c-NYVe6cyksFFR71uC8euAUs3U7sEQCLcBGAs/s1600/image022.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="150" data-original-width="489" src="https://1.bp.blogspot.com/-cujee3n2YXA/WvhgJcGdesI/AAAAAAAAJuA/sV8c-NYVe6cyksFFR71uC8euAUs3U7sEQCLcBGAs/s1600/image022.png" /></a></div><br />Once executed, a message confirms 3 rows have been inserted into the mapping table.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-9Ys-jAxJZBs/Wvhl3lnhXSI/AAAAAAAAJvY/Oy4x9pGWt8Mtvdx_vL2PzCVRfI4t0VzugCLcBGAs/s1600/amap2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="96" data-original-width="299" src="https://1.bp.blogspot.com/-9Ys-jAxJZBs/Wvhl3lnhXSI/AAAAAAAAJvY/Oy4x9pGWt8Mtvdx_vL2PzCVRfI4t0VzugCLcBGAs/s1600/amap2.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div>The application period mapping database table has been updated with the 3 new mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-0NZGbqjPQhc/WvhgJ5AMjmI/AAAAAAAAJuI/sUP6crHMiVM61CXQ3UFNDxuOLxLv4oZLACLcBGAs/s1600/image024.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="150" data-original-width="905" height="106" src="https://3.bp.blogspot.com/-0NZGbqjPQhc/WvhgJ5AMjmI/AAAAAAAAJuI/sUP6crHMiVM61CXQ3UFNDxuOLxLv4oZLACLcBGAs/s640/image024.png" width="640" /></a></div><br />These are then available under application mappings in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-ZmyydSegpG4/WvhgKNFEWoI/AAAAAAAAJuM/nR6syBDXMBAeuPXq6jpT0-JstQ4OaK41wCLcBGAs/s1600/image025.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="213" data-original-width="881" height="154" src="https://3.bp.blogspot.com/-ZmyydSegpG4/WvhgKNFEWoI/AAAAAAAAJuM/nR6syBDXMBAeuPXq6jpT0-JstQ4OaK41wCLcBGAs/s640/image025.png" width="640" /></a></div><br />If I run the script again with the same parameter values, the message this time informs that no rows were inserted as the period keys already exist.<br /><br /><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-rYMbdXz92l0/Wvhl9WBM-eI/AAAAAAAAJvg/LYjSQE_r2Q8arHubo38_lrHyRxZLDWljACLcBGAs/s1600/amap3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="96" data-original-width="759" height="80" src="https://3.bp.blogspot.com/-rYMbdXz92l0/Wvhl9WBM-eI/AAAAAAAAJvg/LYjSQE_r2Q8arHubo38_lrHyRxZLDWljACLcBGAs/s640/amap3.png" width="640" /></a></div><br />On to the Jython script that does all the work to populate the mapping tables.<br /><br />I am not going to go through it in detail as the script is already commented so should give you a good idea what is happening.<br /><br />In summary, the start month, year, number of months and target application parameter values are retrieved and stored.<br /><br />There are similar SQL statements depending on whether a target application has been selected or not.&nbsp; There is a query to count if there are duplicate period mappings and an insert statement to the relevant period mapping table.<br /><br />The start month and year are converted into a valid date.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-BiONmbdTrpU/WvhnfPHrcRI/AAAAAAAAJv4/ZbXsQHlcGxEXh7szWqJEcwYGU35ImLuXQCLcBGAs/s1600/amap5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="775" data-original-width="684" src="https://2.bp.blogspot.com/-BiONmbdTrpU/WvhnfPHrcRI/AAAAAAAAJv4/ZbXsQHlcGxEXh7szWqJEcwYGU35ImLuXQCLcBGAs/s1600/amap5.png" /></a></div><br />A loop cycles through the number of months that need to be populated into the mapping table.<br /><br />The period key is generated by calculating the last day of the month for the current date and appended to the SQL parameters.<br /><br />The last period key, period description and year target are generated and appended to the SQL parameters.<br /><br />The target period quarter, year and day are not used in this example so nulls are generated in the SQL parameters.<br /><br />The query is executed to check if a period key already exists for the current period key that will be inserted into the mapping table.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-IHYxHEP2dj0/WvhgKmYZ2pI/AAAAAAAAJuY/y4pAVEU9vaMpdWlzQJPzOF3cdjI-Mb4ogCLcBGAs/s1600/image028.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="665" data-original-width="608" src="https://1.bp.blogspot.com/-IHYxHEP2dj0/WvhgKmYZ2pI/AAAAAAAAJuY/y4pAVEU9vaMpdWlzQJPzOF3cdjI-Mb4ogCLcBGAs/s1600/image028.png" /></a></div><br />If there is already an existing period key, store the duplicate key.<br /><br />If there is not an existing period key, insert the period information into the mapping table.<br /><br />Then the date moves forward one month and the process is repeated until all months have been looped through.<br /><br />Finally, a message is displayed to inform how many rows were inserted and if there were any period key duplicates.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-GuXOmQaKGSM/WvhmB-JvSgI/AAAAAAAAJvk/pjYjrF64i8s3RBIkA9cRCaIGHWV88RXmQCLcBGAs/s1600/amap4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="410" data-original-width="767" height="342" src="https://2.bp.blogspot.com/-GuXOmQaKGSM/WvhmB-JvSgI/AAAAAAAAJvk/pjYjrF64i8s3RBIkA9cRCaIGHWV88RXmQCLcBGAs/s640/amap4.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><br />If you are running FDMEE 11.1.2.4.210+ then you can take advantage of the REST API to execute the custom script, I have covered the FDMEE REST API in detail and you can read about it starting <b><a href="http://john-goodwin.blogspot.co.uk/2016/12/fdmee-and-rest-is-up-to-you-part-1.html">here</a></b><br /><br />An example using a REST client to generate 12 months of mapping starting from January 2021 would be:<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-wGj3LxUBiuE/WvhgLC7IGCI/AAAAAAAAJug/naEHD3oRTGotvwWEkkgESwYpxOHhrYHJgCLcBGAs/s1600/image030.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="252" data-original-width="666" src="https://2.bp.blogspot.com/-wGj3LxUBiuE/WvhgLC7IGCI/AAAAAAAAJug/naEHD3oRTGotvwWEkkgESwYpxOHhrYHJgCLcBGAs/s1600/image030.png" /></a></div><br />Once the script has completed the period mappings will be available in the UI.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-8NJu1S0u3NQ/WvhgLKFxTcI/AAAAAAAAJuk/-7DugvfZra03Ja7Jccq2k7tw7QA3syLeACLcBGAs/s1600/image031.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="391" data-original-width="860" height="290" src="https://4.bp.blogspot.com/-8NJu1S0u3NQ/WvhgLKFxTcI/AAAAAAAAJuk/-7DugvfZra03Ja7Jccq2k7tw7QA3syLeACLcBGAs/s640/image031.png" width="640" /></a></div><br />This could be converted to a script where input is taken, the REST API is called to run the custom script which then generates the period mappings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-YpVIC50dHVU/WvhgLkVpFmI/AAAAAAAAJuo/KaVjDGs7EOkMO33cP6dHlj2WpIJqBSetACLcBGAs/s1600/image032.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="583" data-original-width="659" src="https://1.bp.blogspot.com/-YpVIC50dHVU/WvhgLkVpFmI/AAAAAAAAJuo/KaVjDGs7EOkMO33cP6dHlj2WpIJqBSetACLcBGAs/s1600/image032.png" /></a></div><br />The period mappings will then be available under application mapping.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-hxklIhYT9iA/WvhgMOfE3YI/AAAAAAAAJus/FpFUx4vYpfEleG7l-mVaXOwSib72RyDsQCLcBGAs/s1600/image033.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="424" data-original-width="923" height="292" src="https://4.bp.blogspot.com/-hxklIhYT9iA/WvhgMOfE3YI/AAAAAAAAJus/FpFUx4vYpfEleG7l-mVaXOwSib72RyDsQCLcBGAs/s640/image033.png" width="640" /></a></div><br />Well that concludes the two-part look into managing FDMEE/Data Management period mappings.</div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-2222435006589918323 Mon May 14 2018 02:54:00 GMT-0400 (EDT) EPBCS Lab – Enterprise Planning Prebuilt Business Rules @_Jun_Zhang_ http://theepmlab.com/epbcs-lab-enterprise-planning-prebuilt-business-rules/ The Enterprise Planning Cloud (EPBCS) comes with four prebuilt business processes: Financials Workforce Capital Projects &#160; Each of the business processes comes with several prebuilt business rules. Some of these rules are written by Essbase calc scripts, and others are written by Groovy. Now let’s take a look at the majority of the prebuilt rules... Jun http://theepmlab.com/?p=2092 Mon May 14 2018 00:02:36 GMT-0400 (EDT) EPBCS Lab – Enterprise Planning Prebuilt Business Rules http://theepmlab.com/epbcs-lab-enterprise-planning-prebuilt-business-rules/ The Enterprise Planning Cloud (EPBCS) comes with four prebuilt business processes: Financials Workforce Capital Projects &#160; Each of the business processes comes with several prebuilt business rules. Some of these rules are written by Essbase calc scripts, and others are written by Groovy. Now let’s take a look at the majority of the prebuilt rules... Jun http://theepmlab.com/?p=2092 Mon May 14 2018 00:02:36 GMT-0400 (EDT) New On edelivery 11.1.2.4.900 is NOT a Patch to Existing 11.1.2.4.xxx Code! @CheckPointllc http://blog.checkpointllc.com/new-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code <p>Oracle quietly released a new installer for 11.1.2.4.x labeled 11.1.2.4.900 May 1st on edelivery. I’ve not seen any announcements from Oracle about it and it was not included in the “EPM Patch Set Updates - April 2018” blog announcement which came out on 5/4/18.</p> <p>While it is officially numbered 11.1.2.4.900 it is not a patch to the existing 11.1.2.4 version and requires a clean install. The readme file clearly states there is no upgrade path to this “version” and content must be recreated.</p> <p><strong><span style="color: #004b85;">"Supported Paths to This Release -- You cannot upgrade to this release from a previous release. If you are using release 11.1.2.4.xxx, install a new 11.1.2.4.900 environment and create new applications.”</span></strong></p> <p>My team is still kicking the tires in our lab to identify all the changes, but what we do know is the “RA Framework” has been removed from the product group. RA framework was responsible for the object repository inside workspace and stored workspace documents in the RM1 directory on the filesystem. &nbsp;A holdover from BRIO which brought the earlier deprecated SQR and Interactive Reporting to the table, its removal is an architecture change which will result in Financial Reporting objects being stored in a DB repository instead of the filesystem. The RM1 directory has been removed from the architecture. This helps explain why there is no upgrade path. We are still looking into shortcuts to “create new applications” such as what can be done with LCM or classic approaches to Planning and Essbase. Look for a subsequent blog on what we find.</p> <p>What does this means to customers? Those yet to upgrade to 11.1.2.4 can look at this new “release” as an opportunity to go with a clean environment with a lighter architecture and really look at cleaning up their applications with a rebuild.</p> <p>Those already on 11.1.2.4 might consider remaining on the existing PSU level until we know more. With KSCOPE approaching I’ll certainly be looking at Oracle to provide some insight on what they recommend as well as what this means for the pending on-premise version release they announced at Open World.</p> <p>&nbsp;</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fnew-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Mike Turner http://blog.checkpointllc.com/new-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code Fri May 11 2018 14:03:00 GMT-0400 (EDT) New On edelivery 11.1.2.4.900 is NOT a Patch to Existing 11.1.2.4.xxx Code! http://blog.checkpointllc.com/new-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code <p>Oracle quietly released a new installer for 11.1.2.4.x labeled 11.1.2.4.900 May 1st on edelivery. I’ve not seen any announcements from Oracle about it and it was not included in the “EPM Patch Set Updates - April 2018” blog announcement which came out on 5/4/18.</p> <p>While it is officially numbered 11.1.2.4.900 it is not a patch to the existing 11.1.2.4 version and requires a clean install. The readme file clearly states there is no upgrade path to this “version” and content must be recreated.</p> <p><strong><span style="color: #004b85;">"Supported Paths to This Release -- You cannot upgrade to this release from a previous release. If you are using release 11.1.2.4.xxx, install a new 11.1.2.4.900 environment and create new applications.”</span></strong></p> <p>My team is still kicking the tires in our lab to identify all the changes, but what we do know is the “RA Framework” has been removed from the product group. RA framework was responsible for the object repository inside workspace and stored workspace documents in the RM1 directory on the filesystem. &nbsp;A holdover from BRIO which brought the earlier deprecated SQR and Interactive Reporting to the table, its removal is an architecture change which will result in Financial Reporting objects being stored in a DB repository instead of the filesystem. The RM1 directory has been removed from the architecture. This helps explain why there is no upgrade path. We are still looking into shortcuts to “create new applications” such as what can be done with LCM or classic approaches to Planning and Essbase. Look for a subsequent blog on what we find.</p> <p>What does this means to customers? Those yet to upgrade to 11.1.2.4 can look at this new “release” as an opportunity to go with a clean environment with a lighter architecture and really look at cleaning up their applications with a rebuild.</p> <p>Those already on 11.1.2.4 might consider remaining on the existing PSU level until we know more. With KSCOPE approaching I’ll certainly be looking at Oracle to provide some insight on what they recommend as well as what this means for the pending on-premise version release they announced at Open World.</p> <p>&nbsp;</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fnew-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Mike Turner http://blog.checkpointllc.com/new-on-edelivery-11.1.2.4.900-is-not-a-patch-to-existing-11.1.2.4.xxx-code Fri May 11 2018 14:03:00 GMT-0400 (EDT) Kscope18: Must-See EPM Sessions & Events @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/kscope18 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/kscope18" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/swan%20and%20dolphin%20kscope18.jpg?t=1526938888034" alt="swan and dolphin kscope18" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>Can you believe? It’s already time to start planning your trip to another ODTUG Kaleidoscope conference. This year, Kscope18 will be held at Disney World’s Swan and Dolphin Resort, which includes five pools, a white sand beach, three golf courses, 17 restaurants, and much more.</p> <p>Kscope18 will host a variety of Oracle experts delivering more than 300 presentations, including hands-on training and lunch-and-learn sessions. You won’t want to miss Oracle ACE Associate Brian Marshall’s sessions — one of which was named a “<a href="https://www.odtug.com/p/bl/et/blogaid=791">don’t-miss session</a>” by Kscope18’s Planning track lead.</p> <p>In this blog post, we’ll help you make the most of your time at Kscope:</p> <ul> <li>Swing by our EPM &amp; BI <a href="https://www.us-analytics.com/kscope18">happy hour</a></li> <li>Vote on what <a href="https://www.surveymonkey.com/r/kscope18">giveaways and swag</a> you want to pick up at our booth</li> <li>Add notable EPM sessions to your agenda</li> <li>Revisit past Kscope presentations</li> </ul> <p><a href="https://kscope18.odtug.com/page/register"><em>Don’t forget to use the promo code <strong>USA</strong> to get $100 off Kscope registration. </em></a></p> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Fkscope18&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/kscope18 Thu May 10 2018 18:16:11 GMT-0400 (EDT) Kscope18: Must-See EPM Sessions & Events https://www.us-analytics.com/hyperionblog/kscope18 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/kscope18" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/swan%20and%20dolphin%20kscope18.jpg?t=1526938888034" alt="swan and dolphin kscope18" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>Can you believe? It’s already time to start planning your trip to another ODTUG Kaleidoscope conference. This year, Kscope18 will be held at Disney World’s Swan and Dolphin Resort, which includes five pools, a white sand beach, three golf courses, 17 restaurants, and much more.</p> <p>Kscope18 will host a variety of Oracle experts delivering more than 300 presentations, including hands-on training and lunch-and-learn sessions. You won’t want to miss Oracle ACE Associate Brian Marshall’s sessions — one of which was named a “<a href="https://www.odtug.com/p/bl/et/blogaid=791">don’t-miss session</a>” by Kscope18’s Planning track lead.</p> <p>In this blog post, we’ll help you make the most of your time at Kscope:</p> <ul> <li>Swing by our EPM &amp; BI <a href="https://www.us-analytics.com/kscope18">happy hour</a></li> <li>Vote on what <a href="https://www.surveymonkey.com/r/kscope18">giveaways and swag</a> you want to pick up at our booth</li> <li>Add notable EPM sessions to your agenda</li> <li>Revisit past Kscope presentations</li> </ul> <p><a href="https://kscope18.odtug.com/page/register"><em>Don’t forget to use the promo code <strong>USA</strong> to get $100 off Kscope registration. </em></a></p> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Fkscope18&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/kscope18 Thu May 10 2018 18:16:11 GMT-0400 (EDT) Branching in MaxL @TimF http://essbase-day.blogspot.com/2018/05/branching-in-maxl.html A fairly common task I run across when writing MaxL scripts is to have some logic where a certain file loads or a calc runs one day and a different file loads or a different calc runs on a different day. I'd usually write multiple MaxL scripts to handle this and call a different script on a different day. I'm not sure why it took me so long to figure this out, but it's really not difficult to handle this in one script.<br /><br /><pre style="background: #f0f0f0; border: 1px dashed #cccccc; color: black; font-family: &quot;arial&quot;; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;">1: login $1 $2 on $3; <br />2: <br />3: echo 'script starting'; <br />4: <br />5: goto $4; <br />6: <br />7: define label '0'; <br />8: echo 'Today is Sunday'; <br />9: goto 'Finished'; <br />10: <br />11: define label '1'; <br />12: echo 'Today is Monday'; <br />13: goto 'Finished'; <br />14: <br />15: define label '2'; <br />16: echo 'Today is Tuesday'; <br />17: goto 'Finished'; <br />18: <br />19: define label '3'; <br />20: echo 'Today is Wednesday'; <br />21: goto 'Finished'; <br />22: <br />23: define label '4'; <br />24: echo 'Today is Wednesday'; <br />25: goto 'Finished'; <br />26: <br />27: define label '5'; <br />28: echo 'Today is Thursday'; <br />29: goto 'Finished'; <br />30: <br />31: define label '6'; <br />32: echo 'Today is Friday'; <br />33: goto 'Finished'; <br />34: <br />35: define label '7'; <br />36: echo 'Today is Saturday'; <br />37: goto 'Finished'; <br />38: <br />39: define label 'Finished'; <br />40: echo 'script is finished'; <br />41: <br />42: logout; <br />43: exit; <br /></code></pre><br />When I call the MaxL script, I pass in User ID, Password, Hostname and then a number for the day of the week. Only the part between the <i>label</i> and the <i>goto</i> will be executed. TimF tag:blogger.com,1999:blog-6545695526051974540.post-6225308198092484927 Thu May 10 2018 16:06:00 GMT-0400 (EDT) Branching in MaxL http://essbase-day.blogspot.com/2018/05/branching-in-maxl.html A fairly common task I run across when writing MaxL scripts is to have some logic where a certain file loads or a calc runs one day and a different file loads or a different calc runs on a different day. I'd usually write multiple MaxL scripts to handle this and call a different script on a different day. I'm not sure why it took me so long to figure this out, but it's really not difficult to handle this in one script.<br /><br /><pre style="background: #f0f0f0; border: 1px dashed #cccccc; color: black; font-family: &quot;arial&quot;; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;">1: login $1 $2 on $3; <br />2: <br />3: echo 'script starting'; <br />4: <br />5: goto $4; <br />6: <br />7: define label '0'; <br />8: echo 'Today is Sunday'; <br />9: goto 'Finished'; <br />10: <br />11: define label '1'; <br />12: echo 'Today is Monday'; <br />13: goto 'Finished'; <br />14: <br />15: define label '2'; <br />16: echo 'Today is Tuesday'; <br />17: goto 'Finished'; <br />18: <br />19: define label '3'; <br />20: echo 'Today is Wednesday'; <br />21: goto 'Finished'; <br />22: <br />23: define label '4'; <br />24: echo 'Today is Wednesday'; <br />25: goto 'Finished'; <br />26: <br />27: define label '5'; <br />28: echo 'Today is Thursday'; <br />29: goto 'Finished'; <br />30: <br />31: define label '6'; <br />32: echo 'Today is Friday'; <br />33: goto 'Finished'; <br />34: <br />35: define label '7'; <br />36: echo 'Today is Saturday'; <br />37: goto 'Finished'; <br />38: <br />39: define label 'Finished'; <br />40: echo 'script is finished'; <br />41: <br />42: logout; <br />43: exit; <br /></code></pre><br />When I call the MaxL script, I pass in User ID, Password, Hostname and then a number for the day of the week. Only the part between the <i>label</i> and the <i>goto</i> will be executed. TimF tag:blogger.com,1999:blog-6545695526051974540.post-6225308198092484927 Thu May 10 2018 16:06:00 GMT-0400 (EDT) EPBCS ASO Level 0 Export @TheManfredi https://anthonymanfredi73.com/2018/05/08/epbcs-aso-level-0-export/ <p>I was so excited the other day when I read this small yet so inviting tidbit in the EPBCS release notes for May:</p> <p><strong>You can now use Calculation Manager to export and import level zero data from an ASO cube.</strong></p> <p>I have been struggling with getting data out of ASO cubes in a usable format for the longest time so I had to try it this weekend.</p> <p>I dreamed that it was going to be a new type of data export script that would make extraction from the cubes both quick and filterable. What we got was in my mind is a bit of a disappointment.</p> <p>The URL to access the documentation for this feature in the release notes is not currently active so this is based on my digging.</p> <p>The feature can be accessed within the Calc Manager Essbase screen of EPBCS. Once you are in Calc Manager select the database properties icon. Then navigate to your ASO application and database.</p> <p><img class="aligncenter" src="https://anthonymanfredi73.files.wordpress.com/2018/05/1525797480.png?w=1100" alt="img-alternative-text" align="middle" /></p> <p>Select the Export Level Zero Data and the system will generate a zip file for you in the inbox that can be downloaded. <strong>It was very quick to generate the zip!</strong> When I downloaded the file and opened the zip I found that my data was in native Essbase format, not column format and therefore it could not be easily used effectively in any on-prem, non-Essbase downstream applications. This also cannot be scheduled through REST yet to provide lights out extracts if needed.</p> <p>Basically, the functionality of on-prem ASO extracts has been replicated in the cloud.</p> <p>I am hoping that this is just a start because with the power of data maps our BSO plan types can be smaller and quicker but the data physically only exists in the ASO plan types. Clients that need to share data with other applications require a more eloquent solution for extracting data out of ASO plan types. I was hoping for a change in the way that I implement but unfortunately, my designs will still rely on BSO for my client&#8217;s extract needs. I am optimistic this is just the start of really opening up the power of ASO to extract data!!</p> Anthony Manfredi http://anthonymanfredi73.wordpress.com/?p=224 Tue May 08 2018 12:52:00 GMT-0400 (EDT) EPBCS ASO Level 0 Export https://anthonymanfredi73.com/2018/05/08/epbcs-aso-level-0-export/ <p>I was so excited the other day when I read this small yet so inviting tidbit in the EPBCS release notes for May:</p> <p><strong>You can now use Calculation Manager to export and import level zero data from an ASO cube.</strong></p> <p>I have been struggling with getting data out of ASO cubes in a usable format for the longest time so I had to try it this weekend.</p> <p>I dreamed that it was going to be a new type of data export script that would make extraction from the cubes both quick and filterable. What we got was in my mind is a bit of a disappointment.</p> <p>The URL to access the documentation for this feature in the release notes is not currently active so this is based on my digging.</p> <p>The feature can be accessed within the Calc Manager Essbase screen of EPBCS. Once you are in Calc Manager select the database properties icon. Then navigate to your ASO application and database.</p> <p><img class="aligncenter" src="https://anthonymanfredi73.files.wordpress.com/2018/05/1525797480.png?w=1100" alt="img-alternative-text" align="middle" /></p> <p>Select the Export Level Zero Data and the system will generate a zip file for you in the inbox that can be downloaded. <strong>It was very quick to generate the zip!</strong> When I downloaded the file and opened the zip I found that my data was in native Essbase format, not column format and therefore it could not be easily used effectively in any on-prem, non-Essbase downstream applications. This also cannot be scheduled through REST yet to provide lights out extracts if needed.</p> <p>Basically, the functionality of on-prem ASO extracts has been replicated in the cloud.</p> <p>I am hoping that this is just a start because with the power of data maps our BSO plan types can be smaller and quicker but the data physically only exists in the ASO plan types. Clients that need to share data with other applications require a more eloquent solution for extracting data out of ASO plan types. I was hoping for a change in the way that I implement but unfortunately, my designs will still rely on BSO for my client&#8217;s extract needs. I am optimistic this is just the start of really opening up the power of ASO to extract data!!</p> Anthony Manfredi http://anthonymanfredi73.wordpress.com/?p=224 Tue May 08 2018 12:52:00 GMT-0400 (EDT) EDMCS Lab – Enterprise Data Management Cloud Introduction @_Jun_Zhang_ http://theepmlab.com/edmcs-lab-enterprise-data-management-cloud-introduction/ On January 25th, 2018, Enterprise Data Management Cloud got released. Finally, DRM moved to cloud. It is good to see that the EPM family is getting stronger. After several monthly patches installed to EDMCS, I guess it is time to discuss some high-level EDMCS functionalities. &#160; First and foremost, similar to other EPM cloud applications,... Jun http://theepmlab.com/?p=2066 Mon May 07 2018 16:00:34 GMT-0400 (EDT) EDMCS Lab – Enterprise Data Management Cloud Introduction http://theepmlab.com/edmcs-lab-enterprise-data-management-cloud-introduction/ On January 25th, 2018, Enterprise Data Management Cloud got released. Finally, DRM moved to cloud. It is good to see that the EPM family is getting stronger. After several monthly patches installed to EDMCS, I guess it is time to discuss some high-level EDMCS functionalities. &#160; First and foremost, similar to other EPM cloud applications,... Jun http://theepmlab.com/?p=2066 Mon May 07 2018 16:00:34 GMT-0400 (EDT) ODTUG Kscope18 Updates @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=796&source=1 This week's ODTUG Kscope18 updates includes the announcement of the Thursday Deep Dives, the Daily Events, special hotel room rate, and the Oracle usability activity sign up. ODTUG https://www.odtug.com/p/bl/et/blogaid=796&source=1 Mon May 07 2018 09:03:40 GMT-0400 (EDT) ODTUG Kscope18 Updates https://www.odtug.com/p/bl/et/blogaid=796&source=1 This week's ODTUG Kscope18 updates includes the announcement of the Thursday Deep Dives, the Daily Events, special hotel room rate, and the Oracle usability activity sign up. ODTUG https://www.odtug.com/p/bl/et/blogaid=796&source=1 Mon May 07 2018 09:03:40 GMT-0400 (EDT) EPM Cloud – Limiting the use of an application through automation - Update http://john-goodwin.blogspot.com/2018/05/epm-cloud-limiting-use-of-application.html <div dir="ltr" style="text-align: left;" trbidi="on">Back with a very quick update, recently I wrote a <a href="http://john-goodwin.blogspot.co.uk/2018/03/epm-cloud-limiting-use-of-application.html"><b>post</b></a> about the different options for limiting the use of an EPM Cloud application to administrators and then returning it to all users.<br /><br />At the time of writing the post, the only option to schedule this process was by creating a refresh database job and setting the enable use of application settings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-nhZcRgjyT0w/Wu7UkPLJFRI/AAAAAAAAJrw/zT1nJ0SllJ0JOMyys3MFkGTVAf65rA0ZACLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="257" data-original-width="907" height="180" src="https://4.bp.blogspot.com/-nhZcRgjyT0w/Wu7UkPLJFRI/AAAAAAAAJrw/zT1nJ0SllJ0JOMyys3MFkGTVAf65rA0ZACLcBGAs/s640/image001.png" width="640" /></a></div><br />Moving forward to the 18.05 cloud release and there is now a new schedule job option called “Administration Mode”. <br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-MIFtWz4TwVE/Wu7UkAbgHKI/AAAAAAAAJro/C5gQ85BKUcQpNBXNb7KDFdo5ccNYmUBaQCLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="565" data-original-width="1010" height="358" src="https://2.bp.blogspot.com/-MIFtWz4TwVE/Wu7UkAbgHKI/AAAAAAAAJro/C5gQ85BKUcQpNBXNb7KDFdo5ccNYmUBaQCLcBGAs/s640/image002.png" width="640" /></a></div><br />So if you know the exact times you want to limit access to the application, you can create a new job.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-Cmx4h17m99M/Wu7UkFfyL-I/AAAAAAAAJrs/2WRllmCzbvUiUueiWZqdJVZzEp7_59h8gCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="263" data-original-width="735" height="229" src="https://4.bp.blogspot.com/-Cmx4h17m99M/Wu7UkFfyL-I/AAAAAAAAJrs/2WRllmCzbvUiUueiWZqdJVZzEp7_59h8gCLcBGAs/s640/image003.png" width="640" /></a></div><br />It is possible to run the job straight away which would really be the same as going to “System Settings and Defaults” from the navigator, this then provides the options to set the application maintenance mode.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-S1KaWHEsqH0/Wu7UlPb7hAI/AAAAAAAAJr0/hnuk2zECEP4OW2xBJC2N18yRz1r-sA7QgCLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="280" data-original-width="594" src="https://1.bp.blogspot.com/-S1KaWHEsqH0/Wu7UlPb7hAI/AAAAAAAAJr0/hnuk2zECEP4OW2xBJC2N18yRz1r-sA7QgCLcBGAs/s1600/image004.png" /></a></div><br />Anyway, once you have defined the frequency you then have the option to enable the use of the application to administrators or all users.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-taQ3OVVp5RE/Wu7UlMuvM1I/AAAAAAAAJr4/jUV__mK25dI8gm1EiMfv22iPo1NVPDAegCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="118" data-original-width="760" height="99" src="https://2.bp.blogspot.com/-taQ3OVVp5RE/Wu7UlMuvM1I/AAAAAAAAJr4/jUV__mK25dI8gm1EiMfv22iPo1NVPDAegCLcBGAs/s640/image005.png" width="640" /></a></div><br />You can then create another job to return the application back to all users.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-l66U68TPAkQ/Wu7UlfLSlII/AAAAAAAAJr8/kBIu7WHxnw4RiY5geWp27r3cKs6p-V4TACLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="269" data-original-width="732" height="235" src="https://1.bp.blogspot.com/-l66U68TPAkQ/Wu7UlfLSlII/AAAAAAAAJr8/kBIu7WHxnw4RiY5geWp27r3cKs6p-V4TACLcBGAs/s640/image006.png" width="640" /></a></div><br />This time you would select the use to “All users”.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-TzNSZHbnjOs/Wu7UlnwCWSI/AAAAAAAAJsA/kh5Fe8tvMBk580FsRSBlWNMF1yRcPkmiwCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="764" height="100" src="https://1.bp.blogspot.com/-TzNSZHbnjOs/Wu7UlnwCWSI/AAAAAAAAJsA/kh5Fe8tvMBk580FsRSBlWNMF1yRcPkmiwCLcBGAs/s640/image007.png" width="640" /></a></div><br />When the scheduled job to limit the application to administrators runs, non-admins that are logged into the application will be automatically logged out, any new logins will be greeted with the following message:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-f8rn1xGg4cc/Wu7Ul9q2_jI/AAAAAAAAJsE/ldtT-uMPMAgx7ZcrBdOqSVBq9uDyIQVCgCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="90" data-original-width="464" src="https://1.bp.blogspot.com/-f8rn1xGg4cc/Wu7Ul9q2_jI/AAAAAAAAJsE/ldtT-uMPMAgx7ZcrBdOqSVBq9uDyIQVCgCLcBGAs/s1600/image008.png" /></a></div><br />This will be the case until the job to return the application to all users runs or the system setting is changed in the UI. The next time the schedule jobs are set to run will be available under pending jobs.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-_mVaXZ31tc4/Wu7UmBHbc8I/AAAAAAAAJsI/DzpBfwy3CKcZuIlQaRk-q5gPDU_6Yg3ZwCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="221" data-original-width="374" src="https://2.bp.blogspot.com/-_mVaXZ31tc4/Wu7UmBHbc8I/AAAAAAAAJsI/DzpBfwy3CKcZuIlQaRk-q5gPDU_6Yg3ZwCLcBGAs/s1600/image009.png" /></a></div><br />So what if you don’t know the timings of when you want to limit access to the application (as you may want to include it as part of a scripted process)? Well unfortunately it does not look like Oracle has decided to provide the option to do this using EPM Automate or the REST API yet. In this case you can look at the possibility of trying out the method I provided in my recent <a href="http://john-goodwin.blogspot.co.uk/2018/03/epm-cloud-limiting-use-of-application.html"><b>post</b></a>.<br /><br />I am hoping Oracle will include this at some point in the future and if they do I will provide a further update.<br /><br /><br /></div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-2563221218052367657 Sun May 06 2018 13:52:00 GMT-0400 (EDT) EPM Cloud – Limiting the use of an application through automation - Update @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs http://john-goodwin.blogspot.com/2018/05/epm-cloud-limiting-use-of-application.html <div dir="ltr" style="text-align: left;" trbidi="on">Back with a very quick update, recently I wrote a <a href="http://john-goodwin.blogspot.co.uk/2018/03/epm-cloud-limiting-use-of-application.html"><b>post</b></a> about the different options for limiting the use of an EPM Cloud application to administrators and then returning it to all users.<br /><br />At the time of writing the post, the only option to schedule this process was by creating a refresh database job and setting the enable use of application settings.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-nhZcRgjyT0w/Wu7UkPLJFRI/AAAAAAAAJrw/zT1nJ0SllJ0JOMyys3MFkGTVAf65rA0ZACLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="257" data-original-width="907" height="180" src="https://4.bp.blogspot.com/-nhZcRgjyT0w/Wu7UkPLJFRI/AAAAAAAAJrw/zT1nJ0SllJ0JOMyys3MFkGTVAf65rA0ZACLcBGAs/s640/image001.png" width="640" /></a></div><br />Moving forward to the 18.05 cloud release and there is now a new schedule job option called “Administration Mode”. <br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-MIFtWz4TwVE/Wu7UkAbgHKI/AAAAAAAAJro/C5gQ85BKUcQpNBXNb7KDFdo5ccNYmUBaQCLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="565" data-original-width="1010" height="358" src="https://2.bp.blogspot.com/-MIFtWz4TwVE/Wu7UkAbgHKI/AAAAAAAAJro/C5gQ85BKUcQpNBXNb7KDFdo5ccNYmUBaQCLcBGAs/s640/image002.png" width="640" /></a></div><br />So if you know the exact times you want to limit access to the application, you can create a new job.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-Cmx4h17m99M/Wu7UkFfyL-I/AAAAAAAAJrs/2WRllmCzbvUiUueiWZqdJVZzEp7_59h8gCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="263" data-original-width="735" height="229" src="https://4.bp.blogspot.com/-Cmx4h17m99M/Wu7UkFfyL-I/AAAAAAAAJrs/2WRllmCzbvUiUueiWZqdJVZzEp7_59h8gCLcBGAs/s640/image003.png" width="640" /></a></div><br />It is possible to run the job straight away which would really be the same as going to “System Settings and Defaults” from the navigator, this then provides the options to set the application maintenance mode.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-S1KaWHEsqH0/Wu7UlPb7hAI/AAAAAAAAJr0/hnuk2zECEP4OW2xBJC2N18yRz1r-sA7QgCLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="280" data-original-width="594" src="https://1.bp.blogspot.com/-S1KaWHEsqH0/Wu7UlPb7hAI/AAAAAAAAJr0/hnuk2zECEP4OW2xBJC2N18yRz1r-sA7QgCLcBGAs/s1600/image004.png" /></a></div><br />Anyway, once you have defined the frequency you then have the option to enable the use of the application to administrators or all users.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-taQ3OVVp5RE/Wu7UlMuvM1I/AAAAAAAAJr4/jUV__mK25dI8gm1EiMfv22iPo1NVPDAegCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="118" data-original-width="760" height="99" src="https://2.bp.blogspot.com/-taQ3OVVp5RE/Wu7UlMuvM1I/AAAAAAAAJr4/jUV__mK25dI8gm1EiMfv22iPo1NVPDAegCLcBGAs/s640/image005.png" width="640" /></a></div><br />You can then create another job to return the application back to all users.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-l66U68TPAkQ/Wu7UlfLSlII/AAAAAAAAJr8/kBIu7WHxnw4RiY5geWp27r3cKs6p-V4TACLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="269" data-original-width="732" height="235" src="https://1.bp.blogspot.com/-l66U68TPAkQ/Wu7UlfLSlII/AAAAAAAAJr8/kBIu7WHxnw4RiY5geWp27r3cKs6p-V4TACLcBGAs/s640/image006.png" width="640" /></a></div><br />This time you would select the use to “All users”.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-TzNSZHbnjOs/Wu7UlnwCWSI/AAAAAAAAJsA/kh5Fe8tvMBk580FsRSBlWNMF1yRcPkmiwCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="764" height="100" src="https://1.bp.blogspot.com/-TzNSZHbnjOs/Wu7UlnwCWSI/AAAAAAAAJsA/kh5Fe8tvMBk580FsRSBlWNMF1yRcPkmiwCLcBGAs/s640/image007.png" width="640" /></a></div><br />When the scheduled job to limit the application to administrators runs, non-admins that are logged into the application will be automatically logged out, any new logins will be greeted with the following message:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-f8rn1xGg4cc/Wu7Ul9q2_jI/AAAAAAAAJsE/ldtT-uMPMAgx7ZcrBdOqSVBq9uDyIQVCgCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="90" data-original-width="464" src="https://1.bp.blogspot.com/-f8rn1xGg4cc/Wu7Ul9q2_jI/AAAAAAAAJsE/ldtT-uMPMAgx7ZcrBdOqSVBq9uDyIQVCgCLcBGAs/s1600/image008.png" /></a></div><br />This will be the case until the job to return the application to all users runs or the system setting is changed in the UI. The next time the schedule jobs are set to run will be available under pending jobs.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-_mVaXZ31tc4/Wu7UmBHbc8I/AAAAAAAAJsI/DzpBfwy3CKcZuIlQaRk-q5gPDU_6Yg3ZwCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="221" data-original-width="374" src="https://2.bp.blogspot.com/-_mVaXZ31tc4/Wu7UmBHbc8I/AAAAAAAAJsI/DzpBfwy3CKcZuIlQaRk-q5gPDU_6Yg3ZwCLcBGAs/s1600/image009.png" /></a></div><br />So what if you don’t know the timings of when you want to limit access to the application (as you may want to include it as part of a scripted process)? Well unfortunately it does not look like Oracle has decided to provide the option to do this using EPM Automate or the REST API yet. In this case you can look at the possibility of trying out the method I provided in my recent <a href="http://john-goodwin.blogspot.co.uk/2018/03/epm-cloud-limiting-use-of-application.html"><b>post</b></a>.<br /><br />I am hoping Oracle will include this at some point in the future and if they do I will provide a further update.<br /><br /><br /></div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-2563221218052367657 Sun May 06 2018 13:52:00 GMT-0400 (EDT) ODI Studio Timestamps @CheckPointllc http://blog.checkpointllc.com/odi-studio-timestamps <p>Oracle Data Integrator (ODI) offers many benefits to users extracting, loading, and transforming data in their data intelligence systems. It offers a practical GUI to the user so that they can effectively manage this data. A small setback, however, appears during troubleshooting: mismatched timestamps.</p> <p>When a job is started in ODI Studio, a session is created under the ‘Operator’ to allow for easy monitoring of the process. Each step in the job is listed as it completes, along with a timestamp. This particular timestamp is pulled directly from the database, as oppose to using the current time of the server hosting ODI, or the time zone of the user facilitating the work. This can pose a problem when the time zone of the database and the application server are drastically different. For example, a database hosted in UTC (+00:00) and an application server hosted in CST (-06:00). Trouble shooting at this stage is still doable, but converting timestamps to match other events in the EPM environment can quickly become tiresome.</p> <p>Altering the configuration files for ODI can sometimes compound the issue. Altering the time zone for ODI inside the config file will indeed change the time inside of ODI Studio, but only for any scheduling done; Timestamps for the session events will still be pulled directly from the database level. There is no way to force these timestamps to sync with the server instead of the database. In fact, Oracle has stated that this expected behavior for the application. If you are faced with this issue, the only work around is to create a custom script at the database level that converts all timestamps for that session to a different time zone. The downside to this is, Oracle will not write any custom scripts or support applications that use this method. </p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fodi-studio-timestamps&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/odi-studio-timestamps Fri May 04 2018 09:17:00 GMT-0400 (EDT) ODI Studio Timestamps http://blog.checkpointllc.com/odi-studio-timestamps <p>Oracle Data Integrator (ODI) offers many benefits to users extracting, loading, and transforming data in their data intelligence systems. It offers a practical GUI to the user so that they can effectively manage this data. A small setback, however, appears during troubleshooting: mismatched timestamps.</p> <p>When a job is started in ODI Studio, a session is created under the ‘Operator’ to allow for easy monitoring of the process. Each step in the job is listed as it completes, along with a timestamp. This particular timestamp is pulled directly from the database, as oppose to using the current time of the server hosting ODI, or the time zone of the user facilitating the work. This can pose a problem when the time zone of the database and the application server are drastically different. For example, a database hosted in UTC (+00:00) and an application server hosted in CST (-06:00). Trouble shooting at this stage is still doable, but converting timestamps to match other events in the EPM environment can quickly become tiresome.</p> <p>Altering the configuration files for ODI can sometimes compound the issue. Altering the time zone for ODI inside the config file will indeed change the time inside of ODI Studio, but only for any scheduling done; Timestamps for the session events will still be pulled directly from the database level. There is no way to force these timestamps to sync with the server instead of the database. In fact, Oracle has stated that this expected behavior for the application. If you are faced with this issue, the only work around is to create a custom script at the database level that converts all timestamps for that session to a different time zone. The downside to this is, Oracle will not write any custom scripts or support applications that use this method. </p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fodi-studio-timestamps&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/odi-studio-timestamps Fri May 04 2018 09:17:00 GMT-0400 (EDT) Loading Data into FCCS @TopDownInc @orclEPMblogs @orclEPMblogs @orclEPMblogs https://blog.topdownconsulting.com/2018/05/loading-data-into-fccs/ <p><a href="https://blog.topdownconsulting.com/2017/01/1672/">Migrating from HFM to FCCS</a>? To make sure you’re successful, it is crucial to have a firm understanding of the Movement, Data Source <a href="https://blog.topdownconsulting.com/2016/12/top-10-topdown-consulting-blog-posts-of-2016-10/">dimensions</a>, and <a href="https://blog.topdownconsulting.com/2017/12/fccs-where-are-we-now/">built-in calculations</a> in FCCS.</p> <h4>Dimensions</h4> <p>The <a href="https://blog.topdownconsulting.com/2016/12/top-10-topdown-consulting-blog-posts-of-2016-10/">Movement dimension</a> drives the behavior of your data in FCCS. Not understanding this concept in FCCS will lead to a lot of frustration when loading and reconciling <a href="https://blog.topdownconsulting.com/2017/11/another-look-reconciling-data/">historical data</a> in FCCS. It is important to understand how movement members translate and where opening balances are populated.</p> <p><em>For example, it is very important to spend time mapping your balance sheet accounts to the correct movement member for cash flow.  If you have already loaded a full year of historical data and realize your cash flow movements are not correct, you will have to reload data to the correct movement or adjust your opening balances and move forward.</em></p> <p>In addition to the Movement and Data Source dimensions, understanding the attributes of all dimensions will help in achieving the highest performance from FCCS. Incorrect dimension attributes can severely impact FCCS performance. With the new simplified dimension editor, it will notify a user when an invalid attribute is assigned to a member.  But of course, this cannot validate 100% of the possible combinations.</p> <p>It is also important to understand how the Data Source dimension is leveraged in certain activities within FCCS. Clearing data and <a href="https://blog.topdownconsulting.com/2015/03/intercompany-eliminations-in-custom-dimensions/">Intercompany Eliminations</a> within FCCS both leverage specific Data Source members. Having a greater appreciation for this concept will save you some frustration during development.</p> <h4>Opening Balances and Periodic vs. YTD</h4> <p>Understanding Opening Balances and Periodic vs YTD data loading is another key to success. FCCS automatically calculates the Opening Balance for all Balance Sheet and P&amp;L accounts within the current year by getting the closing balance of the same account from previous year / last period. The Opening Balance is recorded within the Movement dimension. You then need to upload the periodic movement activity each month within the current year so that the current period closing balance equals the Opening Balance plus monthly activity. Though FCCS provides the ability to load YTD data from Data Management, it should be noted that FCCS stored data on a periodic basis. Given that FCCS automatically calculates the Opening Balances for any account, the data load file should only include the Periodic movement activity (i.e. the periodic difference between the current period vs prior period).</p> <h4>Built on Essbase</h4> <p>Finally, it is important to remember that FCCS is built on <a href="https://www.topdownconsulting.com/resources/by-topic/essbase/">Essbase</a>, which means the amount of data in the application impacts performance. The more data there is, the longer it takes to refresh the database after changes have been made to the application. In HFM, it is not uncommon to make changes in the application during the close process. Those activities will need to be considered and planned in FCCS as an extended database refresh could cause delays in the month-end close process. For example, security changes are stored at the Essbase layer, so changes require database refreshes.  Other performance considerations include managing the number of snapshots maintained on the cloud as well as “cleaning up” Audit artifacts.  These items can be easy archived on internal servers freeing up space on the cloud.</p> <h4>One More Thing&#8230;</h4> <p><a href="https://www.topdownconsulting.com/resources/by-topic/oracle-epm-cloud/">FCCS</a> is a great tool and you can take advantage of all the out of the box features and enhancements available when you understand that the optimal way of loading data is the foundation of making the application work for you.</p> <p id="qCKLGZm"> <p>The post <a rel="nofollow" href="https://blog.topdownconsulting.com/2018/05/loading-data-into-fccs/">Loading Data into FCCS</a> appeared first on <a rel="nofollow" href="https://blog.topdownconsulting.com">TopDown Consulting Blog</a>.</p> Brian Willson https://blog.topdownconsulting.com/?p=2208 Wed May 02 2018 18:51:33 GMT-0400 (EDT) Loading Data into FCCS https://blog.topdownconsulting.com/2018/05/loading-data-into-fccs/ <p><a href="https://blog.topdownconsulting.com/2017/01/1672/">Migrating from HFM to FCCS</a>? To make sure you’re successful, it is crucial to have a firm understanding of the Movement, Data Source <a href="https://blog.topdownconsulting.com/2016/12/top-10-topdown-consulting-blog-posts-of-2016-10/">dimensions</a>, and <a href="https://blog.topdownconsulting.com/2017/12/fccs-where-are-we-now/">built-in calculations</a> in FCCS.</p> <h4>Dimensions</h4> <p>The <a href="https://blog.topdownconsulting.com/2016/12/top-10-topdown-consulting-blog-posts-of-2016-10/">Movement dimension</a> drives the behavior of your data in FCCS. Not understanding this concept in FCCS will lead to a lot of frustration when loading and reconciling <a href="https://blog.topdownconsulting.com/2017/11/another-look-reconciling-data/">historical data</a> in FCCS. It is important to understand how movement members translate and where opening balances are populated.</p> <p><em>For example, it is very important to spend time mapping your balance sheet accounts to the correct movement member for cash flow.  If you have already loaded a full year of historical data and realize your cash flow movements are not correct, you will have to reload data to the correct movement or adjust your opening balances and move forward.</em></p> <p>In addition to the Movement and Data Source dimensions, understanding the attributes of all dimensions will help in achieving the highest performance from FCCS. Incorrect dimension attributes can severely impact FCCS performance. With the new simplified dimension editor, it will notify a user when an invalid attribute is assigned to a member.  But of course, this cannot validate 100% of the possible combinations.</p> <p>It is also important to understand how the Data Source dimension is leveraged in certain activities within FCCS. Clearing data and <a href="https://blog.topdownconsulting.com/2015/03/intercompany-eliminations-in-custom-dimensions/">Intercompany Eliminations</a> within FCCS both leverage specific Data Source members. Having a greater appreciation for this concept will save you some frustration during development.</p> <h4>Opening Balances and Periodic vs. YTD</h4> <p>Understanding Opening Balances and Periodic vs YTD data loading is another key to success. FCCS automatically calculates the Opening Balance for all Balance Sheet and P&amp;L accounts within the current year by getting the closing balance of the same account from previous year / last period. The Opening Balance is recorded within the Movement dimension. You then need to upload the periodic movement activity each month within the current year so that the current period closing balance equals the Opening Balance plus monthly activity. Though FCCS provides the ability to load YTD data from Data Management, it should be noted that FCCS stored data on a periodic basis. Given that FCCS automatically calculates the Opening Balances for any account, the data load file should only include the Periodic movement activity (i.e. the periodic difference between the current period vs prior period).</p> <h4>Built on Essbase</h4> <p>Finally, it is important to remember that FCCS is built on <a href="https://www.topdownconsulting.com/resources/by-topic/essbase/">Essbase</a>, which means the amount of data in the application impacts performance. The more data there is, the longer it takes to refresh the database after changes have been made to the application. In HFM, it is not uncommon to make changes in the application during the close process. Those activities will need to be considered and planned in FCCS as an extended database refresh could cause delays in the month-end close process. For example, security changes are stored at the Essbase layer, so changes require database refreshes.  Other performance considerations include managing the number of snapshots maintained on the cloud as well as “cleaning up” Audit artifacts.  These items can be easy archived on internal servers freeing up space on the cloud.</p> <h4>One More Thing&#8230;</h4> <p><a href="https://www.topdownconsulting.com/resources/by-topic/oracle-epm-cloud/">FCCS</a> is a great tool and you can take advantage of all the out of the box features and enhancements available when you understand that the optimal way of loading data is the foundation of making the application work for you.</p> <p id="qCKLGZm"> <p>The post <a rel="nofollow" href="https://blog.topdownconsulting.com/2018/05/loading-data-into-fccs/">Loading Data into FCCS</a> appeared first on <a rel="nofollow" href="https://blog.topdownconsulting.com">TopDown Consulting Blog</a>.</p> Brian Willson https://blog.topdownconsulting.com/?p=2208 Wed May 02 2018 18:51:33 GMT-0400 (EDT) Planning Track Highlights – Leo Gonzalez @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=791&source=1 Leo Gonzalez, Planning track lead for ODTUG Kscope18, shares his top five Planning sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=791&source=1 Wed May 02 2018 12:35:25 GMT-0400 (EDT) Planning Track Highlights – Leo Gonzalez https://www.odtug.com/p/bl/et/blogaid=791&source=1 Leo Gonzalez, Planning track lead for ODTUG Kscope18, shares his top five Planning sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=791&source=1 Wed May 02 2018 12:35:25 GMT-0400 (EDT) EPM Infrastructure Track Highlights – Richard Philipson @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=788&source=1 Richard Philipson, EPM Infrastructure track lead for ODTUG Kscope18, shares his top EPM Infrastructure Track Sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=788&source=1 Wed May 02 2018 12:35:20 GMT-0400 (EDT) EPM Infrastructure Track Highlights – Richard Philipson https://www.odtug.com/p/bl/et/blogaid=788&source=1 Richard Philipson, EPM Infrastructure track lead for ODTUG Kscope18, shares his top EPM Infrastructure Track Sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=788&source=1 Wed May 02 2018 12:35:20 GMT-0400 (EDT) Essbase Track Highlights – Matias Panario @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=789&source=1 Matias Panario, Essbase track lead, shares his top four sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=789&source=1 Wed May 02 2018 12:35:14 GMT-0400 (EDT) Essbase Track Highlights – Matias Panario https://www.odtug.com/p/bl/et/blogaid=789&source=1 Matias Panario, Essbase track lead, shares his top four sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=789&source=1 Wed May 02 2018 12:35:14 GMT-0400 (EDT) Financial Close Track Highlights – Julien Coudrette @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=792&source=1 Julien Coudrette, Financial Close track lead for ODTUG Kscope18, shares his top five Financial Close sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=792&source=1 Wed May 02 2018 12:35:08 GMT-0400 (EDT) Financial Close Track Highlights – Julien Coudrette https://www.odtug.com/p/bl/et/blogaid=792&source=1 Julien Coudrette, Financial Close track lead for ODTUG Kscope18, shares his top five Financial Close sessions with reasons why they are his "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=792&source=1 Wed May 02 2018 12:35:08 GMT-0400 (EDT) EPM Data Integration Track Highlights – Jon Harvey @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=787&source=1 Jon Harvey, EPM Data Integration track lead, shares his top three Data Integration track sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=787&source=1 Wed May 02 2018 12:35:02 GMT-0400 (EDT) EPM Data Integration Track Highlights – Jon Harvey https://www.odtug.com/p/bl/et/blogaid=787&source=1 Jon Harvey, EPM Data Integration track lead, shares his top three Data Integration track sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=787&source=1 Wed May 02 2018 12:35:02 GMT-0400 (EDT) EPM Reporting, BI Analytics, and Data Visualization Track Highlights – Teal Sexton @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=790&source=1 Teal Sexton, EPM Reporting, BI Analytics, and Data Visualization track lead for ODTUG Kscope18, shares her top five Track Sessions with reasons why they are her "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=790&source=1 Wed May 02 2018 12:34:56 GMT-0400 (EDT) EPM Reporting, BI Analytics, and Data Visualization Track Highlights – Teal Sexton https://www.odtug.com/p/bl/et/blogaid=790&source=1 Teal Sexton, EPM Reporting, BI Analytics, and Data Visualization track lead for ODTUG Kscope18, shares her top five Track Sessions with reasons why they are her "don't-miss sessions" at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=790&source=1 Wed May 02 2018 12:34:56 GMT-0400 (EDT) Big Data and Data Warehousing Track Highlights – Michael Rainey @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=793&source=1 Michael Rainey, Big Data and Data Warehousing track lead, shares his top three sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=793&source=1 Wed May 02 2018 12:34:48 GMT-0400 (EDT) Big Data and Data Warehousing Track Highlights – Michael Rainey https://www.odtug.com/p/bl/et/blogaid=793&source=1 Michael Rainey, Big Data and Data Warehousing track lead, shares his top three sessions with reasons why they are his “don’t-miss sessions” at ODTUG Kscope18. ODTUG https://www.odtug.com/p/bl/et/blogaid=793&source=1 Wed May 02 2018 12:34:48 GMT-0400 (EDT) APEX Track Highlights – Dietmar Aust @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=794&source=1 Here is an overview of a few sessions Application Express track lead, Dietmar Aust, is most looking forward to at ODTUG Kscope18 and why he will be attending them. ODTUG https://www.odtug.com/p/bl/et/blogaid=794&source=1 Wed May 02 2018 12:34:43 GMT-0400 (EDT) APEX Track Highlights – Dietmar Aust https://www.odtug.com/p/bl/et/blogaid=794&source=1 Here is an overview of a few sessions Application Express track lead, Dietmar Aust, is most looking forward to at ODTUG Kscope18 and why he will be attending them. ODTUG https://www.odtug.com/p/bl/et/blogaid=794&source=1 Wed May 02 2018 12:34:43 GMT-0400 (EDT) Database Track Highlights – Helen Sanders @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=795&source=1 Helen Sanders, Database track lead, gives you the top five “not-to-be missed” sessions (in no particular order) of the ODTUG Kscope18 Database track. ODTUG https://www.odtug.com/p/bl/et/blogaid=795&source=1 Wed May 02 2018 12:34:32 GMT-0400 (EDT) Database Track Highlights – Helen Sanders https://www.odtug.com/p/bl/et/blogaid=795&source=1 Helen Sanders, Database track lead, gives you the top five “not-to-be missed” sessions (in no particular order) of the ODTUG Kscope18 Database track. ODTUG https://www.odtug.com/p/bl/et/blogaid=795&source=1 Wed May 02 2018 12:34:32 GMT-0400 (EDT) PBCS and EPBCS Updates (May 2018): New Administration Mode Job Type, Self-Service Content Update, Considerations & More @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/pbcs%20updates%20may%202018.jpg?t=1526938888034" alt="pbcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for Oracle's<span>&nbsp;</span><a href="https://www.us-analytics.com/hyperionblog/pbcs-vs-epbcs-comparing-oracle-cloud-planning-applications">Planning &amp; Budgeting Cloud Service (PBCS) and Enterprise Planning and Budgeting Cloud Service (EPBCS)</a><span>&nbsp;have arrived!&nbsp;</span>This blog post outlines several new features for both applications.</p> <p><em>The monthly update for PBCS and EPBCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Fpbcs-and-epbcs-2018-may-updates&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates Mon Apr 30 2018 16:45:18 GMT-0400 (EDT) PBCS and EPBCS Updates (May 2018): New Administration Mode Job Type, Self-Service Content Update, Considerations & More https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/pbcs%20updates%20may%202018.jpg?t=1526938888034" alt="pbcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for Oracle's<span>&nbsp;</span><a href="https://www.us-analytics.com/hyperionblog/pbcs-vs-epbcs-comparing-oracle-cloud-planning-applications">Planning &amp; Budgeting Cloud Service (PBCS) and Enterprise Planning and Budgeting Cloud Service (EPBCS)</a><span>&nbsp;have arrived!&nbsp;</span>This blog post outlines several new features for both applications.</p> <p><em>The monthly update for PBCS and EPBCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Fpbcs-and-epbcs-2018-may-updates&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/pbcs-and-epbcs-2018-may-updates Mon Apr 30 2018 16:45:18 GMT-0400 (EDT) FCCS Updates (May 2018): Seeded System Consolidation Rule-sets, Enhancements to Dashboards, Considerations & More @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/fccs%20updates%20may%202018.jpg?t=1526938888034" alt="fccs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for&nbsp;<a href="https://www.us-analytics.com/hyperionblog/faq-oracle-financial-consolidation-and-close-cloud-service-fccs">Oracle's<span>&nbsp;Financial Consolidation and Close Cloud Service</span>&nbsp;(FCCS)</a><span>&nbsp;are here!</span><span>&nbsp;</span>This blog post outlines new features, including seeded system consolidation rule-sets, enhancements to dashboards as well as many considerations for using FCCS.&nbsp;</p> <p><em>The monthly update for FCCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ffccs-updates-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018 Mon Apr 30 2018 13:56:19 GMT-0400 (EDT) FCCS Updates (May 2018): Seeded System Consolidation Rule-sets, Enhancements to Dashboards, Considerations & More https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/fccs%20updates%20may%202018.jpg?t=1526938888034" alt="fccs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for&nbsp;<a href="https://www.us-analytics.com/hyperionblog/faq-oracle-financial-consolidation-and-close-cloud-service-fccs">Oracle's<span>&nbsp;Financial Consolidation and Close Cloud Service</span>&nbsp;(FCCS)</a><span>&nbsp;are here!</span><span>&nbsp;</span>This blog post outlines new features, including seeded system consolidation rule-sets, enhancements to dashboards as well as many considerations for using FCCS.&nbsp;</p> <p><em>The monthly update for FCCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Ffccs-updates-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/fccs-updates-may-2018 Mon Apr 30 2018 13:56:19 GMT-0400 (EDT) Variablizing the Left Side of the Equation with @XWRITE @ecapitaladvisor @orclEPMblogs @orclEPMblogs http://www.ecapitaladvisors.com/blog/variablizing-the-left-side-of-the-equation-with-xwrite/ <p>A common need in an Essbase calc script is to map values from one dimension to another. For example, let’s say you...</p> <p>The post <a rel="nofollow" href="http://www.ecapitaladvisors.com/blog/variablizing-the-left-side-of-the-equation-with-xwrite/">Variablizing the Left Side of the Equation with @XWRITE</a> appeared first on <a rel="nofollow" href="http://www.ecapitaladvisors.com">eCapital Advisors</a>.</p> Amy Stine http://www.ecapitaladvisors.com/?p=9307 Mon Apr 30 2018 13:03:35 GMT-0400 (EDT) Variablizing the Left Side of the Equation with @XWRITE http://www.ecapitaladvisors.com/blog/variablizing-the-left-side-of-the-equation-with-xwrite/ <p>A common need in an Essbase calc script is to map values from one dimension to another. For example, let’s say you...</p> <p>The post <a rel="nofollow" href="http://www.ecapitaladvisors.com/blog/variablizing-the-left-side-of-the-equation-with-xwrite/">Variablizing the Left Side of the Equation with @XWRITE</a> appeared first on <a rel="nofollow" href="http://www.ecapitaladvisors.com">eCapital Advisors</a>.</p> Amy Stine http://www.ecapitaladvisors.com/?p=9307 Mon Apr 30 2018 13:03:35 GMT-0400 (EDT) EPRCS Updates (May 2018): Migration of Mappings to New Taxonomy, Considerations for Report Packages, Smart View & More @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/eprcs%20updates%20may%202018.jpg?t=1526938888034" alt="eprcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>In this blog, we'll cover the May updates for&nbsp;<a href="https://www.us-analytics.com/hyperionblog/enterprise-performance-reporting-cloud">Oracle Enterprise Performance Reporting Cloud Service (EPRCS)</a>&nbsp;including considerations for report packages, management reporting, Smart View, and more.</p> <p><em>The monthly update for EPRCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Feprcs-updates-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018 Mon Apr 30 2018 12:39:42 GMT-0400 (EDT) EPRCS Updates (May 2018): Migration of Mappings to New Taxonomy, Considerations for Report Packages, Smart View & More https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/eprcs%20updates%20may%202018.jpg?t=1526938888034" alt="eprcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>In this blog, we'll cover the May updates for&nbsp;<a href="https://www.us-analytics.com/hyperionblog/enterprise-performance-reporting-cloud">Oracle Enterprise Performance Reporting Cloud Service (EPRCS)</a>&nbsp;including considerations for report packages, management reporting, Smart View, and more.</p> <p><em>The monthly update for EPRCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Feprcs-updates-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/eprcs-updates-may-2018 Mon Apr 30 2018 12:39:42 GMT-0400 (EDT) ARCS Updates (May 2018): Enhancements to User Interface, Loading a Bank File Using Data Management & More @usanalytics @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/arcs%20updates%20may%202018.jpg?t=1526938888034" alt="arcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for Oracle's&nbsp;<a href="https://www.us-analytics.com/hyperionblog/faq-account-reconciliation-cloud-service-arcs">Account Reconciliation Cloud Service (ARCS</a>) are here. In this blog post, we’ll outline new features in ARCS, including enhancements to the user interface, exporting transactions to a CSV file, and more.&nbsp;</p> <p>We’ll let you know any time there are updates to ARCS or any other Oracle EPM cloud products. Check the&nbsp;<a href="https://www.us-analytics.com/hyperionblog">US-Analytics Oracle EPM &amp; BI Blog</a><span>&nbsp;</span>every month.</p> <p><em>The monthly update for Oracle ARCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3 style="text-align: center;"></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Farcs-product-update-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018 Mon Apr 30 2018 11:32:25 GMT-0400 (EDT) ARCS Updates (May 2018): Enhancements to User Interface, Loading a Bank File Using Data Management & More https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018 <div class="hs-featured-image-wrapper"> <a href="https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018" title="" class="hs-featured-image-link"> <img src="https://www.us-analytics.com/hubfs/arcs%20updates%20may%202018.jpg?t=1526938888034" alt="arcs updates may 2018" class="hs-featured-image" style="width:auto !important; max-width:50%; float:left; margin:0 15px 15px 0;"> </a> </div> <p>The May updates for Oracle's&nbsp;<a href="https://www.us-analytics.com/hyperionblog/faq-account-reconciliation-cloud-service-arcs">Account Reconciliation Cloud Service (ARCS</a>) are here. In this blog post, we’ll outline new features in ARCS, including enhancements to the user interface, exporting transactions to a CSV file, and more.&nbsp;</p> <p>We’ll let you know any time there are updates to ARCS or any other Oracle EPM cloud products. Check the&nbsp;<a href="https://www.us-analytics.com/hyperionblog">US-Analytics Oracle EPM &amp; BI Blog</a><span>&nbsp;</span>every month.</p> <p><em>The monthly update for Oracle ARCS will occur on Friday, May 18 during your normal daily maintenance window.</em></p> <h3 style="text-align: center;"></h3> <img src="https://track.hubspot.com/__ptq.gif?a=135305&amp;k=14&amp;r=https%3A%2F%2Fwww.us-analytics.com%2Fhyperionblog%2Farcs-product-update-may-2018&amp;bu=https%253A%252F%252Fwww.us-analytics.com%252Fhyperionblog&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> Michelle Heath https://www.us-analytics.com/hyperionblog/arcs-product-update-may-2018 Mon Apr 30 2018 11:32:25 GMT-0400 (EDT) EPM Cloud Update – May 2018 – EPBCS, FCCS, PCMCS, ARCS & EPRCS @_Jun_Zhang_ @orclEPMblogs @orclEPMblogs http://theepmlab.com/epm-cloud-update-may-2018-epbcs-fccs-pcmcs-arcs-eprcs/ &#160; Oracle releases the application updates documentation on new features and fixed issues from the Applications Release Readiness site. From there, you will be able to check the update for Customer Experience, Human Capital Management, Enterprise Resource Planning, Supply Chain Management, Enterprise Performance Management. &#160; A quick recap of the EPM applications. Planning and Budgeting Cloud Enterprise Planning Cloud... Jun http://theepmlab.com/?p=1979 Sun Apr 29 2018 20:15:26 GMT-0400 (EDT) EPM Cloud Update – May 2018 – EPBCS, FCCS, PCMCS, ARCS & EPRCS http://theepmlab.com/epm-cloud-update-may-2018-epbcs-fccs-pcmcs-arcs-eprcs/ &#160; Oracle releases the application updates documentation on new features and fixed issues from the Applications Release Readiness site. From there, you will be able to check the update for Customer Experience, Human Capital Management, Enterprise Resource Planning, Supply Chain Management, Enterprise Performance Management. &#160; A quick recap of the EPM applications. Planning and Budgeting Cloud Enterprise Planning Cloud... Jun http://theepmlab.com/?p=1979 Sun Apr 29 2018 20:15:26 GMT-0400 (EDT) Spring Fever .. OAC .. Major League Baseball @gadashek @orclEPMblogs @orclEPMblogs http://adashek-epm.blogspot.com/2018/04/spring-fever-oac-major-league-baseball.html <div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Verdana, sans-serif;">It is that time of year again --</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">when spring is upon us</span><br /><span style="font-family: Verdana, sans-serif;">the snow starts to melt</span><br /><span style="font-family: Verdana, sans-serif;">the birds chirp outside the window in the morning ..&nbsp;</span><br /><span style="font-family: Verdana, sans-serif;">and the Major League Baseball season begins ⚾</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">As I am getting ready for presentations, I wanted to share a few neat visualizations .. a little bit of a sneak peak.</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">CAN'T WAIT for anyone who wants to attend to see the full finished product!</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><b><span style="font-family: Verdana, sans-serif;">Custom Plugin CollapsibleTree</span></b><br /><span style="font-family: Verdana, sans-serif;"><br /></span><i><span style="font-family: Verdana, sans-serif;"><b>WITH </b>DATA (#measure)</span></i><br /><span style="font-family: Verdana, sans-serif;"><br /></span><div class="separator" style="clear: both; text-align: left;"><span style="font-family: Verdana, sans-serif;"><iframe allowFullScreen='true' webkitallowfullscreen='true' mozallowfullscreen='true' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dx9FH9A4WHM6LY4lfndNeASMLniG6YkCLxOPoyCpQnnu31rTlfZW6IfzPpRF_sC8qUzO-4PnD1Vw-xWfCAaUw' class='b-hbp-video b-uploaded' FRAMEBORDER='0' /></span></div><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><i><span style="font-family: Verdana, sans-serif;"><b>WITHOUT </b>DATA (#measure)</span></i><br /><span style="font-family: Verdana, sans-serif;"><br /></span><div class="separator" style="clear: both; text-align: left;"><span style="font-family: Verdana, sans-serif;"><iframe allowFullScreen='true' webkitallowfullscreen='true' mozallowfullscreen='true' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dyfnmBnMvX5fWjdPf3s6jJXUsc82bGES1EN2ysl-CRx3ve8cTHdo0VLiB5h8BpJFINfJlZ1jSR4IQBQpzXfxg' class='b-hbp-video b-uploaded' FRAMEBORDER='0' /></span></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"><br /></span></div><span style="font-family: Verdana, sans-serif;">This is still one of my favorite visualizations!</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">DimPlayer is my favorite combo visualization!</span><br /><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">And now that the 2018 MLB season is underway, it is time to update the ALL_MLB_STATS Essbase cube with 2017 data :)</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">A nice night &amp; weekend little project is about to get started!!&nbsp;</span><span style="font-family: Verdana, sans-serif;">Stay tuned</span><br /><br /><br /></div> G Adashek tag:blogger.com,1999:blog-1699540956788037380.post-3807049230529917538 Sun Apr 29 2018 09:49:00 GMT-0400 (EDT) Spring Fever .. OAC .. Major League Baseball http://adashek-epm.blogspot.com/2018/04/spring-fever-oac-major-league-baseball.html <div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: Verdana, sans-serif;">It is that time of year again --</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">when spring is upon us</span><br /><span style="font-family: Verdana, sans-serif;">the snow starts to melt</span><br /><span style="font-family: Verdana, sans-serif;">the birds chirp outside the window in the morning ..&nbsp;</span><br /><span style="font-family: Verdana, sans-serif;">and the Major League Baseball season begins ⚾</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">As I am getting ready for presentations, I wanted to share a few neat visualizations .. a little bit of a sneak peak.</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">CAN'T WAIT for anyone who wants to attend to see the full finished product!</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><b><span style="font-family: Verdana, sans-serif;">Custom Plugin CollapsibleTree</span></b><br /><span style="font-family: Verdana, sans-serif;"><br /></span><i><span style="font-family: Verdana, sans-serif;"><b>WITH </b>DATA (#measure)</span></i><br /><span style="font-family: Verdana, sans-serif;"><br /></span><div class="separator" style="clear: both; text-align: left;"><span style="font-family: Verdana, sans-serif;"><iframe allowFullScreen='true' webkitallowfullscreen='true' mozallowfullscreen='true' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dx9FH9A4WHM6LY4lfndNeASMLniG6YkCLxOPoyCpQnnu31rTlfZW6IfzPpRF_sC8qUzO-4PnD1Vw-xWfCAaUw' class='b-hbp-video b-uploaded' FRAMEBORDER='0' /></span></div><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><i><span style="font-family: Verdana, sans-serif;"><b>WITHOUT </b>DATA (#measure)</span></i><br /><span style="font-family: Verdana, sans-serif;"><br /></span><div class="separator" style="clear: both; text-align: left;"><span style="font-family: Verdana, sans-serif;"><iframe allowFullScreen='true' webkitallowfullscreen='true' mozallowfullscreen='true' width='320' height='266' src='https://www.blogger.com/video.g?token=AD6v5dyfnmBnMvX5fWjdPf3s6jJXUsc82bGES1EN2ysl-CRx3ve8cTHdo0VLiB5h8BpJFINfJlZ1jSR4IQBQpzXfxg' class='b-hbp-video b-uploaded' FRAMEBORDER='0' /></span></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: Verdana, sans-serif;"><br /></span></div><span style="font-family: Verdana, sans-serif;">This is still one of my favorite visualizations!</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">DimPlayer is my favorite combo visualization!</span><br /><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">And now that the 2018 MLB season is underway, it is time to update the ALL_MLB_STATS Essbase cube with 2017 data :)</span><br /><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">A nice night &amp; weekend little project is about to get started!!&nbsp;</span><span style="font-family: Verdana, sans-serif;">Stay tuned</span><br /><br /><br /></div> G Adashek tag:blogger.com,1999:blog-1699540956788037380.post-3807049230529917538 Sun Apr 29 2018 09:49:00 GMT-0400 (EDT) A New Chapter @erichelmer @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://theitside.net/2018/04/28/a-new-chapter/ <p>&nbsp;</p> <p><strong>A New Chapter</strong></p> <p>Now that Mercury Technology Group is in good hands as Velocity, I decided to move into a new chapter in my career.</p> <p>I’m thrilled to announce that I have joined <a href="https://www.riministreet.com/">Rimini Street Inc.</a></p> <p>For those that know Rimini Street, you already know that our core service is helping customers all over the globe save money by switching from vendor (e.g., Oracle, SAP) maintenance-support by switching to Rimini support. The initial savings are half of what customers are paying in maintenance fees today.</p> <p>For me, I accepted the position of <a href="https://www.riministreet.com/management-team/management-team">Global Vice President of Strategic Services</a> where I will be growing our advanced strategic offerings exclusive to our clients in the way of advanced security services, functional support services, license management advisory services, advanced technical services, roadmaps, mobility and analytics.</p> <p>For those of you that know me, are readers of this blog, or follow me on social media, you know that in the last decade I have spent a lot of time specializing in the IT side of Oracle software &#8211; a lot of Hyperion, a lot of BI.  Of course, Rimini fully supports these products, however my role is a much broader stroke &#8211; and I couldn’t be happier to join an amazing team of professionals.</p> <p>Rimini has roughly 1000 employees with an annual revenue of over $200M.  They went public late last year and is traded under the Nasdaq symbol RMNI. Rimini’s model is simple &#8211; hire the best people (10 years or more of product experience) and deliver stellar support that is better, stronger, and faster than any vendor out there at half the cost. No brainer, right?</p> <p>Anyway, make no mistake about it, I am still very much, if not more so, part of the Oracle user community and will stay tightly involved within the Oracle user group. I plan on continuing my work in the OAUG and the ODTUG, participating in the corresponding conferences, and contributing educational content as needed. However, due to the nature of the new role, I felt it best to resign from the Oracle ACE program that I have been a part of since 2009. I will truly miss all of them.</p> <p>As for “The I.T. Side,“ I’m not sure. I assume my blogging and social media will be much less frequent, and will be a much different subject matter than followers have been accustom. I guess we will see.</p> <p>The good thing is that over the years we have seen much more volunteer participation in the Oracle community for products outside the core database such as Hyperion, BI, etc. (even blockchain sessions at this years’ KSCOPE!). We have more bloggers than ever, and more Oracle ACEs representing apps and middleware &#8211; it’s fantastic. The community is certainly in great hands. Of course, at the same time, we have also seen very prominent advocates leave the ACE program and their blogging legacy in pursuit of opportunities elsewhere. Many just recently. They all have their reasons. It&#8217;s an interesting time.</p> <p>But hey &#8211; that’s the way careers go, that’s the way the industry works &#8211; we all wish everyone the very best and look forward to any opportunity to see friends and colleagues at events all over the world.</p> <p>There are too many people to list to thank for helping me in my Hyperion / BI focused career&#8230;.so I won’t even attempt it. You all know who you are and I especially take my hat off to those that provided and still publish amazing content, for free, on nights and weekends with no compensation or expectation of anything in return.</p> <p>So I’ll leave it at that. Onward and upward. Of course if I can be if any help to anyone &#8211; be it Hyperion, BI, or helping save money on vendor support/maintenance costs, please let me know.</p> <p><em>The views, opinions, and positions expressed by the author are mine alone, and do not necessarily reflect the views, opinions, or positions of my employer, its affiliates, or any employee thereof.  </em></p> <p>&nbsp;</p> <p><strong>About Rimini Street</strong></p> <p>Rimini Street, Inc. (Nasdaq: RMNI) is a global provider of enterprise software products and services, and the leading third-party support provider for Oracle and SAP software products. The company has redefined enterprise software support services since 2005 with an innovative, award-winning program that enables licensees of IBM, Microsoft, Oracle, SAP and other enterprise software vendors to save up to 90 percent on total support costs. Clients can remain on their current software release without any required upgrades for a minimum of 15 years. Over 1,560 global Fortune 500, midmarket, public sector and other organizations from a broad range of industries currently rely on Rimini Street as their trusted, third-party support provider. To learn more, please visit <a href="https://www.riministreet.com" rel="nofollow">https://www.riministreet.com</a>, follow @riministreet on Twitter and find Rimini Street on Facebook and LinkedIn. (C-RMNI)</p> Eric Helmer http://theitside.net/?p=2402 Sat Apr 28 2018 13:12:09 GMT-0400 (EDT) A New Chapter https://theitside.net/2018/04/28/a-new-chapter/ <p>&nbsp;</p> <p><strong>A New Chapter</strong></p> <p>Now that Mercury Technology Group is in good hands as Velocity, I decided to move into a new chapter in my career.</p> <p>I’m thrilled to announce that I have joined <a href="https://www.riministreet.com/">Rimini Street Inc.</a></p> <p>For those that know Rimini Street, you already know that our core service is helping customers all over the globe save money by switching from vendor (e.g., Oracle, SAP) maintenance-support by switching to Rimini support. The initial savings are half of what customers are paying in maintenance fees today.</p> <p>For me, I accepted the position of <a href="https://www.riministreet.com/management-team/management-team">Global Vice President of Strategic Services</a> where I will be growing our advanced strategic offerings exclusive to our clients in the way of advanced security services, functional support services, license management advisory services, advanced technical services, roadmaps, mobility and analytics.</p> <p>For those of you that know me, are readers of this blog, or follow me on social media, you know that in the last decade I have spent a lot of time specializing in the IT side of Oracle software &#8211; a lot of Hyperion, a lot of BI.  Of course, Rimini fully supports these products, however my role is a much broader stroke &#8211; and I couldn’t be happier to join an amazing team of professionals.</p> <p>Rimini has roughly 1000 employees with an annual revenue of over $200M.  They went public late last year and is traded under the Nasdaq symbol RMNI. Rimini’s model is simple &#8211; hire the best people (10 years or more of product experience) and deliver stellar support that is better, stronger, and faster than any vendor out there at half the cost. No brainer, right?</p> <p>Anyway, make no mistake about it, I am still very much, if not more so, part of the Oracle user community and will stay tightly involved within the Oracle user group. I plan on continuing my work in the OAUG and the ODTUG, participating in the corresponding conferences, and contributing educational content as needed. However, due to the nature of the new role, I felt it best to resign from the Oracle ACE program that I have been a part of since 2009. I will truly miss all of them.</p> <p>As for “The I.T. Side,“ I’m not sure. I assume my blogging and social media will be much less frequent, and will be a much different subject matter than followers have been accustom. I guess we will see.</p> <p>The good thing is that over the years we have seen much more volunteer participation in the Oracle community for products outside the core database such as Hyperion, BI, etc. (even blockchain sessions at this years’ KSCOPE!). We have more bloggers than ever, and more Oracle ACEs representing apps and middleware &#8211; it’s fantastic. The community is certainly in great hands. Of course, at the same time, we have also seen very prominent advocates leave the ACE program and their blogging legacy in pursuit of opportunities elsewhere. Many just recently. They all have their reasons. It&#8217;s an interesting time.</p> <p>But hey &#8211; that’s the way careers go, that’s the way the industry works &#8211; we all wish everyone the very best and look forward to any opportunity to see friends and colleagues at events all over the world.</p> <p>There are too many people to list to thank for helping me in my Hyperion / BI focused career&#8230;.so I won’t even attempt it. You all know who you are and I especially take my hat off to those that provided and still publish amazing content, for free, on nights and weekends with no compensation or expectation of anything in return.</p> <p>So I’ll leave it at that. Onward and upward. Of course if I can be if any help to anyone &#8211; be it Hyperion, BI, or helping save money on vendor support/maintenance costs, please let me know.</p> <p><em>The views, opinions, and positions expressed by the author are mine alone, and do not necessarily reflect the views, opinions, or positions of my employer, its affiliates, or any employee thereof.  </em></p> <p>&nbsp;</p> <p><strong>About Rimini Street</strong></p> <p>Rimini Street, Inc. (Nasdaq: RMNI) is a global provider of enterprise software products and services, and the leading third-party support provider for Oracle and SAP software products. The company has redefined enterprise software support services since 2005 with an innovative, award-winning program that enables licensees of IBM, Microsoft, Oracle, SAP and other enterprise software vendors to save up to 90 percent on total support costs. Clients can remain on their current software release without any required upgrades for a minimum of 15 years. Over 1,560 global Fortune 500, midmarket, public sector and other organizations from a broad range of industries currently rely on Rimini Street as their trusted, third-party support provider. To learn more, please visit <a href="https://www.riministreet.com" rel="nofollow">https://www.riministreet.com</a>, follow @riministreet on Twitter and find Rimini Street on Facebook and LinkedIn. (C-RMNI)</p> Eric Helmer http://theitside.net/?p=2402 Sat Apr 28 2018 13:12:09 GMT-0400 (EDT) Content Coming to ODTUG Kscope18 — Hands-On Training, Symposiums, and More! @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=786&source=1 Introducing Oracle Sunday Symposiums, Dodeca Symposium, Hands-On Training, and New Oracle Professionals content coming to ODTUG Kscope18! ODTUG https://www.odtug.com/p/bl/et/blogaid=786&source=1 Fri Apr 27 2018 06:48:08 GMT-0400 (EDT) Content Coming to ODTUG Kscope18 — Hands-On Training, Symposiums, and More! https://www.odtug.com/p/bl/et/blogaid=786&source=1 Introducing Oracle Sunday Symposiums, Dodeca Symposium, Hands-On Training, and New Oracle Professionals content coming to ODTUG Kscope18! ODTUG https://www.odtug.com/p/bl/et/blogaid=786&source=1 Fri Apr 27 2018 06:48:08 GMT-0400 (EDT) ODTUG Kscope18 Women in Technology Event & 2018 Women in Technology Scholar @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=785&source=1 Attend one of the hottest gatherings of the year—the ODTUG Kscope18 Women in Technology (WIT) Event, held on Wednesday, June 13, at 12:45 p.m. Join both women and men in a meaningful experience that sheds light on WIT issues and solutions. ODTUG https://www.odtug.com/p/bl/et/blogaid=785&source=1 Fri Apr 27 2018 06:44:15 GMT-0400 (EDT) ODTUG Kscope18 Women in Technology Event & 2018 Women in Technology Scholar https://www.odtug.com/p/bl/et/blogaid=785&source=1 Attend one of the hottest gatherings of the year—the ODTUG Kscope18 Women in Technology (WIT) Event, held on Wednesday, June 13, at 12:45 p.m. Join both women and men in a meaningful experience that sheds light on WIT issues and solutions. ODTUG https://www.odtug.com/p/bl/et/blogaid=785&source=1 Fri Apr 27 2018 06:44:15 GMT-0400 (EDT) HFM Applications and Clusters @CheckPointllc http://blog.checkpointllc.com/hfm-applications-and-clusters <p>Financial Management server clusters are an efficient way to push specific job types (such as consolidations or reports) to servers best suited to handle them. Clusters can also be used to separate user groups, like standard users and administrators. An issue arises when HFM clusters are mixed with task flows.</p> <p>When an HFM application is registered via Consolidation Administration it is attached to a User Management Project as well as a Cluster. Registering the app immediately changes the cluster preferences of all task flows attached to that application. This means if the task flow was originally configured to run on a specific cluster, registering that app will change the configuration to point every step that references that application to the selected server cluster. Creating multiple copies of the same task flow that points to different clusters is not possible at this time. All copies will be changed as soon as the application is registered.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fhfm-applications-and-clusters&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/hfm-applications-and-clusters Thu Apr 26 2018 09:31:00 GMT-0400 (EDT) HFM Applications and Clusters http://blog.checkpointllc.com/hfm-applications-and-clusters <p>Financial Management server clusters are an efficient way to push specific job types (such as consolidations or reports) to servers best suited to handle them. Clusters can also be used to separate user groups, like standard users and administrators. An issue arises when HFM clusters are mixed with task flows.</p> <p>When an HFM application is registered via Consolidation Administration it is attached to a User Management Project as well as a Cluster. Registering the app immediately changes the cluster preferences of all task flows attached to that application. This means if the task flow was originally configured to run on a specific cluster, registering that app will change the configuration to point every step that references that application to the selected server cluster. Creating multiple copies of the same task flow that points to different clusters is not possible at this time. All copies will be changed as soon as the application is registered.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fhfm-applications-and-clusters&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/hfm-applications-and-clusters Thu Apr 26 2018 09:31:00 GMT-0400 (EDT) FDMEE/Data Management - Managing period mappings - Part 1 http://john-goodwin.blogspot.com/2018/04/fdmeedata-management-managing-period.html <div dir="ltr" style="text-align: left;" trbidi="on">In today’s post I am going to start off by going back to basics as I have recently seen similar questions raised around period mapping, these usually go along the lines of: “Do you have to manually enter period mappings?”.<br /><br />If you are new to on-premise FDMEE or the cloud based Data Management then you will probably be wondering where the import option is for period mappings, unfortunately at the time of writing there is still not an option to do this in the user interface.<br /><br />Adding mappings manually is a cumbersome task and is not helped by the error messages you can be hit with if you don’t follow the correct process exactly.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-hLx0orZbmbM/Wt1_eMUUgLI/AAAAAAAAJpM/lhxQc2f71P4Q3Up8hlPlFAW9E2MOhiqpwCLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="196" data-original-width="912" height="136" src="https://3.bp.blogspot.com/-hLx0orZbmbM/Wt1_eMUUgLI/AAAAAAAAJpM/lhxQc2f71P4Q3Up8hlPlFAW9E2MOhiqpwCLcBGAs/s640/image001.png" width="640" /></a></div><br />All is not lost though as there are ways to handle the importing of period mapping and I am going to cover some possible solutions. If you have been around FDMEE or Data Management for a while then you will probably have your own solution.<br /><br />In this post I am going to concentrate on Data Management but the same concept can be used with FDMEE, then in the next part I will focus on a possible method which will only be available with on-premise FDMEE.<br /><br />To be able to demonstrate this first method I have manually added a couple of global mappings and replicated these against a single target in application mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-DWouzSNlDjQ/Wt1_eAAv9gI/AAAAAAAAJpI/C3YVSQtvfsIQkEhJqBpU85MGfHKNrzTZACLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="213" data-original-width="834" height="163" src="https://3.bp.blogspot.com/-DWouzSNlDjQ/Wt1_eAAv9gI/AAAAAAAAJpI/C3YVSQtvfsIQkEhJqBpU85MGfHKNrzTZACLcBGAs/s640/image002.png" width="640" /></a></div><br />The next step is to extract these mappings, this can be achieved by using Migration or Lifecycle Management (LCM) in the on-premise world.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-LWJph8wn7ZI/Wt1_d4d2NVI/AAAAAAAAJpE/zdh18B_3mRcES1C8R0sxoUJNgVvRhYCzwCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="324" data-original-width="391" src="https://1.bp.blogspot.com/-LWJph8wn7ZI/Wt1_d4d2NVI/AAAAAAAAJpE/zdh18B_3mRcES1C8R0sxoUJNgVvRhYCzwCLcBGAs/s1600/image003.png" /></a></div><br />Once migration has been accessed then click “Data Management” to allow the selection of artifacts to be exported.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-iT9n7Qo1S2U/Wt1_er-luRI/AAAAAAAAJpQ/9LQq4k5USX0q6myeHes1uLIZ_iU7DSxAACLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="493" src="https://2.bp.blogspot.com/-iT9n7Qo1S2U/Wt1_er-luRI/AAAAAAAAJpQ/9LQq4k5USX0q6myeHes1uLIZ_iU7DSxAACLcBGAs/s1600/image004.png" /></a></div><br />If you expand “<b>Global Setup Artifacts</b>” you will see “<b>Period Mapping</b>”, this artifact relates to the Global Period Mappings.<br /><br />You will also see “<b>File</b>” which is part of the Source Period Mappings, this relates to the following in period mappings in the UI.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-z1wVWM51Pjc/Wt1_fCDbIWI/AAAAAAAAJpU/MMACFKc3d2E4TXZfEFxZNm-RAmnNDxmKwCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="645" height="186" src="https://1.bp.blogspot.com/-z1wVWM51Pjc/Wt1_fCDbIWI/AAAAAAAAJpU/MMACFKc3d2E4TXZfEFxZNm-RAmnNDxmKwCLcBGAs/s640/image005.png" width="640" /></a></div><br />One reason why you might use file mappings is to load data where the period and years are in the rows of the source file, I covered this in a previous post which you can read about <b><a href="http://john-goodwin.blogspot.co.uk/2016/12/data-management-loading-data-by.html">here</a></b>.<br /><br />Back to migration, under “<b>Application Data</b>” you will see “<b>Application Period Mapping</b>” and “<b>Explicit Source Period Mapping</b>”<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-XpGfz-7Co8g/Wt1_flv1leI/AAAAAAAAJpY/N_JgC-PMYCEAqy4j3d63o0nQYkK74IoaACLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="544" data-original-width="616" src="https://3.bp.blogspot.com/-XpGfz-7Co8g/Wt1_flv1leI/AAAAAAAAJpY/N_JgC-PMYCEAqy4j3d63o0nQYkK74IoaACLcBGAs/s1600/image006.png" /></a></div><br />The “<b>Application Period Mapping</b>” artifact will export any period mappings which have been added for the target application, an example in the UI would be:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-RASLgw5uiV4/Wt1_gcNXESI/AAAAAAAAJpc/c-pxCC8ZsDQjVIwQeIxKptvYYpbU3rSAgCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="852" height="140" src="https://1.bp.blogspot.com/-RASLgw5uiV4/Wt1_gcNXESI/AAAAAAAAJpc/c-pxCC8ZsDQjVIwQeIxKptvYYpbU3rSAgCLcBGAs/s640/image007.png" width="640" /></a></div><br />For the “<b>Explicit Source Period Mapping</b>” these are taken from the Source Mapping tab in the UI, an example would be if you select the source system as “EPM” and then select a source and target application:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-WXSIty7W6rg/Wt1_gRVYwII/AAAAAAAAJpg/FcBtv4fIyrstoczsvLczZzyEdkCv9pkawCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="168" data-original-width="937" height="114" src="https://3.bp.blogspot.com/-WXSIty7W6rg/Wt1_gRVYwII/AAAAAAAAJpg/FcBtv4fIyrstoczsvLczZzyEdkCv9pkawCLcBGAs/s640/image008.png" width="640" /></a></div><br />For this post I am going to concentrate on the Global and Application Mapping, though it will be the same concept if you want to expand the solution to the other types of mappings.<br /><br />Once the artifacts have been selected in migration and the export run, a snapshot will be generated.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-uZsJIHqwy4I/Wt1_ghzrIhI/AAAAAAAAJpk/Ipv6eujqhDQDl-uXv_uhW9NYZoFra4wsQCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="180" data-original-width="256" src="https://1.bp.blogspot.com/-uZsJIHqwy4I/Wt1_ghzrIhI/AAAAAAAAJpk/Ipv6eujqhDQDl-uXv_uhW9NYZoFra4wsQCLcBGAs/s1600/image009.png" /></a></div><br />The snapshot can be downloaded as a zip file and then extracted.<br /><br />Once extracted, in the directory “<b>\FDMEE-FDM Enterprise Edition\resource\Global Setup Artifacts</b>” there will be an XML file which contains the global period mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-qkAmwHbnFM0/Wt1_g_bIrjI/AAAAAAAAJpo/a5iHX-xTV5YJaHAuvsc1RmCd9yVAddvNACLcBGAs/s1600/image010.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="105" data-original-width="454" src="https://2.bp.blogspot.com/-qkAmwHbnFM0/Wt1_g_bIrjI/AAAAAAAAJpo/a5iHX-xTV5YJaHAuvsc1RmCd9yVAddvNACLcBGAs/s1600/image010.png" /></a></div><br />Opening the XML reveals the mappings which I entered into the Data Management UI earlier.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-aX_BhDPWLPw/Wt1_g36nqjI/AAAAAAAAJps/YU6WyREK6cAgT5s6UvTxF16K09aj_CK2QCLcBGAs/s1600/image011.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="442" data-original-width="404" src="https://1.bp.blogspot.com/-aX_BhDPWLPw/Wt1_g36nqjI/AAAAAAAAJps/YU6WyREK6cAgT5s6UvTxF16K09aj_CK2QCLcBGAs/s1600/image011.png" /></a></div><br />If you don’t really know much about XML then I can imagine the format of the file can be a little bewildering but don’t worry about that at the moment.<br /><br />Hopefully you understand how the elements in the file map back to the UI in data management, for example, “Periodkey” in the file maps to the “Period Key” column in Data Management.<br /><br />Under the directory “<b>\FDMEE-FDM Enterprise Edition\resource\Application Data\&lt;app type&gt;\&lt;app name&gt;</b>” you will see another XML file which holds the application period mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-JaaxWlczh5o/Wt1_hALmqAI/AAAAAAAAJpw/xSItVB9kpmQcXxIZvd5cykBk_R4NgmNXQCLcBGAs/s1600/image012.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="103" data-original-width="549" src="https://4.bp.blogspot.com/-JaaxWlczh5o/Wt1_hALmqAI/AAAAAAAAJpw/xSItVB9kpmQcXxIZvd5cykBk_R4NgmNXQCLcBGAs/s1600/image012.png" /></a></div><br />The format of this file is pretty much the same as the global mapping file except for the element:<br /><br /><b>&lt;Intsystemkey&gt;Target App Name&lt;/Intsystemkey&gt;</b><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-HPB2AFdiWVw/Wt1_hsSL65I/AAAAAAAAJp0/tE5av59ObAYht0q3D8vBZHrh8bm1O-ttgCLcBGAs/s1600/image013.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="405" src="https://3.bp.blogspot.com/-HPB2AFdiWVw/Wt1_hsSL65I/AAAAAAAAJp0/tE5av59ObAYht0q3D8vBZHrh8bm1O-ttgCLcBGAs/s1600/image013.png" /></a></div><br />The order of the elements is slightly different from the global file but actually the order does not matter.<br /><br />So you know the mappings can be exported, this means they also can be imported, all that would be required is to create the XML files in the correct format.<br /><br />Having to go through the XML file manually and add new period mappings would be a tedious task, so how about an automated solution to make life easier.<br /><br />In this first solution I am going to generate the XML from a simpler format which could be first defined in say an Excel file, for Global Mappings I created the following file with two entries for period mappings, the file could contain as many mappings as you like.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-dae5T2P2Tqk/Wt1_hrlpkPI/AAAAAAAAJp4/mPfqdp9vHTQMT2XkPZ_JombwFXXFfYqOwCLcBGAs/s1600/image014.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="83" data-original-width="726" src="https://4.bp.blogspot.com/-dae5T2P2Tqk/Wt1_hrlpkPI/AAAAAAAAJp4/mPfqdp9vHTQMT2XkPZ_JombwFXXFfYqOwCLcBGAs/s1600/image014.png" /></a></div><br />Alternatively, it could be produced directly into a text based file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/--eC7wScIQAY/Wt1_hwpkSeI/AAAAAAAAJp8/Qy3mMAW_uEMKM-BTsvDrGYIXfEnRuJNIQCLcBGAs/s1600/image015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="83" data-original-width="744" height="71" src="https://2.bp.blogspot.com/--eC7wScIQAY/Wt1_hwpkSeI/AAAAAAAAJp8/Qy3mMAW_uEMKM-BTsvDrGYIXfEnRuJNIQCLcBGAs/s640/image015.png" width="640" /></a></div><br />I have made the headings match those in the XML file, they don’t have to match, the only requirement is they are in the same order, so “<b>Period Key</b>” is first and “<b>Year Target</b>” last.<br /><br />I considered different possible ways to generate the target XML file from the above text file. I tested with the XML functionality in Excel which I wasn’t overly impressed with.&nbsp; I looked into VBA in Excel which was certainly possible but it required adding a reference to be able to work with XML objects or it was too messy.<br /><br />I finally decided on PowerShell because it is easily accessible on any Windows machine, there is also a decent XML writer available which is not overcomplicated.<br /><br />I am certainly not saying this is correct solution and you should pick the one that works out best for you, an Excel based solution could be perfectly acceptable, in the end PowerShell was my preferred option. Don’t worry if you don’t know PowerShell as you should be able to reuse the script by just updating the variables in it.<br /><br />Let me briefly go over the script, it does contain comments so I am not going to go into too much detail.<br /><br />The first section of the script contains the variables, some of these are constants like the snapshot directory structure and the period mapping file, the ones that would require updating are the base directory of the extracted snapshot and text file contain the mappings.<br /><br />There are the elements which map to the XML file, the order of these should match the order in the text file.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-Hg0DR4DJfZE/Wt1_iPJHK0I/AAAAAAAAJqA/A1P6VQP1K2MnalA-2kasg1NzIrof-XhmwCLcBGAs/s1600/image016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="299" data-original-width="976" height="196" src="https://3.bp.blogspot.com/-Hg0DR4DJfZE/Wt1_iPJHK0I/AAAAAAAAJqA/A1P6VQP1K2MnalA-2kasg1NzIrof-XhmwCLcBGAs/s640/image016.png" width="640" /></a></div><br />The remaining section of the script basically creates a new XML document, cycles through the lines from the source text file containing the period mappings and writes then in XML format.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-HTw0KAsfyfM/Wt1_iYSsgBI/AAAAAAAAJqE/0MTvwdvROWI31qB0Ar0R2H1DiTtl2WR_gCLcBGAs/s1600/image017.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="905" data-original-width="556" src="https://4.bp.blogspot.com/-HTw0KAsfyfM/Wt1_iYSsgBI/AAAAAAAAJqE/0MTvwdvROWI31qB0Ar0R2H1DiTtl2WR_gCLcBGAs/s1600/image017.png" /></a></div><br />After running the script, the source text file with the mappings has been transformed into the correct XML format in the snapshots period mapping file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-dtdo0KTG9Nk/Wt1_ij3zKRI/AAAAAAAAJqI/_GMziJE_Vukps8RPVWJasPnMp_qwHFXNQCLcBGAs/s1600/image018.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="495" data-original-width="419" src="https://3.bp.blogspot.com/-dtdo0KTG9Nk/Wt1_ij3zKRI/AAAAAAAAJqI/_GMziJE_Vukps8RPVWJasPnMp_qwHFXNQCLcBGAs/s1600/image018.png" /></a></div><br />The snapshot directory structure can be compressed again into a zip file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Wh83OTF3uBE/Wt1_i2r4jDI/AAAAAAAAJqM/o16Pxpr7dp0SvmaP9DdIU5LpJU8_DurnACLcBGAs/s1600/image019.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="52" data-original-width="420" src="https://2.bp.blogspot.com/-Wh83OTF3uBE/Wt1_i2r4jDI/AAAAAAAAJqM/o16Pxpr7dp0SvmaP9DdIU5LpJU8_DurnACLcBGAs/s1600/image019.png" /></a></div><br />Then uploaded to the EPM cloud snapshot area.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-Qe_1S8fCg2A/Wt1_jBRa_pI/AAAAAAAAJqQ/Hzg_22mu-zYPS2GyANS0jXv1l56shZ5zQCLcBGAs/s1600/image020.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="221" data-original-width="239" src="https://3.bp.blogspot.com/-Qe_1S8fCg2A/Wt1_jBRa_pI/AAAAAAAAJqQ/Hzg_22mu-zYPS2GyANS0jXv1l56shZ5zQCLcBGAs/s1600/image020.png" /></a></div><br />Next, the snapshot is imported.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-v4-3-kvz9d4/Wt1_jJndIAI/AAAAAAAAJqU/HUlljHhkE2Mal-grkyuw3B565A_EOASkgCLcBGAs/s1600/image021.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="228" data-original-width="159" src="https://1.bp.blogspot.com/-v4-3-kvz9d4/Wt1_jJndIAI/AAAAAAAAJqU/HUlljHhkE2Mal-grkyuw3B565A_EOASkgCLcBGAs/s1600/image021.png" /></a></div><br />I know the process to compress, upload and import could be automated but as they are simple tasks that would not require repeating too often I left them as manual.<br /><br />After the import has completed, the new mappings are available as Global Mappings in Data Management.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-_cDgJfOtpTU/Wt1_jSkhvOI/AAAAAAAAJqY/QlHckigUKKQ9FYKaBQHbHRKbkxzdKyVfgCLcBGAs/s1600/image022.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="144" data-original-width="788" height="116" src="https://4.bp.blogspot.com/-_cDgJfOtpTU/Wt1_jSkhvOI/AAAAAAAAJqY/QlHckigUKKQ9FYKaBQHbHRKbkxzdKyVfgCLcBGAs/s640/image022.png" width="640" /></a></div><br />This solution works well and can be adapted to work across any of the period mapping types, the downside is you still have to produce the text file with the mappings, how about taking that a step further and letting the script do all the work.<br /><br />Based on the same format for the mappings as I have used above I came up with a new script, it takes user input to enter a start month and period and the number of months to generate in the period mapping file.<br /><br />The first section is nearly identical to the previous script, the only difference is the reading in of the variables for the start month/period and number of months.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-IVEvNB02dCQ/Wt1_jmj_ZFI/AAAAAAAAJqc/t9n5Y2DFkPQCCobepqXGSImgJk-cEtPvACLcBGAs/s1600/image023.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="329" data-original-width="968" height="216" src="https://2.bp.blogspot.com/-IVEvNB02dCQ/Wt1_jmj_ZFI/AAAAAAAAJqc/t9n5Y2DFkPQCCobepqXGSImgJk-cEtPvACLcBGAs/s640/image023.png" width="640" /></a></div><br />The main section of the script operates in a similar way to the previous script, except this time the period key, prior period key, period name, target period month and year target are all calculated.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-4NeNmPxt1vo/Wt1_jgfpMlI/AAAAAAAAJqg/O0WlHsq3HbgfxJ1MrgYPf9xuYKDT9yXfgCLcBGAs/s1600/image024.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="913" data-original-width="571" src="https://4.bp.blogspot.com/-4NeNmPxt1vo/Wt1_jgfpMlI/AAAAAAAAJqg/O0WlHsq3HbgfxJ1MrgYPf9xuYKDT9yXfgCLcBGAs/s1600/image024.png" /></a></div><br />The script generates period keys based on the last day of the month but could easily be updated to suite any range for the key.<br /><br />An example of running the script to produce a mapping file that starts from Jan 2020 and produces two months of output would be:<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-H6WYKHsKw4g/Wt1_j9bsEeI/AAAAAAAAJqk/591i17WXHr8rrQi_GIvZmT8hzGuVDAWWACLcBGAs/s1600/image025.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="72" data-original-width="392" src="https://4.bp.blogspot.com/-H6WYKHsKw4g/Wt1_j9bsEeI/AAAAAAAAJqk/591i17WXHr8rrQi_GIvZmT8hzGuVDAWWACLcBGAs/s1600/image025.png" /></a></div><br />I am only selecting two months for demo purposes, the file can be generated with any number of months.<br /><br />Once the script has been run, the file is generated in the defined snapshot location and in the required XML format.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-k-OiP_fFboY/Wt1_kTJNfhI/AAAAAAAAJqo/t-LkXYoXCIoFaGOY0f_mctwik1e3Xz8wACLcBGAs/s1600/image026.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="445" data-original-width="417" src="https://3.bp.blogspot.com/-k-OiP_fFboY/Wt1_kTJNfhI/AAAAAAAAJqo/t-LkXYoXCIoFaGOY0f_mctwik1e3Xz8wACLcBGAs/s1600/image026.png" /></a></div><br />The snapshot can be compressed to a zip again, uploaded and imported.<br /><br />The new mappings are available after the import has completed.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-PDTYymZzQfw/Wt1_k_AJUgI/AAAAAAAAJqs/EOOofLmk8T8ifV4njlrTsH20QpqAMJWZwCLcBGAs/s1600/image027.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="142" data-original-width="787" height="114" src="https://2.bp.blogspot.com/-PDTYymZzQfw/Wt1_k_AJUgI/AAAAAAAAJqs/EOOofLmk8T8ifV4njlrTsH20QpqAMJWZwCLcBGAs/s640/image027.png" width="640" /></a></div><br />With a few changes and additions, the script can generate application period mappings.<br /><br />I am not going to show the full script, only the differences to the previous one.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-YpQBK-pLpb4/Wt1_lcC0aeI/AAAAAAAAJqw/BD6lOXdfCJYFScht5nHXTkQ8rermSFl3gCLcBGAs/s1600/image028.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="228" data-original-width="1077" height="135" src="https://2.bp.blogspot.com/-YpQBK-pLpb4/Wt1_lcC0aeI/AAAAAAAAJqw/BD6lOXdfCJYFScht5nHXTkQ8rermSFl3gCLcBGAs/s640/image028.png" width="640" /></a></div><br />The variable for the directory location for application period mappings is different than the global one, the mapping file is also different.<br /><br />The elements array includes “Intsystemkey” and the value is the target application name which is read from user input.<br /><br />The only difference in the main section of the script is due to the extra element, so the check goes from 4-6 to 5-7<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-O5Um3DgzFFU/Wt1_lyGhOxI/AAAAAAAAJq0/hnIRbnMDnD4qZ9relGu6ohoro9YjydrSACLcBGAs/s1600/image029.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="408" src="https://2.bp.blogspot.com/-O5Um3DgzFFU/Wt1_lyGhOxI/AAAAAAAAJq0/hnIRbnMDnD4qZ9relGu6ohoro9YjydrSACLcBGAs/s1600/image029.png" /></a></div><br />An example to generate an application mapping file for the application “Vision” for two months, starting from Jan 2020 would be:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-6klk9LvE-i0/Wt1_maJQ1yI/AAAAAAAAJq4/X9N0y9z2lbQyEzEGuEFLxXFD_YKUiVnMACLcBGAs/s1600/image030.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="85" data-original-width="394" src="https://1.bp.blogspot.com/-6klk9LvE-i0/Wt1_maJQ1yI/AAAAAAAAJq4/X9N0y9z2lbQyEzEGuEFLxXFD_YKUiVnMACLcBGAs/s1600/image030.png" /></a></div><br />The application period mapping file is then generated based on the input.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-le2lvFoJUGo/Wt1_m3TonnI/AAAAAAAAJq8/8r9WeSPaAMAQVyrNiFW2G0YhHddaqOIrQCLcBGAs/s1600/image031.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="478" data-original-width="423" src="https://3.bp.blogspot.com/-le2lvFoJUGo/Wt1_m3TonnI/AAAAAAAAJq8/8r9WeSPaAMAQVyrNiFW2G0YhHddaqOIrQCLcBGAs/s1600/image031.png" /></a></div><br />Again, zip the snapshot, upload and import then the application mappings will be available in Data Management.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-7jPuoiZK-7w/Wt1_ng2xIGI/AAAAAAAAJrA/CqcK0yGMiBsz1BDFwMFGQBIrG03vBmz-gCLcBGAs/s1600/image032.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="192" data-original-width="842" height="144" src="https://4.bp.blogspot.com/-7jPuoiZK-7w/Wt1_ng2xIGI/AAAAAAAAJrA/CqcK0yGMiBsz1BDFwMFGQBIrG03vBmz-gCLcBGAs/s640/image032.png" width="640" /></a></div><br />This type of solution can be implemented across EPM Cloud or on-premise and can be used again and again.<br /><br />In the next part I will look at a possible solution that is only available for on-premise as it based around FDMEE custom scripting and direct updates to the repository database tables.</div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-5367998776444384647 Mon Apr 23 2018 03:00:00 GMT-0400 (EDT) FDMEE/Data Management - Managing period mappings - Part 1 @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs http://john-goodwin.blogspot.com/2018/04/fdmeedata-management-managing-period.html <div dir="ltr" style="text-align: left;" trbidi="on">In today’s post I am going to start off by going back to basics as I have recently seen similar questions raised around period mapping, these usually go along the lines of: “Do you have to manually enter period mappings?”.<br /><br />If you are new to on-premise FDMEE or the cloud based Data Management then you will probably be wondering where the import option is for period mappings, unfortunately at the time of writing there is still not an option to do this in the user interface.<br /><br />Adding mappings manually is a cumbersome task and is not helped by the error messages you can be hit with if you don’t follow the correct process exactly.<br /><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-hLx0orZbmbM/Wt1_eMUUgLI/AAAAAAAAJpM/lhxQc2f71P4Q3Up8hlPlFAW9E2MOhiqpwCLcBGAs/s1600/image001.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="196" data-original-width="912" height="136" src="https://3.bp.blogspot.com/-hLx0orZbmbM/Wt1_eMUUgLI/AAAAAAAAJpM/lhxQc2f71P4Q3Up8hlPlFAW9E2MOhiqpwCLcBGAs/s640/image001.png" width="640" /></a></div><br />All is not lost though as there are ways to handle the importing of period mapping and I am going to cover some possible solutions. If you have been around FDMEE or Data Management for a while then you will probably have your own solution.<br /><br />In this post I am going to concentrate on Data Management but the same concept can be used with FDMEE, then in the next part I will focus on a possible method which will only be available with on-premise FDMEE.<br /><br />To be able to demonstrate this first method I have manually added a couple of global mappings and replicated these against a single target in application mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-DWouzSNlDjQ/Wt1_eAAv9gI/AAAAAAAAJpI/C3YVSQtvfsIQkEhJqBpU85MGfHKNrzTZACLcBGAs/s1600/image002.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="213" data-original-width="834" height="163" src="https://3.bp.blogspot.com/-DWouzSNlDjQ/Wt1_eAAv9gI/AAAAAAAAJpI/C3YVSQtvfsIQkEhJqBpU85MGfHKNrzTZACLcBGAs/s640/image002.png" width="640" /></a></div><br />The next step is to extract these mappings, this can be achieved by using Migration or Lifecycle Management (LCM) in the on-premise world.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-LWJph8wn7ZI/Wt1_d4d2NVI/AAAAAAAAJpE/zdh18B_3mRcES1C8R0sxoUJNgVvRhYCzwCLcBGAs/s1600/image003.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="324" data-original-width="391" src="https://1.bp.blogspot.com/-LWJph8wn7ZI/Wt1_d4d2NVI/AAAAAAAAJpE/zdh18B_3mRcES1C8R0sxoUJNgVvRhYCzwCLcBGAs/s1600/image003.png" /></a></div><br />Once migration has been accessed then click “Data Management” to allow the selection of artifacts to be exported.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-iT9n7Qo1S2U/Wt1_er-luRI/AAAAAAAAJpQ/9LQq4k5USX0q6myeHes1uLIZ_iU7DSxAACLcBGAs/s1600/image004.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="579" data-original-width="493" src="https://2.bp.blogspot.com/-iT9n7Qo1S2U/Wt1_er-luRI/AAAAAAAAJpQ/9LQq4k5USX0q6myeHes1uLIZ_iU7DSxAACLcBGAs/s1600/image004.png" /></a></div><br />If you expand “<b>Global Setup Artifacts</b>” you will see “<b>Period Mapping</b>”, this artifact relates to the Global Period Mappings.<br /><br />You will also see “<b>File</b>” which is part of the Source Period Mappings, this relates to the following in period mappings in the UI.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-z1wVWM51Pjc/Wt1_fCDbIWI/AAAAAAAAJpU/MMACFKc3d2E4TXZfEFxZNm-RAmnNDxmKwCLcBGAs/s1600/image005.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="645" height="186" src="https://1.bp.blogspot.com/-z1wVWM51Pjc/Wt1_fCDbIWI/AAAAAAAAJpU/MMACFKc3d2E4TXZfEFxZNm-RAmnNDxmKwCLcBGAs/s640/image005.png" width="640" /></a></div><br />One reason why you might use file mappings is to load data where the period and years are in the rows of the source file, I covered this in a previous post which you can read about <b><a href="http://john-goodwin.blogspot.co.uk/2016/12/data-management-loading-data-by.html">here</a></b>.<br /><br />Back to migration, under “<b>Application Data</b>” you will see “<b>Application Period Mapping</b>” and “<b>Explicit Source Period Mapping</b>”<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-XpGfz-7Co8g/Wt1_flv1leI/AAAAAAAAJpY/N_JgC-PMYCEAqy4j3d63o0nQYkK74IoaACLcBGAs/s1600/image006.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="544" data-original-width="616" src="https://3.bp.blogspot.com/-XpGfz-7Co8g/Wt1_flv1leI/AAAAAAAAJpY/N_JgC-PMYCEAqy4j3d63o0nQYkK74IoaACLcBGAs/s1600/image006.png" /></a></div><br />The “<b>Application Period Mapping</b>” artifact will export any period mappings which have been added for the target application, an example in the UI would be:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-RASLgw5uiV4/Wt1_gcNXESI/AAAAAAAAJpc/c-pxCC8ZsDQjVIwQeIxKptvYYpbU3rSAgCLcBGAs/s1600/image007.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="189" data-original-width="852" height="140" src="https://1.bp.blogspot.com/-RASLgw5uiV4/Wt1_gcNXESI/AAAAAAAAJpc/c-pxCC8ZsDQjVIwQeIxKptvYYpbU3rSAgCLcBGAs/s640/image007.png" width="640" /></a></div><br />For the “<b>Explicit Source Period Mapping</b>” these are taken from the Source Mapping tab in the UI, an example would be if you select the source system as “EPM” and then select a source and target application:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-WXSIty7W6rg/Wt1_gRVYwII/AAAAAAAAJpg/FcBtv4fIyrstoczsvLczZzyEdkCv9pkawCLcBGAs/s1600/image008.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="168" data-original-width="937" height="114" src="https://3.bp.blogspot.com/-WXSIty7W6rg/Wt1_gRVYwII/AAAAAAAAJpg/FcBtv4fIyrstoczsvLczZzyEdkCv9pkawCLcBGAs/s640/image008.png" width="640" /></a></div><br />For this post I am going to concentrate on the Global and Application Mapping, though it will be the same concept if you want to expand the solution to the other types of mappings.<br /><br />Once the artifacts have been selected in migration and the export run, a snapshot will be generated.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-uZsJIHqwy4I/Wt1_ghzrIhI/AAAAAAAAJpk/Ipv6eujqhDQDl-uXv_uhW9NYZoFra4wsQCLcBGAs/s1600/image009.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="180" data-original-width="256" src="https://1.bp.blogspot.com/-uZsJIHqwy4I/Wt1_ghzrIhI/AAAAAAAAJpk/Ipv6eujqhDQDl-uXv_uhW9NYZoFra4wsQCLcBGAs/s1600/image009.png" /></a></div><br />The snapshot can be downloaded as a zip file and then extracted.<br /><br />Once extracted, in the directory “<b>\FDMEE-FDM Enterprise Edition\resource\Global Setup Artifacts</b>” there will be an XML file which contains the global period mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-qkAmwHbnFM0/Wt1_g_bIrjI/AAAAAAAAJpo/a5iHX-xTV5YJaHAuvsc1RmCd9yVAddvNACLcBGAs/s1600/image010.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="105" data-original-width="454" src="https://2.bp.blogspot.com/-qkAmwHbnFM0/Wt1_g_bIrjI/AAAAAAAAJpo/a5iHX-xTV5YJaHAuvsc1RmCd9yVAddvNACLcBGAs/s1600/image010.png" /></a></div><br />Opening the XML reveals the mappings which I entered into the Data Management UI earlier.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-aX_BhDPWLPw/Wt1_g36nqjI/AAAAAAAAJps/YU6WyREK6cAgT5s6UvTxF16K09aj_CK2QCLcBGAs/s1600/image011.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="442" data-original-width="404" src="https://1.bp.blogspot.com/-aX_BhDPWLPw/Wt1_g36nqjI/AAAAAAAAJps/YU6WyREK6cAgT5s6UvTxF16K09aj_CK2QCLcBGAs/s1600/image011.png" /></a></div><br />If you don’t really know much about XML then I can imagine the format of the file can be a little bewildering but don’t worry about that at the moment.<br /><br />Hopefully you understand how the elements in the file map back to the UI in data management, for example, “Periodkey” in the file maps to the “Period Key” column in Data Management.<br /><br />Under the directory “<b>\FDMEE-FDM Enterprise Edition\resource\Application Data\&lt;app type&gt;\&lt;app name&gt;</b>” you will see another XML file which holds the application period mappings.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-JaaxWlczh5o/Wt1_hALmqAI/AAAAAAAAJpw/xSItVB9kpmQcXxIZvd5cykBk_R4NgmNXQCLcBGAs/s1600/image012.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="103" data-original-width="549" src="https://4.bp.blogspot.com/-JaaxWlczh5o/Wt1_hALmqAI/AAAAAAAAJpw/xSItVB9kpmQcXxIZvd5cykBk_R4NgmNXQCLcBGAs/s1600/image012.png" /></a></div><br />The format of this file is pretty much the same as the global mapping file except for the element:<br /><br /><b>&lt;Intsystemkey&gt;Target App Name&lt;/Intsystemkey&gt;</b><br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-HPB2AFdiWVw/Wt1_hsSL65I/AAAAAAAAJp0/tE5av59ObAYht0q3D8vBZHrh8bm1O-ttgCLcBGAs/s1600/image013.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="480" data-original-width="405" src="https://3.bp.blogspot.com/-HPB2AFdiWVw/Wt1_hsSL65I/AAAAAAAAJp0/tE5av59ObAYht0q3D8vBZHrh8bm1O-ttgCLcBGAs/s1600/image013.png" /></a></div><br />The order of the elements is slightly different from the global file but actually the order does not matter.<br /><br />So you know the mappings can be exported, this means they also can be imported, all that would be required is to create the XML files in the correct format.<br /><br />Having to go through the XML file manually and add new period mappings would be a tedious task, so how about an automated solution to make life easier.<br /><br />In this first solution I am going to generate the XML from a simpler format which could be first defined in say an Excel file, for Global Mappings I created the following file with two entries for period mappings, the file could contain as many mappings as you like.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-dae5T2P2Tqk/Wt1_hrlpkPI/AAAAAAAAJp4/mPfqdp9vHTQMT2XkPZ_JombwFXXFfYqOwCLcBGAs/s1600/image014.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="83" data-original-width="726" src="https://4.bp.blogspot.com/-dae5T2P2Tqk/Wt1_hrlpkPI/AAAAAAAAJp4/mPfqdp9vHTQMT2XkPZ_JombwFXXFfYqOwCLcBGAs/s1600/image014.png" /></a></div><br />Alternatively, it could be produced directly into a text based file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/--eC7wScIQAY/Wt1_hwpkSeI/AAAAAAAAJp8/Qy3mMAW_uEMKM-BTsvDrGYIXfEnRuJNIQCLcBGAs/s1600/image015.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="83" data-original-width="744" height="71" src="https://2.bp.blogspot.com/--eC7wScIQAY/Wt1_hwpkSeI/AAAAAAAAJp8/Qy3mMAW_uEMKM-BTsvDrGYIXfEnRuJNIQCLcBGAs/s640/image015.png" width="640" /></a></div><br />I have made the headings match those in the XML file, they don’t have to match, the only requirement is they are in the same order, so “<b>Period Key</b>” is first and “<b>Year Target</b>” last.<br /><br />I considered different possible ways to generate the target XML file from the above text file. I tested with the XML functionality in Excel which I wasn’t overly impressed with.&nbsp; I looked into VBA in Excel which was certainly possible but it required adding a reference to be able to work with XML objects or it was too messy.<br /><br />I finally decided on PowerShell because it is easily accessible on any Windows machine, there is also a decent XML writer available which is not overcomplicated.<br /><br />I am certainly not saying this is correct solution and you should pick the one that works out best for you, an Excel based solution could be perfectly acceptable, in the end PowerShell was my preferred option. Don’t worry if you don’t know PowerShell as you should be able to reuse the script by just updating the variables in it.<br /><br />Let me briefly go over the script, it does contain comments so I am not going to go into too much detail.<br /><br />The first section of the script contains the variables, some of these are constants like the snapshot directory structure and the period mapping file, the ones that would require updating are the base directory of the extracted snapshot and text file contain the mappings.<br /><br />There are the elements which map to the XML file, the order of these should match the order in the text file.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-Hg0DR4DJfZE/Wt1_iPJHK0I/AAAAAAAAJqA/A1P6VQP1K2MnalA-2kasg1NzIrof-XhmwCLcBGAs/s1600/image016.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="299" data-original-width="976" height="196" src="https://3.bp.blogspot.com/-Hg0DR4DJfZE/Wt1_iPJHK0I/AAAAAAAAJqA/A1P6VQP1K2MnalA-2kasg1NzIrof-XhmwCLcBGAs/s640/image016.png" width="640" /></a></div><br />The remaining section of the script basically creates a new XML document, cycles through the lines from the source text file containing the period mappings and writes then in XML format.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-HTw0KAsfyfM/Wt1_iYSsgBI/AAAAAAAAJqE/0MTvwdvROWI31qB0Ar0R2H1DiTtl2WR_gCLcBGAs/s1600/image017.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="905" data-original-width="556" src="https://4.bp.blogspot.com/-HTw0KAsfyfM/Wt1_iYSsgBI/AAAAAAAAJqE/0MTvwdvROWI31qB0Ar0R2H1DiTtl2WR_gCLcBGAs/s1600/image017.png" /></a></div><br />After running the script, the source text file with the mappings has been transformed into the correct XML format in the snapshots period mapping file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-dtdo0KTG9Nk/Wt1_ij3zKRI/AAAAAAAAJqI/_GMziJE_Vukps8RPVWJasPnMp_qwHFXNQCLcBGAs/s1600/image018.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="495" data-original-width="419" src="https://3.bp.blogspot.com/-dtdo0KTG9Nk/Wt1_ij3zKRI/AAAAAAAAJqI/_GMziJE_Vukps8RPVWJasPnMp_qwHFXNQCLcBGAs/s1600/image018.png" /></a></div><br />The snapshot directory structure can be compressed again into a zip file.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-Wh83OTF3uBE/Wt1_i2r4jDI/AAAAAAAAJqM/o16Pxpr7dp0SvmaP9DdIU5LpJU8_DurnACLcBGAs/s1600/image019.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="52" data-original-width="420" src="https://2.bp.blogspot.com/-Wh83OTF3uBE/Wt1_i2r4jDI/AAAAAAAAJqM/o16Pxpr7dp0SvmaP9DdIU5LpJU8_DurnACLcBGAs/s1600/image019.png" /></a></div><br />Then uploaded to the EPM cloud snapshot area.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-Qe_1S8fCg2A/Wt1_jBRa_pI/AAAAAAAAJqQ/Hzg_22mu-zYPS2GyANS0jXv1l56shZ5zQCLcBGAs/s1600/image020.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="221" data-original-width="239" src="https://3.bp.blogspot.com/-Qe_1S8fCg2A/Wt1_jBRa_pI/AAAAAAAAJqQ/Hzg_22mu-zYPS2GyANS0jXv1l56shZ5zQCLcBGAs/s1600/image020.png" /></a></div><br />Next, the snapshot is imported.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-v4-3-kvz9d4/Wt1_jJndIAI/AAAAAAAAJqU/HUlljHhkE2Mal-grkyuw3B565A_EOASkgCLcBGAs/s1600/image021.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="228" data-original-width="159" src="https://1.bp.blogspot.com/-v4-3-kvz9d4/Wt1_jJndIAI/AAAAAAAAJqU/HUlljHhkE2Mal-grkyuw3B565A_EOASkgCLcBGAs/s1600/image021.png" /></a></div><br />I know the process to compress, upload and import could be automated but as they are simple tasks that would not require repeating too often I left them as manual.<br /><br />After the import has completed, the new mappings are available as Global Mappings in Data Management.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-_cDgJfOtpTU/Wt1_jSkhvOI/AAAAAAAAJqY/QlHckigUKKQ9FYKaBQHbHRKbkxzdKyVfgCLcBGAs/s1600/image022.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="144" data-original-width="788" height="116" src="https://4.bp.blogspot.com/-_cDgJfOtpTU/Wt1_jSkhvOI/AAAAAAAAJqY/QlHckigUKKQ9FYKaBQHbHRKbkxzdKyVfgCLcBGAs/s640/image022.png" width="640" /></a></div><br />This solution works well and can be adapted to work across any of the period mapping types, the downside is you still have to produce the text file with the mappings, how about taking that a step further and letting the script do all the work.<br /><br />Based on the same format for the mappings as I have used above I came up with a new script, it takes user input to enter a start month and period and the number of months to generate in the period mapping file.<br /><br />The first section is nearly identical to the previous script, the only difference is the reading in of the variables for the start month/period and number of months.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-IVEvNB02dCQ/Wt1_jmj_ZFI/AAAAAAAAJqc/t9n5Y2DFkPQCCobepqXGSImgJk-cEtPvACLcBGAs/s1600/image023.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="329" data-original-width="968" height="216" src="https://2.bp.blogspot.com/-IVEvNB02dCQ/Wt1_jmj_ZFI/AAAAAAAAJqc/t9n5Y2DFkPQCCobepqXGSImgJk-cEtPvACLcBGAs/s640/image023.png" width="640" /></a></div><br />The main section of the script operates in a similar way to the previous script, except this time the period key, prior period key, period name, target period month and year target are all calculated.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-4NeNmPxt1vo/Wt1_jgfpMlI/AAAAAAAAJqg/O0WlHsq3HbgfxJ1MrgYPf9xuYKDT9yXfgCLcBGAs/s1600/image024.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="913" data-original-width="571" src="https://4.bp.blogspot.com/-4NeNmPxt1vo/Wt1_jgfpMlI/AAAAAAAAJqg/O0WlHsq3HbgfxJ1MrgYPf9xuYKDT9yXfgCLcBGAs/s1600/image024.png" /></a></div><br />The script generates period keys based on the last day of the month but could easily be updated to suite any range for the key.<br /><br />An example of running the script to produce a mapping file that starts from Jan 2020 and produces two months of output would be:<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-H6WYKHsKw4g/Wt1_j9bsEeI/AAAAAAAAJqk/591i17WXHr8rrQi_GIvZmT8hzGuVDAWWACLcBGAs/s1600/image025.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="72" data-original-width="392" src="https://4.bp.blogspot.com/-H6WYKHsKw4g/Wt1_j9bsEeI/AAAAAAAAJqk/591i17WXHr8rrQi_GIvZmT8hzGuVDAWWACLcBGAs/s1600/image025.png" /></a></div><br />I am only selecting two months for demo purposes, the file can be generated with any number of months.<br /><br />Once the script has been run, the file is generated in the defined snapshot location and in the required XML format.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-k-OiP_fFboY/Wt1_kTJNfhI/AAAAAAAAJqo/t-LkXYoXCIoFaGOY0f_mctwik1e3Xz8wACLcBGAs/s1600/image026.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="445" data-original-width="417" src="https://3.bp.blogspot.com/-k-OiP_fFboY/Wt1_kTJNfhI/AAAAAAAAJqo/t-LkXYoXCIoFaGOY0f_mctwik1e3Xz8wACLcBGAs/s1600/image026.png" /></a></div><br />The snapshot can be compressed to a zip again, uploaded and imported.<br /><br />The new mappings are available after the import has completed.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-PDTYymZzQfw/Wt1_k_AJUgI/AAAAAAAAJqs/EOOofLmk8T8ifV4njlrTsH20QpqAMJWZwCLcBGAs/s1600/image027.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="142" data-original-width="787" height="114" src="https://2.bp.blogspot.com/-PDTYymZzQfw/Wt1_k_AJUgI/AAAAAAAAJqs/EOOofLmk8T8ifV4njlrTsH20QpqAMJWZwCLcBGAs/s640/image027.png" width="640" /></a></div><br />With a few changes and additions, the script can generate application period mappings.<br /><br />I am not going to show the full script, only the differences to the previous one.<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-YpQBK-pLpb4/Wt1_lcC0aeI/AAAAAAAAJqw/BD6lOXdfCJYFScht5nHXTkQ8rermSFl3gCLcBGAs/s1600/image028.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="228" data-original-width="1077" height="135" src="https://2.bp.blogspot.com/-YpQBK-pLpb4/Wt1_lcC0aeI/AAAAAAAAJqw/BD6lOXdfCJYFScht5nHXTkQ8rermSFl3gCLcBGAs/s640/image028.png" width="640" /></a></div><br />The variable for the directory location for application period mappings is different than the global one, the mapping file is also different.<br /><br />The elements array includes “Intsystemkey” and the value is the target application name which is read from user input.<br /><br />The only difference in the main section of the script is due to the extra element, so the check goes from 4-6 to 5-7<br /><div>&nbsp;</div><div class="separator" style="clear: both; text-align: center;"><a href="https://2.bp.blogspot.com/-O5Um3DgzFFU/Wt1_lyGhOxI/AAAAAAAAJq0/hnIRbnMDnD4qZ9relGu6ohoro9YjydrSACLcBGAs/s1600/image029.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="121" data-original-width="408" src="https://2.bp.blogspot.com/-O5Um3DgzFFU/Wt1_lyGhOxI/AAAAAAAAJq0/hnIRbnMDnD4qZ9relGu6ohoro9YjydrSACLcBGAs/s1600/image029.png" /></a></div><br />An example to generate an application mapping file for the application “Vision” for two months, starting from Jan 2020 would be:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://1.bp.blogspot.com/-6klk9LvE-i0/Wt1_maJQ1yI/AAAAAAAAJq4/X9N0y9z2lbQyEzEGuEFLxXFD_YKUiVnMACLcBGAs/s1600/image030.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="85" data-original-width="394" src="https://1.bp.blogspot.com/-6klk9LvE-i0/Wt1_maJQ1yI/AAAAAAAAJq4/X9N0y9z2lbQyEzEGuEFLxXFD_YKUiVnMACLcBGAs/s1600/image030.png" /></a></div><br />The application period mapping file is then generated based on the input.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://3.bp.blogspot.com/-le2lvFoJUGo/Wt1_m3TonnI/AAAAAAAAJq8/8r9WeSPaAMAQVyrNiFW2G0YhHddaqOIrQCLcBGAs/s1600/image031.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="478" data-original-width="423" src="https://3.bp.blogspot.com/-le2lvFoJUGo/Wt1_m3TonnI/AAAAAAAAJq8/8r9WeSPaAMAQVyrNiFW2G0YhHddaqOIrQCLcBGAs/s1600/image031.png" /></a></div><br />Again, zip the snapshot, upload and import then the application mappings will be available in Data Management.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-7jPuoiZK-7w/Wt1_ng2xIGI/AAAAAAAAJrA/CqcK0yGMiBsz1BDFwMFGQBIrG03vBmz-gCLcBGAs/s1600/image032.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="192" data-original-width="842" height="144" src="https://4.bp.blogspot.com/-7jPuoiZK-7w/Wt1_ng2xIGI/AAAAAAAAJrA/CqcK0yGMiBsz1BDFwMFGQBIrG03vBmz-gCLcBGAs/s640/image032.png" width="640" /></a></div><br />This type of solution can be implemented across EPM Cloud or on-premise and can be used again and again.<br /><br />In the next part I will look at a possible solution that is only available for on-premise as it based around FDMEE custom scripting and direct updates to the repository database tables.</div> John Goodwin tag:blogger.com,1999:blog-6575283218005807475.post-5367998776444384647 Mon Apr 23 2018 03:00:00 GMT-0400 (EDT) EPM Lab – Conflicting Access Security Setting @_Jun_Zhang_ http://theepmlab.com/epm-lab-conflicting-access-security-setting/ As we know, in Hyperion Planning and EPM cloud applications, such as PBCS, EPBCS, FCCS, etc., we are able to assign access to specific members. The access options are: Read Write None From the above screenshot, we can also see that the inherited access options are: Children Children (inclusive) Descendants Descendants (inclusive) &#160; What if... Jun http://theepmlab.com/?p=2000 Fri Apr 20 2018 23:07:15 GMT-0400 (EDT) EPM Lab – Conflicting Access Security Setting http://theepmlab.com/epm-lab-conflicting-access-security-setting/ As we know, in Hyperion Planning and EPM cloud applications, such as PBCS, EPBCS, FCCS, etc., we are able to assign access to specific members. The access options are: Read Write None From the above screenshot, we can also see that the inherited access options are: Children Children (inclusive) Descendants Descendants (inclusive) &#160; What if... Jun http://theepmlab.com/?p=2000 Fri Apr 20 2018 23:07:15 GMT-0400 (EDT) HFM Task Flow Connections: How Network Integrity Matters @CheckPointllc http://blog.checkpointllc.com/hfm-task-flow-connections-how-network-integrity-matters <p>A key functionality of HFM allows several consolidations, data loads, extracts, emails, etc. to be scheduled and automated via a highly customizable operation called a task flow. These task flows allow for jobs to be completed without manual input between each step which can be a serious time saver, but they also present the opportunity for unforeseen HFM failures which can set you back further than if you simply did it manually. </p> <p>For example, User A starts a task flow they expect to take several hours and then begin their other work. Later that day they come back to the task flow expecting to start their work from where the task flow finished, except that the task flow failed during step two of fifteen and did not progress any further. Now the user is behind and it is your job to find out why and prevent it from happening again.</p> <p>This recently created several problems for a client running consolidations during evening and night time hours. They would return in the morning to find that the task flow had failed with an error: "EPMHFM-66030: An unexpected communication error has occurred” or “EPMHFM-66076: Server XYZ123 is unavailable, connection could not be established.”</p> <p>After reading through the logs, checking every timeout settings possible, and numerous test cases we found that the client’s network was dropping packets for extremely short periods of time (around 5-10 seconds). Although there was already monitoring in place, the intervals were set at 5 minutes and were too broad. For troubleshooting purposes, a custom script to ping the server every five seconds and record dropped packets was put into place. It was seen that the timestamps for the above errors aligned exactly with dropped network packets for the HFM server running the consolidations. While the HFM server was still up and working on the consolidation, the Foundation server was unable to contact it over the network, and stopped the task flow. </p> <p>Currently there is no permanent fix for this (other than a more stable network). There is retry logic build into HFM if the network outage is less than five seconds, but for a longer duration HFM may not reconnect properly. The only workaround Oracle gives to properly recover the application is to restart HFM services. At this time, Oracle has deemed this as unfeasible to fix.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fhfm-task-flow-connections-how-network-integrity-matters&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/hfm-task-flow-connections-how-network-integrity-matters Fri Apr 20 2018 10:42:45 GMT-0400 (EDT) HFM Task Flow Connections: How Network Integrity Matters http://blog.checkpointllc.com/hfm-task-flow-connections-how-network-integrity-matters <p>A key functionality of HFM allows several consolidations, data loads, extracts, emails, etc. to be scheduled and automated via a highly customizable operation called a task flow. These task flows allow for jobs to be completed without manual input between each step which can be a serious time saver, but they also present the opportunity for unforeseen HFM failures which can set you back further than if you simply did it manually. </p> <p>For example, User A starts a task flow they expect to take several hours and then begin their other work. Later that day they come back to the task flow expecting to start their work from where the task flow finished, except that the task flow failed during step two of fifteen and did not progress any further. Now the user is behind and it is your job to find out why and prevent it from happening again.</p> <p>This recently created several problems for a client running consolidations during evening and night time hours. They would return in the morning to find that the task flow had failed with an error: "EPMHFM-66030: An unexpected communication error has occurred” or “EPMHFM-66076: Server XYZ123 is unavailable, connection could not be established.”</p> <p>After reading through the logs, checking every timeout settings possible, and numerous test cases we found that the client’s network was dropping packets for extremely short periods of time (around 5-10 seconds). Although there was already monitoring in place, the intervals were set at 5 minutes and were too broad. For troubleshooting purposes, a custom script to ping the server every five seconds and record dropped packets was put into place. It was seen that the timestamps for the above errors aligned exactly with dropped network packets for the HFM server running the consolidations. While the HFM server was still up and working on the consolidation, the Foundation server was unable to contact it over the network, and stopped the task flow. </p> <p>Currently there is no permanent fix for this (other than a more stable network). There is retry logic build into HFM if the network outage is less than five seconds, but for a longer duration HFM may not reconnect properly. The only workaround Oracle gives to properly recover the application is to restart HFM services. At this time, Oracle has deemed this as unfeasible to fix.</p> <img src="https://track.hubspot.com/__ptq.gif?a=297092&amp;k=14&amp;r=http%3A%2F%2Fblog.checkpointllc.com%2Fhfm-task-flow-connections-how-network-integrity-matters&amp;bu=http%253A%252F%252Fblog.checkpointllc.com&amp;bvt=rss" alt="" width="1" height="1" style="min-height:1px!important;width:1px!important;border-width:0!important;margin-top:0!important;margin-bottom:0!important;margin-right:0!important;margin-left:0!important;padding-top:0!important;padding-bottom:0!important;padding-right:0!important;padding-left:0!important; "> CheckPoint Consulting http://blog.checkpointllc.com/hfm-task-flow-connections-how-network-integrity-matters Fri Apr 20 2018 10:42:45 GMT-0400 (EDT) Patch Today! Don’t Delay! Best Reasons to Upgrade Your EPM System https://ranzal.wordpress.com/2018/04/19/patch-today-dont-delay-best-reasons-to-upgrade-your-epm-system/ <p>Putting off that upgrade to 11.1.2.4? Cloud not whetting your appetite for patches? Patch today. Don&#8217;t delay!</p> <p>&#8220;But we&#8217;re going to the Oracle EPM Cloud soon!&#8221; you say. You should maintain your patches anyway. With the recurring maintenance, updates, and patches available to the EPM Cloud products, expect the on-premise patches to contain similar updates. An upcoming conversion to Oracle EPM Cloud products may benefit from running the latest on-premise codelines.</p> <p>If you have an existing on-premise installation of Oracle EPM System,<strong> be sure to maintain the latest EPM System <em>Patch Set Updates</em> every 3 to 6 months. </strong>Here are a few great reasons why:</p> <p><strong><u>New Features</u></strong></p> <p>Patches often contain reactive bug resolutions to known issues; however, we have also been seeing new functionality released in patches for 11.1.2.4.</p> <p><strong><u>You Own It</u></strong></p> <p>You already pay for it! As long as your Oracle Maintenance contract is current (very likely if you are reading this article), you’re already paying for access to patches. Why leave them unapplied? You are running legacy code when the latest version costs you nothing additional. Windows XP was a great OS, but we&#8217;ve got to keep up with the times.</p> <p><strong><u>Supportability</u></strong></p> <p>Maximize your success by reducing time to resolution on your issues. Should you submit a support request to the vendor, the first line of response to a ticket is often about current patch levels. Once provided, the subsequent reply frequently contains a recommendation to apply the latest Patch Set Updates (PSUs) to see if that fixes the issue. Annoying? Perhaps you&#8217;re a pessimist. Or have just been remiss with your patching. I&#8217;ve certainly changed my mind on the matter and can better side with them. The reason? Supporting the latest codeline is more efficient and effective for the vendor. Your problem may have already been addressed in a code fix. They can better and more quickly support you if they are troubleshooting the current release instead of legacy code.</p> <p><strong><u>Stability</u></strong></p> <p>In older versions, patches seem to come out on a haphazard schedule. Over the last few years, Oracle has regularly streamlined EPM System patch releases – typically releasing Patch Set Updates quarterly, which are different from Patch Set Exceptions. PSUs are a grouping of PSEs or fewer, more significant PSEs that get regression tested collectively by the vendor and are released under a singular patch. We&#8217;ve gained a much higher degree of confidence with this bulk model of PSUs. The organization of release schedule and bug fixes is more dependable and greatly appreciated. The PSU model provides less ambiguity on which patches to apply and brings greater stability to all customers.</p> <p><strong><u>Upgrade</u></strong></p> <p>Maybe it&#8217;s bigger than patching. Are you not on version 11.1.2.4 of your EPM System? Compliance with Enterprise IT requirements around browser version and operating systems is often impetus for an upgrade. But there are also plenty of compelling new software features, functions, conventions, and improvements in 11.1.2.4.</p> <p>Operating System (OS) support for current platforms maximizes your investment and supportability. When 2.4 came out, many customers were forced to upgrade their older systems for compliance with the latest enterprise standards for server operating systems and/or client browser versions. Instead of being faced with an IT mandated technology upgrade, an upgrade on the business’ schedule is preferred.</p> <p><strong><u>What Kind of Effort is Involved?</u></strong></p> <p>The comprehensive effort to bring a simple deployment (3-4 servers, no High Availability) up to the latest PSUs is typically less than a day per environment. That includes an analysis of existing patches, the patching itself as well as any prerequisites, and a post-check verification to confirm all patches applied are properly indicated in the corresponding inventories.</p> <p>An initial patch application may take a little bit longer because there are often common prerequisites to address that don&#8217;t have to be handled with subsequent patching. There are also considerations like bringing WebLogic up to the latest patch level, as well as one-offs like the fixes for the Equifax-discovered vulnerabilities, that don&#8217;t happen frequently. Once you&#8217;ve got a solid base of primary critical patching, additional patching events are typically shorter.</p> <p>Patching can be tricky. Documentation can often be ambiguous, whether it be an unintended omission or even assumed knowledge based on an implied experience or understanding of the product. Sometimes post-install instructions get skipped or SQL statements do not get executed properly as part of the patch. Less experienced resources typically only patch the EPMSystem11R1 Oracle Home; however, did you know that Oracle&#8217;s ADF framework also has an Opatch directory under oracle_common? Possibly because those are often prereqs. But what about Oracle Data Integrator (ODI) and Oracle HTTP Server (OHS)? They also may have applicable OPatches. Who knows what you&#8217;re missing? We do! Let&#8217;s button it up.</p> <p><a href="mailto:info@ranzal.com" target="_blank" rel="noopener">Contact us</a> for more details.</p> AlanRamirez http://ranzal.wordpress.com/?p=2010 Thu Apr 19 2018 14:52:38 GMT-0400 (EDT) Patch Today! Don’t Delay! Best Reasons to Upgrade Your EPM System @ranzal @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://ranzal.wordpress.com/2018/04/19/patch-today-dont-delay-best-reasons-to-upgrade-your-epm-system/ <p>Putting off that upgrade to 11.1.2.4? Cloud not whetting your appetite for patches? Patch today. Don&#8217;t delay!</p> <p>&#8220;But we&#8217;re going to the Oracle EPM Cloud soon!&#8221; you say. You should maintain your patches anyway. With the recurring maintenance, updates, and patches available to the EPM Cloud products, expect the on-premise patches to contain similar updates. An upcoming conversion to Oracle EPM Cloud products may benefit from running the latest on-premise codelines.</p> <p>If you have an existing on-premise installation of Oracle EPM System,<strong> be sure to maintain the latest EPM System <em>Patch Set Updates</em> every 3 to 6 months. </strong>Here are a few great reasons why:</p> <p><strong><u>New Features</u></strong></p> <p>Patches often contain reactive bug resolutions to known issues; however, we have also been seeing new functionality released in patches for 11.1.2.4.</p> <p><strong><u>You Own It</u></strong></p> <p>You already pay for it! As long as your Oracle Maintenance contract is current (very likely if you are reading this article), you’re already paying for access to patches. Why leave them unapplied? You are running legacy code when the latest version costs you nothing additional. Windows XP was a great OS, but we&#8217;ve got to keep up with the times.</p> <p><strong><u>Supportability</u></strong></p> <p>Maximize your success by reducing time to resolution on your issues. Should you submit a support request to the vendor, the first line of response to a ticket is often about current patch levels. Once provided, the subsequent reply frequently contains a recommendation to apply the latest Patch Set Updates (PSUs) to see if that fixes the issue. Annoying? Perhaps you&#8217;re a pessimist. Or have just been remiss with your patching. I&#8217;ve certainly changed my mind on the matter and can better side with them. The reason? Supporting the latest codeline is more efficient and effective for the vendor. Your problem may have already been addressed in a code fix. They can better and more quickly support you if they are troubleshooting the current release instead of legacy code.</p> <p><strong><u>Stability</u></strong></p> <p>In older versions, patches seem to come out on a haphazard schedule. Over the last few years, Oracle has regularly streamlined EPM System patch releases – typically releasing Patch Set Updates quarterly, which are different from Patch Set Exceptions. PSUs are a grouping of PSEs or fewer, more significant PSEs that get regression tested collectively by the vendor and are released under a singular patch. We&#8217;ve gained a much higher degree of confidence with this bulk model of PSUs. The organization of release schedule and bug fixes is more dependable and greatly appreciated. The PSU model provides less ambiguity on which patches to apply and brings greater stability to all customers.</p> <p><strong><u>Upgrade</u></strong></p> <p>Maybe it&#8217;s bigger than patching. Are you not on version 11.1.2.4 of your EPM System? Compliance with Enterprise IT requirements around browser version and operating systems is often impetus for an upgrade. But there are also plenty of compelling new software features, functions, conventions, and improvements in 11.1.2.4.</p> <p>Operating System (OS) support for current platforms maximizes your investment and supportability. When 2.4 came out, many customers were forced to upgrade their older systems for compliance with the latest enterprise standards for server operating systems and/or client browser versions. Instead of being faced with an IT mandated technology upgrade, an upgrade on the business’ schedule is preferred.</p> <p><strong><u>What Kind of Effort is Involved?</u></strong></p> <p>The comprehensive effort to bring a simple deployment (3-4 servers, no High Availability) up to the latest PSUs is typically less than a day per environment. That includes an analysis of existing patches, the patching itself as well as any prerequisites, and a post-check verification to confirm all patches applied are properly indicated in the corresponding inventories.</p> <p>An initial patch application may take a little bit longer because there are often common prerequisites to address that don&#8217;t have to be handled with subsequent patching. There are also considerations like bringing WebLogic up to the latest patch level, as well as one-offs like the fixes for the Equifax-discovered vulnerabilities, that don&#8217;t happen frequently. Once you&#8217;ve got a solid base of primary critical patching, additional patching events are typically shorter.</p> <p>Patching can be tricky. Documentation can often be ambiguous, whether it be an unintended omission or even assumed knowledge based on an implied experience or understanding of the product. Sometimes post-install instructions get skipped or SQL statements do not get executed properly as part of the patch. Less experienced resources typically only patch the EPMSystem11R1 Oracle Home; however, did you know that Oracle&#8217;s ADF framework also has an Opatch directory under oracle_common? Possibly because those are often prereqs. But what about Oracle Data Integrator (ODI) and Oracle HTTP Server (OHS)? They also may have applicable OPatches. Who knows what you&#8217;re missing? We do! Let&#8217;s button it up.</p> <p><a href="mailto:info@ranzal.com" target="_blank" rel="noopener">Contact us</a> for more details.</p> AlanRamirez http://ranzal.wordpress.com/?p=2010 Thu Apr 19 2018 14:52:38 GMT-0400 (EDT) Announcing the 2018 ODTUG Innovation Award @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=781&source=1 ODTUG is excited to announce the third annual ODTUG Innovation Award. The ODTUG Innovation Award honors excellence in creative, effective, and innovative use of Oracle development tools within ODTUG's supported communities (APEX, BI, Database, and EPM). ODTUG https://www.odtug.com/p/bl/et/blogaid=781&source=1 Wed Apr 18 2018 10:20:15 GMT-0400 (EDT) Announcing the 2018 ODTUG Innovation Award https://www.odtug.com/p/bl/et/blogaid=781&source=1 ODTUG is excited to announce the third annual ODTUG Innovation Award. The ODTUG Innovation Award honors excellence in creative, effective, and innovative use of Oracle development tools within ODTUG's supported communities (APEX, BI, Database, and EPM). ODTUG https://www.odtug.com/p/bl/et/blogaid=781&source=1 Wed Apr 18 2018 10:20:15 GMT-0400 (EDT) EPM Cloud Lab – Create a New Planning Application @_Jun_Zhang_ @orclEPMblogs http://theepmlab.com/epm-cloud-lab-create-a-new-planning-application/ Since February 2014, when PBCS came to the Market, Oracle EPM cloud solutions have been getting stronger. Till April 2018, the EPM cloud solutions are: Account Reconciliation Cloud Enterprise Data Management Cloud Enterprise Performance Reporting Cloud Enterprise Planning Cloud Financial Consolidation and Close Cloud Planning and Budgeting Cloud Profitability and Cost Management Cloud Tax Reporting... Jun http://theepmlab.com/?p=2023 Fri Apr 13 2018 20:39:15 GMT-0400 (EDT) EPM Cloud Lab – Create a New Planning Application http://theepmlab.com/epm-cloud-lab-create-a-new-planning-application/ Since February 2014, when PBCS came to the Market, Oracle EPM cloud solutions have been getting stronger. Till April 2018, the EPM cloud solutions are: Account Reconciliation Cloud Enterprise Data Management Cloud Enterprise Performance Reporting Cloud Enterprise Planning Cloud Financial Consolidation and Close Cloud Planning and Budgeting Cloud Profitability and Cost Management Cloud Tax Reporting... Jun http://theepmlab.com/?p=2023 Fri Apr 13 2018 20:39:15 GMT-0400 (EDT) ODTUG April News @odtug @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs @orclEPMblogs https://www.odtug.com/p/bl/et/blogaid=784&source=1 The ODTUG April News includes information about the 2018 WIT Scholar, ODTUG Kscope18 updates, upcoming webinars, upcoming community events, and more! ODTUG https://www.odtug.com/p/bl/et/blogaid=784&source=1 Thu Apr 12 2018 12:44:23 GMT-0400 (EDT) ODTUG April News https://www.odtug.com/p/bl/et/blogaid=784&source=1 The ODTUG April News includes information about the 2018 WIT Scholar, ODTUG Kscope18 updates, upcoming webinars, upcoming community events, and more! ODTUG https://www.odtug.com/p/bl/et/blogaid=784&source=1 Thu Apr 12 2018 12:44:23 GMT-0400 (EDT) Planning Cloud Series: Security Strategy (Part I) @opal_epm https://womaninepm.com/2018/04/11/planning-cloud-series-security-strategy-part-i/ Application security: an afterthought. A cumbersome chore. A thankless task. The stuff of nightmares. Yep, it&#8217;s all of those things, yet so critical. Especially in this day and age. (credit: Google images) But does it have to be? This is a multi-part series that focuses on Oracle Planning Cloud security. The tips provided in this &#8230; <a href="https://womaninepm.com/2018/04/11/planning-cloud-series-security-strategy-part-i/" class="more-link">Continue reading <span class="screen-reader-text">Planning Cloud Series: Security Strategy (Part&#160;I)</span></a> OpaL http://womaninepm.com/?p=12033 Wed Apr 11 2018 10:34:32 GMT-0400 (EDT) Planning Cloud Series: Security Strategy (Part I) https://womaninepm.com/2018/04/11/planning-cloud-series-security-strategy-part-i/ Application security: an afterthought. A cumbersome chore. A thankless task. The stuff of nightmares. Yep, it&#8217;s all of those things, yet so critical. Especially in this day and age. (credit: Google images) But does it have to be? This is a multi-part series that focuses on Oracle Planning Cloud security. The tips provided in this &#8230; <a href="https://womaninepm.com/2018/04/11/planning-cloud-series-security-strategy-part-i/" class="more-link">Continue reading <span class="screen-reader-text">Planning Cloud Series: Security Strategy (Part&#160;I)</span></a> OpaL http://womaninepm.com/?p=12033 Wed Apr 11 2018 10:34:32 GMT-0400 (EDT)