February 13, 2009 at 8:51 am
I inherited a cube and am trying to fix the last outstanding problem. If someone can tell me how to fix this problem, I will build a small shrine and pray earnestly to that person!
In Visual Studio 2005, I opened a project then open a dimension (call it PN). In the upper left hand corner of the display, the measures are listed. I opened the (call it PN) measure tree and it contains an item called "Created Date".
I clicked on the Browser tab. Then I dragged the Created Date measure item into the Data Area. The cell had a header (Created Date), but in the data cells was the term "VALUE#".
When I go to the web site and a report builder, I select this measure (Created Date), When I try to drag it into the data area, I get the following message: "The string '202673-03-23T00:00:00' is not a valid AllXsd value".
The underlying data in the logical view (for the dimension) shows the data in valid date values. Also, the table that provides most of the data for the logical view has the column with a datetime data type.
Can someone point me in the right direction?
Thanks.
February 13, 2009 at 9:30 am
A date as a measure is weird. Measures are things that are aggregated. By default, the aggregation method is going to be SUM, so it is possible you are getting the sum of all of the decimal values of the dates in your cube?
I think, at best, for a date aggregation type you need to be using MIN or MAX. It is more likely that this is not supposed to be a measure in the cube.
February 14, 2009 at 6:20 am
Ditto what Michael stated. Take a look at the properties of the measure and look at the AggregateFunction value and change the current setting from SUM to something that would be more meaningful for a Date (like MIN or MAX).
Most likely this should be a dimension attribute or property instead of an actual measure. Guess we would need more information as to where this is actually being stored and what you are trying to use this for.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
February 14, 2009 at 7:25 am
Thanks to all. The problem was that the default is SUM. I changed it to MIN and a few others, and the problem went away.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply