Reputation: 1
I have on localhost SQL Server 2019 (1500 compatibilty level) , with SSAS tabular. AdventureWorksDW2019 DB VS community edition Version 17.12.3 (with latest SSAS extension) - 2022
Before I worked with SSAS MDM (2016) and first what I did was install solution for MDM cube and learning it.
so I want to install sample MS project for Tabular
looking at https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services we have only adventure-works-tabular-model-project-1200.zip ( (1200 compatibilty level)) (I can't found adventure-works-tabular-model-project-1500.zip in inet - what I needs )
I downloaded adventure-works-tabular-model-project-1200 and open it in VS , when try open Model.bim have error : An error occurred while opening the model on the workspace database. Reason: Input string was not in a correct format.
In SSMS I see that this cube is deployed OK : Adventure Works Internet Sales_<user_GUID> and I can even browse and process it OK.
But in VS Model.bim Not open. Seems to be problem of VS ???
1?) if any ideas how I can troubleshoot it
2?) may be there is ready **tabular **example for AdventureWorksDW (1500 compatibilty level) with alll measures and KPI done. (I looked in git hub but can't find)
3?) may be there are good **Tabular projects **(2019 or 2017 ) examples from other (M.Russo , A.Ferrari , C.Webb ot other guys) with MS SQL 2019 to look best practices with tabular project and some MS-SQL DB. to load on localhost
PS I tried workaround : in SSMS (I can make create , create/open tmsl scripts then change , id , name in it and deployed another AS DB but when import from DB into VS project still I have same error. ) Also tried to do hack : change "compatibilityLevel": 1200 to 1500 in tmsl and deploy it (but here I have error of wrong JSON format , what is clear )
Upvotes: 0
Views: 22
Reputation: 1
connected with system settings (symbpol for decimals) in english W10 : 1.1 in russain W10 : 1,1 KPI "targetExpression": "1.1", "targetExpression": "1,1", So change for russain open model OK Can be also for other Windows (German)
ps in other calculations '.' is used everywhwere
Upvotes: 0