April 24, 2012 at 9:29 am
html,body{padding:0;margin:0;font-family:Verdana,Geneva,sans-serif;background:#fff;}html{font-size:100%}body{font-size:.75em;line-height:1.5;padding-top:1px;margin-top:-1px;}h1{font-size:2em;margin:.67em 0}h2{font-size:1.5em}h3{font-size:1.16em}h4{font-size:1em}h5{font-size:.83em}h6{font-size:.7em}p{margin:0 0 1em;padding:0 .2em}.t-marker{display:none;}.t-paste-container{position:absolute;left:-10000px;width:1px;height:1px;overflow:hidden}ul,ol{padding-left:2.5em}a{color:#00a}code, pre{font-size:1.23em}
Hi
I have sql server master data services 2012. I created a model and entities and subscription views.
All worked fine. I had 3 entities like below
1. Product --> Name, Code, Model
2. Model --> Name, Code, Type(Domain attribute)
3. Type --> Name, Code
I created subscription views(mdm.Product, mdm.Model, mdm.Type)
I am joining these 3 tables and getting all columns from mdm.Product and a column from mdm.Type.Code
When I execute the query in SSMS, everythign well. I am displaying this data in SSRS report.
All columns from mdm.Product table displayed well but mdm.Type.Code column is displayed as #Error
I dont know why. Any suggestions where I am doing wrong?
April 24, 2012 at 9:42 am
Two things string to mind (bad pun time!) to check for:
Is it trying to sum a string (i.e. your product code)
Is it trying to format a string as number
Check out the expression and the number format and see if there are any obvious issues.
If there's nothing obvious, try creating a new table or list and just add the product code into it and see if you still get the error. If you do then it is probably an issue with your data source - perhaps it's an erroring calculated field.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply