I have only 2 dimensions in my SQL Table name dbo.ABC (Example: 1.Entity 2.Account and amount(data value)
USA, SALES, 50000
(Including value its total 3 dimensions)
How to export this data to Target HFM Application.
Integration Script got success when i click on validation it is shows only 2 dimension 1.Account 2.Entity. i have mapped correctly. but validation screen not showing anything. i got gold fish for validation button and Export is also showing success and got goldfish. but no data is exported to HFM application.
in FDM outbox its created a file which is containing only *!data* text. There is no record in this file.
I want to load the data with rest of the dimensions with [None] member combination as i don't have the additional dimensions in my source file.
Minimum how many dimension required to export the data from FDM to HFM?
If i assign any values(3-9) to next dimensions or if I left blank rs.fields("txtAcctDes") with its showing below error messages:
Error: An error occurred importing the file.
Detail: Item cannot be found in the collection corresponding to the requested name or ordinal.
At line: (39 and 42-46)
So i have assigned Source-FDM-Account Number<font color="Blue">(rs.fields(1) </font>Value to rest of the dimensions in my integration script.
<font color="Blue">rsAppend.Fields("Account") = rs.fields(1).Value</font>
Now am able to import the data into import screen, And i found all the above member names as Sales as i assigned Account dimension number(1) to these members temporarily to succeed the import process . Then i have mapped to Target dimensions with [None] member combination as these members are not in original source file. Then rest of the process Export and Check is done perfectly.
*<font color="red">1.Am i right?? Please suggest me the correct process?</font>*
*<font color="red">2.Can we use blank values in Integration Script as mentioned below??</font>*
You can assign blank values in your integration script e.g. rsAppend.Fields("Desc1") = "" will assign an empty string to the description. Personally I wouldn't assign an empty string to any of the active mappable dimensions as you would only be able to catch these with a wildcard map and they wouldn't be that informative. If you know they are goiung to be None then pass the string None to them and map that value e.g.
rsAppend.Fields("ICP") = "ICP None"
rsAppend.Fields("UD1") = "None"
The reason your script has been failing is because the recodset you are using to assign the values from only has 3 fields. Therfore if you refence an oridinal in the range 3-9 it won't exsit
i.e. rsAppend.Fields("ICP") = rs.fields(3).Value will generate the error message you get, as will rsAppend.Fields("Desc1") = rs.fields("txtAcctDes").Value because there is no field in the recordset named txtAcctDes