【Oracle HFM】创建FDMEE底表映射视图，方便存储过程处理映射

最新推荐文章于 2024-08-27 10:46:32 发布

原创最新推荐文章于 2024-08-27 10:46:32 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

Oracle数据库专栏收录该内容

5 篇文章

订阅专栏

本文详细介绍了如何在Oracle Hyperion Financial Management (HFM) 中创建FDMEE的底表映射视图，包括实体映射、科目映射和客户化维度视图的创建步骤。此外，还探讨了如何将这些视图与存储过程结合，以优化数据处理和映射操作。

1.实体映射视图

create or replace view fdmee_entity_mapping as
select tpov.partname      Location_name,
       t.srckey           source_entity_code,
       t.targkey          target_entity_code,
       t.whereclausetype  map_type,
       t.whereclausevalue map_value
  from epmfdmee.tdatamap t, epmfdmee.tpovpartition tpov
 where t.dimname = 'ENTITY'
   and t.partitionkey = tpov.partitionkey;

2.科目映射视图

create or replace view fdmee_account_mapping as
select tpov.partname      Location_name,
       t.srckey           source_account_code,
       t.targkey          target_account_code,
       t.whereclausetype  map_type,
       t.whereclausevalue map_value
  from epmfdmee.tdatamap   t, epmfdmee.tpovpartition   tpov
 where t.dimname = 'ACCOUNT'
   and t.partitionkey = tpov.partitionkey;

3.客户化维度视图，C1为例

create or replace view fdmee_cust1_mapping as
select tpov.partname      Location_name,
       t.srckey           source_cust1_code,
       t.targkey          target_cust1_code,
       t.whereclausetype  map_type,
       t.whereclausevalue map_value,
       t.dimname
  from epmfdmee.tdatamap   t, epmfdmee.tpovpartition   tpov
 where t.dimname = 'UD1'
   and t.partitionkey = tpov.partitionkey;

4.ICP维度视图

create or replace view fdmee_icp_mapping as
select tpov.partname      Location_name,
       t.srckey           source_icp_code,
       t.targkey          target_icp_code,
       t.whereclausetype  map_type,
       t.whereclausevalue map_value
  from epmfdmee.tdatamap   t, epmfdmee.tpovpartition   tpov
 where t.dimname = 'ICP'
   and t.partitionkey = tpov.partitionkey;