will ship with SQL 2005 (supporting both, AS 8.0 and AS 2005). Once the new
ADOMD.NET provider is released, it should also work with RS 2000.
The documentation seems to be correct wrt. the existing OleDB provider for
AS 8.0. It will not return extended cell properties in the flattened rowset.
>I tried using the CELL PROPERTIES, but it didn't return the extended
>property
> FORMATTED_VALUE.
> Tried writting it as FORMATTED_VALUE,FORMATTEDVALUE and FORMATTED VALUE.
>
> What is weird is that documentation states:
> Cell properties are not returned for MDX queries that return flattened
> rowsets; in this case, each cell is represented as if only the
> FORMATTED_VALUE cell property were returned.
>
> , meaning that the resultset in RS designed should already be formated.
> Any sample ???
> Thanx.
>
>
> "Robert Bruckner [MSFT]" wrote:
>
>> You have to write your MDX query accordingly using extended cell
>> properties.
>> Please check this MSDN link to MDX CELL PROPERTIES as a starting point:
>>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agmdxadvanced_11yr.asp
>>
>> In RS2000, you will then have additional fields in the datasets and you
>> just
>> access them as fields. RS2005 will be able to detect extended cell
>> properties and match them with the cell so that you can access the
>> extended
>> properties as properties of the field in the Fields collection, rather
>> than
>> as a separate field.
>>
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>>
>> "Minas Papageorgiou" <MinasPapageorgiou@discussions.microsoft.com> wrote
>> in
>> message news:DDD0190B-31C1-4C34-8992-575F5EA83B43@microsoft.com...
>> > Any suggestions on how to get the formatting options or the
>> > FORMATTED_VALUE
>> > of a measure through an MDX query in Reporting Services, so that the
>> > report
>> > uses the formatted value as defined in Analysis Services?
>>
>>
>>
