Measure properties   

Is there any way i can get Format_string property of Measure and Metric
? 

Thanks

Faraz

date: 5 Jan 2006 05:23:39 -0800   author:   Faraz

Re: Measure properties   

Format_string applies to a cell... I'm not sure what you want.

SELECT ... FROM CUBE CELL PROPERTIES Value, format_string

should return you the format_string for all the cells in the query.

Thanks,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Faraz"  wrote in message 
news:1136467419.232550.211810@g43g2000cwa.googlegroups.com...
> Is there any way i can get Format_string property of Measure and Metric
> ?
>
> Thanks
>
> Faraz
>

date: Thu, 5 Jan 2006 12:55:23 -0800   author:   Akshai Mirchandani [MS]

Re: Measure properties   

i want to extract the property of the Measure or Metric and then apply
on the Cell Calculation to show the same format as the measure or
metric.

this is the query to have an idea what i want to do

With  Cell Calculation MY_CELL For
'( { [Measures].[Sales Count]} )' As
'CalculationPassValue(Measures.CurrentMember, -1 ,Relative )',
CONDITION =' Some Condition will be here'
, SOLVE_ORDER ='2000',
FORE_COLOR ='11005',
CALCULATION_PASS_NUMBER ='2', CALCULATION_PASS_DEPTH ='1'    ,
-- Here i want to set the format_string Property same as Sales count
Measure
FORMAT_STRING = '#0.00'

SELECT
{ CrossJoin({[Customers].[Country].[USA].CHILDREN},{Measures.[Sales
Count]})} ON COLUMNS ,
{{[Time].[Month Of Year].MEMBERS}} ON ROWS
FROM [Sales] CELL PROPERTIES
[VALUE],[FORMATTED_VALUE],[CELL_ORDINAL],[FORE_COLOR]

date: 13 Jan 2006 00:08:06 -0800   author:   Faraz