Fix: Cannot query internal structures for column because they are not processed

Cannot query internal structures for column T1[C1] because they are not processed. Please refresh or recalculate the table T1

image4

Cannot query internal structures for column because they are not processed. Please refresh or recalculate the table
SSAS processes tables in different options, most important ones are:

Process Full Processes a table object and all the objects that it contains. When Process Full is run for an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object. This option requires the most resources.
Process Data Load data into a table without rebuilding hierarchies or relationships or recalculating calculated columns and measures.

You could get tempted to use process data and that seems to save processing time (which it does). But if you choose “Process Data” the above message may appear when drilling down by dimension attributes. Best is to select Process Full whether processing tables or the whole database.

image

Process Full for either the table or whole database

Leave a Reply

Your email address will not be published. Required fields are marked *