THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Report Builder Model with UDM

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=SERVERNAME\INSTANCE;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.

Published Tuesday, November 15, 2005 6:13 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement