Applies to Release versions 11.8.1.5 and below.

Apptio has the ability to convert your raw uploaded datasets to an editable table. Using this feature is for very specific needs and usually entails working with an expert to create metric or allocation. It is recommended to refrain from uploading your datasets as editable tables unless it is being done for a specific reason. If this has been done by accident, over time, it has the potential to affect the application’s performance.

Here is how to ensure that you are not loading your datasets as editable tables:

If you suspect that you may have accidentally checked the “Make Data Set Editable” box, you can verify this by Exporting the raw table (not the Transform) and examining the TSV or Excel table. If you see a column titled “.PK”, you raw dataset is currently an editable table. You can Undo this upload in the Audit logs.

NOTE: If your project is time enabled, you will need to examine the previous months to ensure that the “.PK” does not exist in them as well. If it does, you will need to find the first upload that used the “Make Data Set Editable” feature because the application will carry this change forward in every upload after it. You will need to “Undo” this first Audit Log entry, and every one of its entries afterward, up to the latest one. If you do not have the original data that was uploaded for each month, you will need to Export each month of the dataset, manually remove the “.PK” column, and then re-upload the corrected dataset for each month. One of the ways you can find the first upload that initiated the change, is by searching your Audit log entries in the Description section for the name of the dataset and entering “MakeRawTableEditable” in the Operation column (the “MakeRawTableEditable” Audit Log entry may not always exist for the editable tables in some situations).