11-02-2023 05:44 PM
Hi All,
I am trying to extract data from cube view using FdxExecuteCubeView function and load the result back to cube through a connector. However, when I execute the workflow dataload, a "No valid DataKeys (Scenario / Time)" error occurred. I checked the log, it pointed out to be "Non-Numeric Amount ..................... 4" error
On the log, I am able to see the data I extracted as this :
4: Cube1, 568123, , Local, Budget, 2023, Periodic, 702151, None, BeforeAdj, None, 500100, None, None, None, None, None, None, None, 959.799999996
It seems that the data was pulled right, but just the amount cannot be recognized as numeric data
On Data Source, I did map "Amount" to the "Amount" column. I am not sure why 959.799999996 is not considered as an amount? Here is the mapping.
Here is the Rule itself.
Finally, Here is the Workflow Text 4.
CubeViewName=[TestFDX],EntityDimName=[Entity_Test],EntityMF=[E#568123],ScenarioDimName=[Scenario_Main],ScenarioMF=[S#Budget],TimeMF=[T#2023],Params=[],Filter=[Unknown]
I don't think the rule or the call of the FDX is the issue as I am able to see data in my log. However, I am not sure how to resolve the non-numeric amount issue. Is it because the data saved on data table are all considered as Strings, even for amount?
Thank you!
Solved! Go to Solution.
11-03-2023 09:45 AM
Problem Solved.
When FdxExecuteCubeView is run, the return data table has a special column name "V2023" rather than "Amount", which makes connector confused where the amount column is. After manually assign the column name back to Amount, issue resolved.
dt.Columns(19).ColumnName = "Amount"
Note: index 19 is amount column. This is to change the column name to "Amount"
11-03-2023 09:45 AM
Problem Solved.
When FdxExecuteCubeView is run, the return data table has a special column name "V2023" rather than "Amount", which makes connector confused where the amount column is. After manually assign the column name back to Amount, issue resolved.
dt.Columns(19).ColumnName = "Amount"
Note: index 19 is amount column. This is to change the column name to "Amount"