关于生成password.txt文件:
切换..././planning1路径下:
cd /u01/app/oracle/product/epm/user_projects/epmsystem1/Planning/planning1
执行命令生成password.txt文件:
PasswordEncryption.cmd /u01/app/oracle/product/epm/user_projects/epmsystem1/Planning/planning1/password.txt
就把生成的password.txt文件放在planning1下;
执行下边命令的时候,会提示输入密码,如果不想每次输入密码,执行以上的操作,生成一个密码文件password.txt;
然后,在执行以下命令的时候,加上 -f:password.txt 就OK!!
比如,导入维度成员的时候,执行命令变成如下:
OutlineLoad -f:password.txt /A:Planning /U:admin /-M /I:c:/account.csv /D:Account /L:c:/outlineLoad.log /X:c:/outlineLoad.exc
1.批量导出、导入维度成员
打开cmd;
切换路径:
cd /u01/app/oracle/product/epm/user_projects/epmsystem1/Planning/planning1
执行命令:
windows2008:
导出:
OutlineLoad /A:Planning /U:admin /-M /E:c:/Accountguanli.csv /D:Account /L:c:/outlineLoad.log /X:c:/outlineLoad.exc
导入:
OutlineLoad /A:Planning /U:admin /-M /I:c:/account.csv /D:Account /L:c:/outlineLoad.log /X:c:/outlineLoad.exc
linux:
导出:
sh OutlineLoad.sh /A:Planning /U:admin /-M /E:/u01/app/oracle/product/epm/user_projects/epmsystem1/Planning/planning1/ent_export.csv /D:Account
导入:
sh OutlineLoad.sh /A:Planning /U:admin /-M /I:/u01/app/oracle/product/epm/user_projects/epmsystem1/Planning/planning1/ent_export.csv /D:Account
2.批量导出、导入权限
打开cmd;
切换路径:
cd D:\Oracle\Middleware\user_projects\epmsystem1\Planning\planning1
在路径下放处理好的txt文件(导出过程会导出一个txt文件,就是那个,文件名不能改)
执行命令:
导出:
ExportSecurity /A=Planning /U=admin
导入:
ImportSecurity.cmd "Planning,admin,,,"
权限对应的后台表:
登录应用的用户
epm_usr_pln/epm_usr_pln;
权限对应的表 hsp_access_control
查询代码:
代码1:
SELECT t1.*,t2.object_name
FROM
hsp_access_control t1,hsp_object t2
WHERE t1.object_id=t2.object_id;
代码2:
SELECT t2.object_name user_name,
t1.object_name,
decode(t1.access_mode,
-1,'无权限',
1,'读权限',
3,'写入权限'),
decode(t1.flags,
0,'member',
5,'children',
6,'ichildren',
8,'descendants',
9,'idescendants')
FROM
(SELECT t1.*,t2.object_name
FROM
hsp_access_control t1,hsp_object t2
WHERE t1.object_id=t2.object_id) t1
,hsp_object t2
WHERE t1.user_id=t2.object_id ;
可以修改hsp_access_control表来调整权限;
3.批量导出、导入任务列表