I am trying to issue a MDX query from SQL which would insert the flattened
result sets into a temporary table. The table is defined below

Create table #Tb1(
col1 varchar(255),
col2 int,
col3 decimal(15,2),
col4 decimal(11,2),
)

In the MDX query, I have calculated members with the format string property
set as
FORMAT_STRING = ''#.00''.
When I run the query, i get the result set without any formatting i.e. i get
numbers like 15.234566 and when i try to import it into the table i get the
"Error Converting nVarchar to Numeric". Note that there was no overflow
error.

Question 1:
How do i format flattened rowsets which uses calculated members
Question 2:
why am i getting the error

Thanks
Satish