Hi,
I have a problems with the field calculations. NOT Work.
When i tried calculate total sales for a specific store, this duplicate or
3, 4, 5 times the total sales.Hello Guillermo,
I would look closely at you data source view and check that there is
nothing funny with the table joins you are basing your model on. This
is the main place where something goes wrong and causes the issue.
I would also review the report you are creating and check there are no
many to many possibilities with entries you have selected.
If you are still not having any luck have a look at the blog entry
describing how to trap the SQL generated by Report Builder.
http://blogs.msdn.com/bobmeyers/archive/2006/07/05/657125.aspx
Hope this helps
Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment