I am trying to copy the metadata of the cube to a different environment and build a cube, while I am running the Proc OLAP code it is giving me an error message
ERROR: The registration for column "CUSTOMER_ID" is not found on the metadata server
But the metadata for the column CUSTOMER_ID appears in the table, I am not able to figure out what can be wrong, I have included the validvarname= any option in the config file, as I found that in the sas documentation but did not had any luck.
Either customer_id is not in the metadata or it isnt in the actual table the metadata references. It also could be a mismatch on the other properties for customer_id (such as format or length). I would suggest comparing the source table and the metadata to ensure everything matches.
I have thoroughly checked the metadata and I could find the customer_id column in metadata and the actual table, Both the environments has the same data source and just now able to rebuild the same cube in the environment where I copied the metadata from.
Here are the notes from SAS TS when this same issue has happened to others:
If the column is on the input table but not in the metadata, the first thing to try is to import the new column into the existing metadata registration for the table. To do this, follow the steps below within SAS Management Console:
1. Under Environment Management, navigate to the table via the path:
Data Library Manager-> SAS Libraries->
2. In the right-hand pane you should see your table listed within the library listing. Right-click on the table and select "Properties".
3. Go to the "Columns" tab. Click on the "Import..." button at the lower right.
4. In the "Import Columns" window, you should be able to move the currently unregistered columns to the "Selected Columns" pane and OK out to save.
If this does not work for you, or the column is already shown in the metadata for the table within the "Columns" tab, you will need to unregister the table and import it back in. This could impact some references to this table, but that cannot be avoided. Therefore, if you can update the metadata by just importing the individual column, that is the recommended method to follow.