FDX Cube View Connector Rule Error - Non-Numeric Value
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 ...
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"
