Today I lost a lot of time digging on this problem so a I hope post about this will save time of other developers!
I wanted to import the UDM into a model for Report Builder. You have to do these steps:
- go into SQL Server Management Studio
- connect to Reporting Services
- define a data source to your Analysis Services database (remember, use “Data Source=SERVERNAMEINSTANCE;Catalog=DATABASENAME” connection string using “Microsoft SQL Server Analysis Services” as a Data Source Type)
- right-click the data source and choose “Generate Model…” menu item
At this point if you live in an english-language country, probably you’re done. But if you live in other countries and your regional settings is not an English one, you many be in trouble.
My italian setting generates a rsModelGeneration error. You can workaround this bug (I suppose it is…):
- close SQL Server Management Studio process
- go in Control Panel / Regional Settings and choose English (United States) in Regional Options tab (other settings as Location aren’t significative for this workaround)
- open SQL Server Management Studio
- connect to Reporting Services
- right-click the data source and choose “Generate Model…” menu item
Now you can revert to your original regional settings. I tested the report model using italian regional settings and it works well. Or, almost well. In fact I’m not able to see KPIs and calculated measures of my cubes. I’ll work mor on this, but any hint will be appreciated.
UPDATE: Thanks to Brian Welcker, to display KPI and calculated measures into a Report Model it’s necessary to associate each KPI and calculated member to a specific measure group; I didn’t (and it’s the default, guys!) so I could see them into the browser of SQL Management Studio but not into the Report Model. Once I defined this association, Report Builder allow me to use calculated measures and KPIs, including graphics.