1 Reply Latest reply: Aug 3, 2013 1:59 PM by 1012870 RSS

    FDM WHILE EXPORTING DATA MEMBER NOT FOUND

    1012870

      Hi

       

      When  i am exporting data from FDM to essbase i am getting error when i clicked Export

      I have these dimension in essbase ,

      1.Account

      2.entity

      3.businessunit- dim1

      4.currency- dim2

      5.project-dim3

      6.costcenter-dim4

      7.version-dim5

      8.buytype - dim6

      9.year- dim 7

      10.period- dim8

      11.HSRates- dim9

      12.Scenario

       

      These are my TB format members

      Revenue, 430_ABC, 4010HOTEL, Curency, Project-holiday, 3010-marketing. Version1, 10-cutting, FY13 , JAN, HSP-INPUTVALUES, Actual,  10000

       

      In the above TB all members are loaded in FDM  except Actual (i guess this is why i am getting error )

       

      i had created import format like this

      Filed Name                             FiledNumber                                      Number of Fields                         

      1. SorceEBAccount                       1                                                         13

      2 .Source EBEntity                       2                                                         13

      3. Source custom 1                        3                                                         13                                           

      4. Source custom 2                        4                                                          13

      5 .source custom 3                        5                                                           13

      6. Source custom 4                        6                                                          13  

      7. Source custom 5                       7                                                            13                                    

      8. Source custom 6                        8                                                           13                                       

      9. Source custom 7                        9                                                           13

      10. source custom 8                      10                                                          13

      11. source custom 9                       11                                                         13

      12. (we dont have scenario)             12                                                         13

      13.Amount                                     13                                                          13

       

       

      when i imported TB in to FDM i am not able to find Scenario Dimension Member

      when i clicked  export in FDM  i am getting Member not found in Database

       

      Please help me in this issue

       

      Thanks