This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
In Tabular Model, can we browse the cube and it will return the data even if a dim table is not yet processed.
Your question is more related with SQL, I will remove network tag and add the corresponding sql-server-analysis-service tag. Thank you!
Hi @Avhilash Kumar ,
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.
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?
Hi @Avhilash Kumar , 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.