Forum Stats

  • 3,827,262 Users
  • 2,260,755 Discussions
  • 7,897,195 Comments

Discussions

interface table 11.1.2.4

finskiy
finskiy Member Posts: 60 Blue Ribbon
edited Jan 11, 2016 5:21AM in Planning and Budgeting

Hello!

Does anyone have a guide for import metadata from Oracle DB to Planning Application using interface table on 11.1.2.4 ?

I have question on this topic:

1. Can i use ONE view for load: Parent-Child hierarchy of dimension members, Alias, Description, IsPrimary, DataStorage, MemberValidForPlan1, Plan1Aggregation? as i do in 11.1.2.3.5..

i've populated my view with this columns:

     PARENT as NVARCHAR2(255),

     CHILD as NVARCHAR2(255),

     "Alias=Default" as NVARCHAR2(255),

     "Alias=English" as NVARCHAR2(255),

     DESCRIPTION as NVARCHAR2(255),

     ISPRIMARY as NUMBER(1),

     DATASTORAGE as NVARCHAR2(255),

     MEMBERVALIDFORPLAN1 as NUMBER(1),

     PLAN1AGGREGATION as NVARCHAR2(255)

if i insert name of my view in IN_DIMENSION columns: C_MEMBER_TABLE_NAME, C_HIERARCHY_TABLE_NAME, C_PROPERTY_ARRAY_TABLE_NAME, C_DIM_PROPERTY_TABLE_NAME for Generic dimesion -> i have error when i creating EPMA Import Profile using interface table:

     URI: http://.../awb/imports.mapping.createPropertyMapping.do

     Code: com.hyperion.awb.web.common.DimensionServiceException

     Description: ORA-00904: "PROPERTY": invalid identifier

     Actor: none

so i'm set NULL for C_PROPERTY_ARRAY_TABLE_NAME and C_DIM_PROPERTY_TABLE_NAME, but when i create import profile i have no auto-pick application properties on dimension mapping stage for

Child, Parent and IsPrimary columns.. for 'Child' column i've picked 'Name' property. For 'Parent' column there only 'Default parent' property (?) and for 'IsPrimary' column there is no property for pick.. it's OK ?

Best Regards,

Artem.

Tagged:
This discussion has been closed.