USER1211

Yes, Thank you for pointing it out, I am trying to load data in Workforce cube. Now that I have created a new Data Load Rule with Target Plan Type as Workforce Planning, I am getting a new error: Data rows with unmapped dimensions exist for Period "Aug-17"

I looked into Data Load Workbench and Fix Maps are suggested an Explicit mapping for the dimension members in Source Data file. (Please be informed that this being a data file I have already mapped dimensions in Data Load Mapping with Star to Star in Like Mappings shouldn't that work?)

Secondly, for a specific combination, I explicitly mapped those dimension and re-run the data load process but encountered below error:

  USER1211   Robert Gideon

Below are the screenshots of Dummy Source Data File:

Screenshot of import format:

USER1211 yes, the File Type is set as Multi Column - All Data Type, as my source data file have Date values, Numeric values, and Smart list entries. I am trying to load the values of member properties here and account members like Date of Hire, Date of Birth are my data columns.

JohnGoodwin

Hi John,

Thank you for the link, it was indeed insightful. Yes I am trying to load text as well as Date Value, Numeric and SmartList entries the data refers to the employee properties actual values in out of box workforce cube in EPBCS. Referring to your post I have few question for the current process. Below is the screenshot of the dummy data file I am trying to load in the application:

Below is the Import format for the above file:

a) My source data file have a combination of multiple Employee, LOB and Entity dimension members hence I have provided their column number and was not able to hardcode them. Is the above import format correct?

b) Alike you mentioned on the blog I have used Star to Star Like Mappings in the Data Load Mappings, however, the data load process errors out with the error of unmapped dimensions. Also while clicking to the option for Fix Map, it's suggesting me to have an Explicit mapping for all the combinations in the source file. Shouldn't star to star mapping be sufficed for a file-based source.

c) Secondly, I took a specific combination out of the file and Explicitly mapped it and re-ran the data load rule. Now I am facing below error

USER1211 I was never able to load any data successfully into the system.using a File-based source be it a single column numeric data or multi-column all data type, due to both of the above issues. The 'Fix Maps' in Data Load Workbench suggests me to have an explicit mapping for the combiantioans in the source file. Once the combinations are explicitly mapped, I encounter the error "The member [NONE] does not exit for the specificed cube or you do not have access to it" (Screenshot attached above)

USER1211 & JohnGoodwin Thank you, experts, I got past of the error "Member [NONE] does not exist for a specific cube. As guided, the error was with the data load mappings, I simultaneously had explicit and like mappings for few of the dimensions and that was contradicting with each other. In order to resolve this issue, I re-created the entire FDMEE setup and it is working fine now.

However, I had one more query: can we load Date Values using FDMEE? (I have few of the members such as Date of Hire, Date of Birth, Date of Termination etc in Workforce planning whom we are trying to load date values in the application using FDMEE) As mentioned in John's blog More to life...: Loading non-numeric data to planning using FDMEE is this update scheduled for December 17 or we can use that feature currently?

I did try following up the setup provided in the blog and the data load rule runs successfully, I can even verify the date values in the source and target data columns in the workbench window. However, when I try pulling an AdHoc to verify those date values in the application they are #Missing for the same combinations.

JohnGoodwin Hi John, Thank you for the confirmation. Well in my case in order to load date values in the application using FDMEE, I have replicated the setup referring to your blog and as mentioned the data load rule is getting executed successfully I can also verify the 'date values' in the workbench. However, when I try pulling up an AdHoc using the same combination the values in the application they are #Missing

below is the screenshot for AdHoc pulled from the application with the same combination:

Also, I have the set the date format as DD-MM-YYYY in the Data Load rule settings and Target application settings. Secondly, similar is the case with SmartList entries we have data pertaining to employee position that we are trying to load using FDMEE. I tried loading employee position using the smartlist entries that we have in Employee Position SmartList however, alike the date values the SL Entries are visible to me in the workbench window but when I pull an AdHoc for the same they are #missing.

Can you please guide me how to resolve this issue.

Thank you so much for your help.