You can make an export of this table from the ABM model or you can export entire model, all of it's data - it's preferable, than change the table (e.g. Assignment) and, finaly, import all changed data into the ABM.
... View more
I am having my DI job not completing when trying to load Excel worksheets into MS SQL servert tables. The spawned pcfiles server process memory footprint stop growing when the job hangs. Also, - I am using Windows server 2008, SAS 9.2 and PCFILES 9.2 - The job hangs at a different point when I run the same job but using pcfiles as a server instead of a service Appreciate any insight/ help here guys. Thanks.
... View more
If tables A and C are imported correctly then you don't need to import it again. Add the missing dimensions in dimensions table and then try to import table C.
... View more
I managed to create the cube using the NONUPDATEABLE flag which means my dimensions are non-updateable. The cube is created monthly though.
... View more