Re: Excel addin error - Cannot have 0 columns
Hi Alex, I've read your blog post and try to follow your instructions. However I still face this issue when trying to publish ForecastSales table. I'm uploading Demand Forecast.
At first, excel add-in raise 2 errors that is surrogate key are needed for ForecastSales table and PurchLine table. To resolve this, I've added surrogate key for ForecastSales table with ExpandID and RecID while for PurchLine I've added InventTransID and RecID for PurchLine.
After add those 2 surrogate keys, I add a field "DummyField" in DimensionAttributeValueSet and create a surrogate key for this table. I use DummyField and RecID as my replacement key.
Then, I managed to retrieve data from AX but when I try to publish, it still raises an error cannot have 0 columns. Any idea how to solve this? Many thanks Alex.
Jefry