Share via

Error- cannot query internal supporting structures for column 'calculated column'; because they depend on a column, relationship, measure that is not processed. please refresh or recalculate the model.

  • Article
  • 06/05/2018

Question

Tuesday, June 5, 2018 2:21 PM

Hi Friends,

 i am getting the error as in title.

I have a cube. It worked perfectly fine in visual studio. Then I deployed it to server. After deploying I did "process recalc "  on the cube. I ran a sql agent job to fetch data into cube/partitions.

When the job ran first time it brought the expected data.

Then I updated data value for a column and again ran the job. after the job completed I browsed the cube to see data. But got the error as follows. **cannot query internal supporting structures for column <calculate column> because they depend on a column, relationship, measure  that is not processed. please refresh or recalculate the model. **

I understand that, It means that some column,relationship or measure is not processed. But I am unable to understand, how will I find what is going wrong? what is not being processed?

Please help.

Thankyou

sania

All replies (4)

Tuesday, June 5, 2018 4:04 PM

Hi Sania,

I believe after you had done a process recalc some of the corresponding data have not been processed. Can you do a process default and see if it solves your issue?

HTH,

Ram

Please vote as helpful or mark as answer, if it helps

Wednesday, June 6, 2018 3:19 AM

Hi Sania,

Thanks for your question.

>>>cannot query internal supporting structures for column <calculate column> because they depend on a column, relationship, measure  that is not processed. please refresh or recalculate the model.
According to above error message, it might be caused by the calculated column formula. Please refer to below similar thread:
Calculated Column Error
Error about using a concatenated calculated column in a SSAS Tabular model

It might also be caused by the processing method, please refer to below blog:
https://biamir.wordpress.com/2015/12/15/fix-cannot-query-internal-structures-for-column-because-they-are-not-processed/

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

Wednesday, June 6, 2018 6:45 AM

Hi Willson,

My calculate column uses formula is as  -

**if ( **
**CALCULATE(COUNTROWS('loc_table'), **
**FILTER('loc_table', 'loc_table' [OSLKEY] = EARLIER('loc_table' [OSLKEY]) ) **
**) > 1, **
**if (CALCULATE(COUNTROWS('loc'), **
**FILTER('loc_table', 'loc_table' [Partition] >= EARLIER('loc_table' [Partition])), **
**FILTER('loc_table', 'loc_table' [OSLKEY] = EARLIER('loc_table' [OSLKEY])) **
**) = 1, [OSLKEY], **
**([OSLKEY]+([PARTITION]/100))*-1), [OSLKEY]) **

**
**

It is working fine in Visual studio(SSDT). But getting error after deploying in server.

sania

Wednesday, June 6, 2018 6:48 AM

Hi Sania,

Please refer to another thread posted by you:

Calculated Column

Thanks for your support.

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com