tag:blogger.com,1999:blog-2615703102299902978.comments2024-02-03T00:03:10.178-08:00Glenn Schwartzberg's Essbase BlogGlennShttp://www.blogger.com/profile/08532634180859769798noreply@blogger.comBlogger318125tag:blogger.com,1999:blog-2615703102299902978.post-39216462004426199242018-02-02T11:44:13.816-08:002018-02-02T11:44:13.816-08:00I've not see issues with dense dimensions, but...I've not see issues with dense dimensions, but it could be a problem with sparse members as the block would not exist. There is on-prem a setting to ignore dynamically calculated members (basically not expanding the block). I don't know if the setting is applicable or available in OACGlennShttps://www.blogger.com/profile/12820725959526528201noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-16638509479519803362018-02-02T10:58:13.906-08:002018-02-02T10:58:13.906-08:00Hey Glenn,
Have you seen any issues in Hybrid mode...Hey Glenn,<br />Have you seen any issues in Hybrid mode with if statements on dynamic dense members? Seeing some troubles in a POC I'm conducting. The block is not created when we "if" on a member of this type. The "if" seems to be ignored. And some other strange issue too related to block creation. No issue with the same on 11.1.2.4.. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-25230222382446988222017-09-14T10:02:21.271-07:002017-09-14T10:02:21.271-07:00Glenn,
Could you also blog about Automating Data ...Glenn,<br /><br />Could you also blog about Automating Data Load process for OAC Essbase?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-52681401472092600862017-08-01T09:06:14.525-07:002017-08-01T09:06:14.525-07:00If you load to YTD_input, FCCS runs a calculation ...If you load to YTD_input, FCCS runs a calculation to push it to Periodic by taking the difference between last period and this period. Starting in the 17.07 release you can also load balances , but the calc to convert it to periodic will not be available till the 17.08 release. (a couple of weeks away)GlennShttps://www.blogger.com/profile/12820725959526528201noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-11889925932437463332017-08-01T07:39:37.494-07:002017-08-01T07:39:37.494-07:00Hi, I was looking to the YTD vs Periodic load on F...Hi, I was looking to the YTD vs Periodic load on FCCS and came across your blog.<br /><br />Although there is a statement that DM can load both YTD and Periodic the manual is not very clear about this <br /><br />"In Oracle Financial Consolidation and Close Cloud for YTD data loads, data is stored in Periodic view. In this case, the user must select this option so that a “pre-processing” is done to convert the YTD data from the file to periodic data for loading purpose"<br /><br />I haven't been able to find this "option" mentioned on the manual, do you if there is a setting on DM to do this, all the solutions I've seen required mapping a different field for the View<br /><br />Thanks in advancedBernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-70465219574160703822017-06-30T07:17:10.458-07:002017-06-30T07:17:10.458-07:00Hi Glenn, I remember that someone pointed toward t...Hi Glenn, I remember that someone pointed toward that chapter not so long ago. The good thing is that you may access it from public EPM documentation index portal.<br /><br />Really useful stuff here.<br /><br />Here's the link for version 11.1.2.5.700:<br />http://docs.oracle.com/applications/smartview/700/SVICG/tips_and_troubleshooting.htm<br /><br />Here's the generic path:<br />Oracle Smart View for Office Documentation Release XX.X.X.X.XXX \ Smart View for Office Installation and Configuration Guide \ Tips and TroubleshootingAnonymoushttps://www.blogger.com/profile/16574971951163598058noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-18300945594951458982017-03-18T03:57:34.695-07:002017-03-18T03:57:34.695-07:00While we have talked for years about how you can d...While we have talked for years about how you can do “what Iffing” in Essbase, you can truly now do it as it is built into the product.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-9743206442427648032017-03-18T03:50:37.094-07:002017-03-18T03:50:37.094-07:00My Favorite: Only time and Oracle will tell...My Favorite: Only time and Oracle will tell...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-7311805470157838602017-03-08T10:02:04.973-08:002017-03-08T10:02:04.973-08:00I didn't know the answer to your question so I...I didn't know the answer to your question so I reached out to Maggie Reed from the FCCS management team. Her response is <br /> "Currently, you can load YTD or Periodic data. YTD means YTD income or YTD changes in balance sheet data. Coming in the next few months you will also be able to load Life to Date balances for balance sheet data. However, loading of LTD balance sheet balances will be limited to two purposes. 1) validating that all movement data has been entered (loaded closing balance ties to calculated closing balance) and as a source for calculating specific movement members when configurable calculations comes out."<br /><br /> From what I get from this is loading to YTD_input will still be supported but additional capabilities will be introduced to load LTD values but just for validation purposes.<br /><br />If they removed the YTD_input, almost anyone who has already implemented would have to change the data management and that would be messy. GlennShttps://www.blogger.com/profile/12820725959526528201noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-29141839822313801262017-03-08T08:30:41.290-08:002017-03-08T08:30:41.290-08:00Hi Glenn. We are currently going through a proof ...Hi Glenn. We are currently going through a proof of concept and there seems to be some confusion over data load using Data Management. Currently, we are testing YTD data loads, including balance sheet. YTD load is working. We are now being told that this will not be possible in the near future, that only periodic data can be loaded. It has something to do with the way movement works. In addition, mention of life to date vs. YTD balances in balance sheet account has been brought up. LTD balances will be loaded into movement opening balances and only periodic movement can be loaded. Can you please provide any additional thoughts you might have and if you have heard the same, please let me know?<br /><br />Thanks so much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-78750212837856583042017-03-06T04:07:38.594-08:002017-03-06T04:07:38.594-08:00Indeed. :)
Very related to this is the "j...Indeed. :) <br /><br />Very related to this is the "just keep it simple" 4 words of destruction. Some quick fix with blinders on seems always to be preferred to the picky guy's "complex" solution. Then... year end activities or some far away process in the future and.. kaboom.<br /><br />While commenting on expressions, let's add some true ones:<br />"The devil is in the details!" <br />"If there is always time to fix it, how come there is never enough time to do it right in the first place?"Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-79793593851524984742017-03-01T17:27:45.398-08:002017-03-01T17:27:45.398-08:00FR Web is included with FCCS so you can create you...FR Web is included with FCCS so you can create your own reports. Currently , you can still use Reporting Studio to create reports as well, but that will be going away quicklyGlennShttps://www.blogger.com/profile/12820725959526528201noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-41608645981207937242017-03-01T15:51:34.437-08:002017-03-01T15:51:34.437-08:00Great article Glenn and so are the other articles ...Great article Glenn and so are the other articles you have written on FCCS. Wanted to ask how much flexibility is provided to develop FR reports in FCCS or all we have the pre built financial reports to use for management and external reportingashwinnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-44724632108383877842016-11-28T11:18:37.737-08:002016-11-28T11:18:37.737-08:00I don't think I would wait for 12c. While it w...I don't think I would wait for 12c. While it will have full hybrid support, if you have an existing application, you can take advantage of new features and functionality now. I would expect 12c ill be released first as Essbase Cloud Service and it will be some time before it makes it on-premise GlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-23908294565163791772016-11-28T10:44:37.217-08:002016-11-28T10:44:37.217-08:00We run an Essbase-Only implementation with in-hous...We run an Essbase-Only implementation with in-house planning and reporting tools all built off Java/C API. We have very complex security and have been told that any cloud solution would not make sense for us. So...<br /><br /><br />If we want to build a new server to migrate to in a few months, would you recommend just installing 11.1.2.4 and get the latest patch or waiting to see if a stand alone 12c ever gets released?SickSkilzhttps://www.blogger.com/profile/05548564193204303895noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-40420522925369930322016-11-21T09:29:56.256-08:002016-11-21T09:29:56.256-08:00A Year later. Still not REALLY hereA Year later. Still not REALLY hereSickSkilzhttps://www.blogger.com/profile/05548564193204303895noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-27260206080196272562016-09-02T13:38:14.225-07:002016-09-02T13:38:14.225-07:00I think it will be a long time for FCCS to replace...I think it will be a long time for FCCS to replace HFM Currently they have different audiences with different needs. GlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-72678138788513420682016-09-02T12:31:24.954-07:002016-09-02T12:31:24.954-07:00Great research Glenn. Thank you!!
You think FCCS h...Great research Glenn. Thank you!!<br />You think FCCS has potential to replace HFM one day??Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-73828126881059105122016-07-08T05:05:26.365-07:002016-07-08T05:05:26.365-07:00Dinesh,
Send me an email to gschwartzberg@interre...Dinesh, <br />Send me an email to gschwartzberg@interrel.com and I'll get you a copyGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-57066335657651195282016-07-07T23:18:23.847-07:002016-07-07T23:18:23.847-07:00Appreciate this is a fairly old post. Is the RUNSQ...Appreciate this is a fairly old post. Is the RUNSQL CDF still available? Where can I get it - it is no longer accessible via the filedropper link.<br /><br />Thanks,<br />DineshAnonymoushttps://www.blogger.com/profile/04126579229103808008noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-53619688334998859592016-06-17T00:21:53.597-07:002016-06-17T00:21:53.597-07:00+1+1G.R.noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-14370209612295599792016-05-04T06:17:05.292-07:002016-05-04T06:17:05.292-07:00Yes, it will be in part of an in clause. and while...Yes, it will be in part of an in clause. and while in older versions the sql would fail if you had over a certain number of members, the Studio team now will break up yourquery and make multiple in clauses to prevent failuresGlennShttps://www.blogger.com/profile/08532634180859769798noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-2462127649496821802016-05-04T05:24:31.668-07:002016-05-04T05:24:31.668-07:00Hello,
In this post you said that for a recursive...Hello,<br /><br />In this post you said that for a recursive hierarchy: <br />< If you are at an upper level and have turned allowed drill trough from that level, you get a list of the level zero members under the member you selected. ><br />So for my Product dimension ( recursive hierarchy), if i select Generation2 in the Define Intersections Tab,and then in my drill-through report, if I select an upper level member, the parameter passed for the product dimension, to the Essbase Studio query,will be in fact a list of all Level 0 members under the selected one?Lunoreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-23581318388387413242016-05-03T03:52:07.781-07:002016-05-03T03:52:07.781-07:00Gotta love SRs going to development. If nothing el...Gotta love SRs going to development. If nothing else i am happy you have enlightened that 'development' is not code for rubbish bin. <br /><br />I avoid using floats but obviously you get what you're given on a job. Can see this biting many people who wont be so lucky to spot the issue.<br /><br />I still dont really get why you get a different value now though. Is it because SQL Server approximates a float differently to Essbase? I'm on my phone so havent dug into the msdn links in the articleDaniel Willishttps://www.blogger.com/profile/07491703670331386170noreply@blogger.comtag:blogger.com,1999:blog-2615703102299902978.post-85789552976694115642016-04-20T07:50:10.676-07:002016-04-20T07:50:10.676-07:00It gets worse. When HFMEA pushes HFM data to the ...It gets worse. When HFMEA pushes HFM data to the fact table, it uses FLOAT for the data type in that table, not a decimal. So when you load values into Essbase through the SQL Interface, they can get mangled. Anonymoushttps://www.blogger.com/profile/12759231936349695787noreply@blogger.com