- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
FDM Invalid Intersection error?
I have below issue:
Data load failing for a cross section with FDM error " Invalid Intersection".
POV for the Intersection:
Year:2015, Period: Nov,View: Periodic
FM Enitity:2143, FM Account: 23450000 ICP: [ICP NONE], Custom1:[NONE],Custom2:[NONE],Custom3:[NONE],Custom4:FT, Data Value:<Entity Curreny>, Amount:376.56
the Validation report also gives list of valid ICP/Custom members in seperate table.
Both the Given Account and Entity members has ISICP attribute set as "Y" so i think the ICP NONE member for ICP dimension in invalid member for this cross section.
So i checked the Import format and ICP mapping rule for givrn Entity and account.
I found below ICP mapping rule in "Like" map Type:
Rule Name Rule Desc. Rule Definition Target ICP Script
O_Set *0000 [ICP None]
So what i conclude that due to this rule, the target ICP member is coming as [ICP None] for the specific account:23450000 from rule itself.
So Please help me in confirming if i am thinking in right direction and what possible steps i can take to fix this or something i am missing so please correct me.