I am working with Denali Tabular model. In Tabular model I have created one project and that project I had deployed to ssas. Project works fine in ssas but when I do any changes in relational database and then process the tabular model then it take updated data but when I try to deploy tabular model to ssas it does not show updated data.
And in ssas, workspace database(Project name with user name and GUID) gets created automatically by tabular model.
And if I make any change in workspace database name using setting file it’s not saved Permanently.
Is there any solution on this?
- Moved by Janet YeildingMicrosoft employee Monday, January 07, 2013 5:16 PM (From:SQL Server Data Tools)
SSAS Tabular creates a temporary database which exists as long your cube project is opened. When you close the project, that database gets deleted.
Make sure you also process the database when deploying the cube to Analysis Service instance.
- Proposed as answer by Olaf HelperMVP Sunday, January 06, 2013 9:03 AM
Can you check that you are deploying the correct tabular model and the connection string is correct? Tabular model will have an associated workspace in Visual Studio 2010 and will update the instances correctly?
If not, can you delete the tabular instance and try re-deploying the tabular instance?
I am deploying the correct Tabular model and connection string is also correct.
And when i deleted tabular instance and re-deploy the tabular then it take updated rows in analysis services instance.
But I think it's not the correct way because after this, again I have added some rows in relational database and then process the tabular and deploy the same, then it does not updated (rows) in Analysis services.
I have one more Query.
If you know can u please tell me what is the Aim of Workspace database means why it gets created automatically when we opened the tabular model and it gets deleted after closing the tabular model.
Actually this query is just for my knowledge.
Thanks in Advance.
The vertipaq engine is available only on the server where tabular model is deployed. To enable distributed developer teams work with the same tabular instance, VS requires a local workspace to be created on the developer workstation. It is very similar to how VSTF source control system creates local workspaces for checkouts of source code.