Fedor
Fedor

Reputation: 1

SSAS 2019 Tabular adventure-works-tabular-model-project-1200.zip Not work in VS 2022 ( Error: Input string was not in a correct format.)

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

Answers (1)

Fedor
Fedor

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

Related Questions