p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Knight's Microsoft Business Intelligence 24-Hour Trainer (http://p2p.wrox.com/forumdisplay.php?f=600)
-   -   Chapter 15 Try (http://p2p.wrox.com/showthread.php?t=86687)

Femi Sonuga February 15th, 2012 02:27 PM

Chapter 15 Try
I keep getting the following issues

1 warning

Error 4 Errors in the metadata manager. The data type of the 'Unit Price' measure must be the same as its source data type. This is because the aggregate function is not set to count or distinct count. 0 0

3 warnings

Warning 1 Dimension [Sales Territory] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0

Warning 2 Dimension [Sales Territory] : Define attribute relationships as 'Rigid' where appropriate. 0 0

Warning 3 Database [Knights24HourSSAS] : The database has no Time dimension. Consider creating one. 0 0

Please can some1 talk me through this

knight_devin February 22nd, 2012 11:29 PM

Chapter 15
Ignore the warnings here. In this case they're just suggestions. The error sounds like the data types got out of sync on Unit Price. Try deleting and adding it again.

All times are GMT -4. The time now is 01:21 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.