This content has been marked as final.
Show 8 replies
-
1. Re: Planning Locale: en_US ,unable to load dimension.
JohnGoodwin Feb 7, 2013 8:31 AM (in response to 988310)Can you post the actual command line you used.
Cheers
John
http://john-goodwin.blogspot.com/ -
2. Re: Planning Locale: en_US ,unable to load dimension.
988310 Feb 7, 2013 8:58 AM (in response to JohnGoodwin)"C:\>cd c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1
c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>
c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
Outsourc /U:admin /I:c:\accounts.csv /D:Account/L:c:/outlineLoad.log /X:c:/outli
neLoad.exe "
press enter then system says
Enter Password.
I entered password and get mentioned above error. -
3. Re: Planning Locale: en_US ,unable to load dimension.
JohnGoodwin Feb 7, 2013 9:20 AM (in response to 988310)If that has been pasted correctly the first thing I see is that it needs a space between - /D:Account/L:c:/outlineLoad.log and probably not the best to use .exe as the exception log
e.g. OutlineLoad /A:Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outlineLoad.exc
Cheers
John
http://john-goodwin.blogspot.com/ -
4. Re: Planning Locale: en_US ,unable to load dimension.
988310 Feb 7, 2013 10:22 AM (in response to JohnGoodwin)c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outl
ineLoad.exc
Enter password:
Planning locale: en_US
using java.library.path: C:\Oracle\Middleware\EPMSystem11R1/products/Planning/li
b64
EPM_ORACLE_HOME (C:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "E
PM_ORACLE_HOME".
using Java property for Hyperion Home C:\Oracle\Middleware\EPMSystem11R1
For non-DP app, Request dimension not needed
EPM_ORACLE_INSTANCE (C:\Oracle\Middleware\user_projects\epmsystem1) is set from
*JVM property[EPM_ORACLE_INSTANCE].*
Loaded Version of Essbase RTC: 0xb1221
*[Thu Feb 07 15:17:11 PKT 2013]Unable to obtain dimension information and/or perf*
orm a data load: Unrecognized column header value(s), refer to previous messages
*. (Note: column header values are case sensitive.)*
Now it is...
Following first line is my flat file header.And second line is first record of the file.
Account Parent Data Storage Description Data Type Account Type Aggregation(PPlan1)
Income Statement Account Dynamic Calc P and L Statement Currency Revenue ~ -
5. Re: Planning Locale: en_US ,unable to load dimension.
JohnGoodwin Feb 7, 2013 11:30 AM (in response to 988310)You may need a space at Aggregation (PPlan1)
Account,Parent,Data Storage,Description,Data Type,Account Type,Aggregation (PPlan1)
Cheers
John
http://john-goodwin.blogspot.com/ -
6. Re: Planning Locale: en_US ,unable to load dimension.
988310 Feb 8, 2013 5:31 AM (in response to JohnGoodwin)Thank you So much Sir :) It helped me ,some accounts details are loaded,but some are not.Kindly again identify issue.The meta data file i have created with the help of *"Getting Started with Oracle Hyperion Planning "* PDF book.
c:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1>OutlineLoad /A:
Outsourc /U:admin /I:c:\accounts.csv /D:Account /L:c:/outlineLoad.log /X:c:/outl
ineLoad.exc
Enter password:
Planning locale: en_US
using java.library.path: C:\Oracle\Middleware\EPMSystem11R1/products/Planning/li
b64
EPM_ORACLE_HOME (C:\Oracle\Middleware\EPMSystem11R1) is set from JVM property "E
PM_ORACLE_HOME".
using Java property for Hyperion Home C:\Oracle\Middleware\EPMSystem11R1
For non-DP app, Request dimension not needed
EPM_ORACLE_INSTANCE (C:\Oracle\Middleware\user_projects\epmsystem1) is set from
JVM property[EPM_ORACLE_INSTANCE].
Loaded Version of Essbase RTC: 0xb1221
Reaquired task list lease: Fri Feb 08 10:21:37 PKT 2013: 1360300897243
[Outsourc] Valid userId: 50001 found in session: [1862242825, admin, native://DN
=cn=911,ou=People,dc=css,dc=hyperion,dc=com?USER
com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
does not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Net Income From Operati
ons does not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Gross Profit does not e
xist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Gross Profit does not e
xist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Net Income From Operati
ons does not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member SG&A does not exist or
you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
does not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Net Income before taxes
does not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
java.lang.IllegalArgumentException: Invalid value for field Account Type: Liabil
ities.
at com.hyperion.planning.db.HspHALDBImpl.saveMember(HspHALDBImpl.java:36
9)
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:9041)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Liabilities does not ex
ist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Liabilities does not ex
ist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.HspRuntimeException: Exchange Rate must be None if Data Ty
pe is Non-Currency, Percentage, Smart List, Date, or Text. Member: Statistical
Drivers
at com.hyperion.planning.db.HspDEDBImpl.validateAndSetAccountMemberInfor
mation(HspDEDBImpl.java:6659)
at com.hyperion.planning.db.HspDEDBImpl.saveMember(HspDEDBImpl.java:2871
)
at com.hyperion.planning.db.HspDEDBImpl.saveMember(HspDEDBImpl.java:2651
)
at com.hyperion.planning.db.HspHALDBImpl.saveMember(HspHALDBImpl.java:57
1)
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:9041)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Statistical Drivers doe
s not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292)
com.hyperion.planning.InvalidMemberException: The member Statistical Drivers doe
s not exist or you do not have access to it.
at com.hyperion.planning.HyperionPlanningBean.saveMember(HyperionPlannin
gBean.java:8977)
at com.hyperion.planning.utils.HspOutlineLoad.saveDataRecord(HspOutlineL
oad.java:801)
at com.hyperion.planning.utils.HspOutlineLoad.parseAndLoadInputFile(HspO
utlineLoad.java:542)
at com.hyperion.planning.utils.HspOutlineLoad.halAdapterInfoAndLoad(HspO
utlineLoad.java:112)
at com.hyperion.planning.utils.HspOutlineLoad.loadAndPrintStatus(HspOutl
ineLoad.java:1303)
at com.hyperion.planning.utils.HspOutlineLoad.main(HspOutlineLoad.java:1
292) -
7. Re: Planning Locale: en_US ,unable to load dimension.
988310 Feb 8, 2013 5:40 AM (in response to 988310)Net Income before taxes ,Liabilities and statistical drivers etc
are present and syntactically are same in .CSV (comma delimited) file. -
8. Re: Planning Locale: en_US ,unable to load dimension.
JohnGoodwin Feb 8, 2013 8:15 AM (in response to 988310)985307 wrote:
Is "Net Income before taxes" present as parent in the file or a child, it could be that the file is referencing the member as a parent but it has not been created as a member so it can't find it.
Net Income before taxes ,Liabilities and statistical drivers etc
are present and syntactically are same in .CSV (comma delimited) file.
Cheers
John
http://john-goodwin.blogspot.com/