tag:blogger.com,1999:blog-7650953985627040991.post7244920301115718928..comments2024-02-14T05:30:55.538-05:00Comments on Cameron's Blog For Essbase Hackers: The Compleat Idiot's Guide to PBCS, No. 11, PBCS and dataCameron Lackpourhttp://www.blogger.com/profile/07701786303677521318noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7650953985627040991.post-6170283907407911122016-05-04T15:01:41.727-04:002016-05-04T15:01:41.727-04:00Ugh.
Never mind - found the problem.
The text fi...Ugh.<br /><br />Never mind - found the problem.<br /><br />The text file was encoded as UCS-2 LE BOM instead of ANSI. <br /><br />I shall now proceed to skulk away in shame.<br /><br />Thanks for your timely responses! Stevehttps://www.blogger.com/profile/12208500813221794450noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-2936144385472514972016-05-04T14:55:16.020-04:002016-05-04T14:55:16.020-04:00One more thing: I absolutely do have all of those ...One more thing: I absolutely <i>do</i> have all of those members in the app (which the above clearly shows). It ain't my first rodeo, my friend (and I mean that quite kindly)!Stevehttps://www.blogger.com/profile/12208500813221794450noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-43507692219529190652016-05-04T14:52:56.571-04:002016-05-04T14:52:56.571-04:00Hi Cameron,
After performing an export using the ...Hi Cameron,<br /><br />After performing an export using the PBCS functionality, I got this file (now with two rows of data in it), that I am able to load using the Planning data format:<br /><br /><b>Account, Actual, Point-of-View, Data Load Cube Name<br />A91003, 4.25, "KRO, Final, FY16, P5, W1, Day7, D100, S1101", Ops<br />A91003, 5.75, "KRO, Final, FY16, P6, W1, Day7, D100, S1101", Ops</b><br /><br />But it's still <i>not</i> Essbase format and yes, it's gawdugly. Although I can format the load in this way, I sure would like to use the Essbase format, but I cannot for the life of me figure out how!Stevehttps://www.blogger.com/profile/12208500813221794450noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-31528460537395643392016-05-04T12:04:18.459-04:002016-05-04T12:04:18.459-04:00Steve,
Have you tried using PBCS' data export...Steve,<br /><br />Have you tried using PBCS' data export to see if you get *exactly* the same members? <br /><br />I know the format is ugly (and I am slowly coming round on it for text and smart lists although I still think it's your-baby-is-ugly ugly.<br /><br />Here's the official error message documentation:<br />https://docs.oracle.com/cd/E17236_01/epm.1112/eis_sysadmin/frameset.htm?apas06.html<br /><br />There are a bunch of hits on google as well:<br />http://john-goodwin.blogspot.com/2009_12_01_archive.html<br />https://community.oracle.com/thread/2316035?tstart=0<br /><br />I think you really don't have one of those members in the app.<br /><br />Regards,<br /><br />Cameron LackpourCameron Lackpourhttps://www.blogger.com/profile/07701786303677521318noreply@blogger.comtag:blogger.com,1999:blog-7650953985627040991.post-73410013459278620452016-05-04T11:11:20.176-04:002016-05-04T11:11:20.176-04:00Nice post, but I can't seem to load even the s...Nice post, but I can't seem to load even the simplest data file!<br /><br />I am trying to load a Native Essbase file to PBCS and am getting an error, so I assume that my file format is junk. The (currently) single-row input file looks like this (tab-delimited):<br /> <br /><b>"KRO" "Actual" "Final" "D100" "W1" "Day7" "FY16" "S1101" "P5" "A91003" 0.00</b><br /> <br />The error I get is: <b>Member "��"" not found in Essbase database. Error code: 3303 Record: ��"</b><br /> <br />All of the members above do exist in the DB. I have also tried space- and comma-delimited formats with the same result.<br /> <br />Any thoughts as to what about the format is bad?Stevehttps://www.blogger.com/profile/12208500813221794450noreply@blogger.com