This discussion is archived
1 Reply Latest reply: Aug 3, 2013 11:59 AM by 1012870 RSS

FDM WHILE EXPORTING DATA MEMBER NOT FOUND

1012870 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points