question

AvhilashKumar-9448 avatar image
0 Votes"
AvhilashKumar-9448 asked CarrinWu-MSFT commented

Tabular model 1 table not processed

In Tabular Model, can we browse the cube and it will return the data even if a dim table is not yet processed.

sql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Your question is more related with SQL, I will remove network tag and add the corresponding sql-server-analysis-service tag. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

Hi @AvhilashKumar-9448,

Welcome to Microsoft Q&A!

In Tabular Model, can we browse the cube and it will return the data even if a dim table is not yet processed.

No, you cannot browser the cube if you don't deploy a database in Tabular Model. Once you deploy a tabular database, you can browse its data in SSMS by right-clicking the database in Object Explorer and then clicking Browse. Please refer to Getting Started with the SSAS Tabular Model to get more information.


Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.



Model is deployed and instead of processing the cube as whole, I am processing tables one by one. One of the table is throwing some processing error or taking v long time to get processed and I am cancelling its processing. So except one table all the tables are processed. Now can i view the cube data and will it return data correctly for at least the processed dimensions?

0 Votes 0 ·

Hi @AvhilashKumar-9448, sorry for the late reply. If an error occurs at any point during the database processing, the entire change is rolled back, again ensuring that the database is internally consistent. So you could view the data if the cube have been process successfully before.

0 Votes 0 ·