Hello

I was wondering if anyone could offer some advice on the following
issues with SQL AS 2005:

I have the following code and am trying to get Format_String to work
properly. It works fine until I put a scope statement into the mix -
after which format_string seems not to work. Other properties like
back_color continue to work in MS Vis Studio browser. Anyone have
any ideas as to why or how to get my format back?

Regards

jph

--BASE RAW % CHANGE MEASURE
CREATE MEMBER CURRENTCUBE.[MEASURES].[% Change]
AS "NA",
FORMAT_STRING = "#.#%;(#.#%);0.00",
BACK_COLOR = 65535 /*Yellow*/,
VISIBLE = 1 ;

--FOR QUARTERS
SCOPE( [Dates].[Year - Quarter -
Month].[QUARTER].MEMBERS,[MEASURES].[% CHANGE] );
this = (closingperiod([dates].[year - quarter -
month].[month]),measures.[raw % change]);
END SCOPE;
--FOR MONTHS
SCOPE( [Dates].[Year - Quarter -
Month].[MONTH].MEMBERS,[MEASURES].[% CHANGE] );
this = [MEASURES].[RAW % CHANGE];

END SCOPE;

Have you tried putting the format string inside the scope statment? I am
not sure, but I am just wondering if it is pulling the format from the
raw measure.

eg.

--BASE RAW % CHANGE MEASURE
CREATE MEMBER CURRENTCUBE.[MEASURES].[% Change]
AS "NA",
FORMAT_STRING = "#.#%;(#.#%);0.00",
BACK_COLOR = 65535 /*Yellow*/,
VISIBLE = 1 ;

--FOR QUARTERS
SCOPE( [Dates].[Year - Quarter -
Month].[QUARTER].MEMBERS,[MEASURES].[% CHANGE] );
this = (closingperiod([dates].[year - quarter -
month].[month]),measures.[raw % change]);

Format_String ( This ) = "#.#%;(#.#%);0.00" ;

END SCOPE;

--FOR MONTHS
SCOPE( [Dates].[Year - Quarter -
Month].[MONTH].MEMBERS,[MEASURES].[% CHANGE] );
this = [MEASURES].[RAW % CHANGE];

Format_String ( This ) = "#.#%;(#.#%);0.00" ;

END SCOPE;


--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <5shvp19vvuivapv21v73l4ic65ovorbb00 (AT) 4ax (DOT) com>,
mma (AT) nospam (DOT) nospan says...

Thanks
Works nicely. I scoured the docs for something like this - where
would you find a reference to it?

P.S. Any reason Excel 2003 does not take the formatting at all - no
matter how it is specified?

mma

On Wed, 14 Dec 2005 22:18:52 +1100, Darren Gosbell
<jam (AT) newsgroups (DOT) nospam> wrote:

I noticed this in the AdventureWorks sample database.

Yes, I don't think it supports formatting natively. I think OWC does,
but not the built-in Excel Pivot tables. Have you had a look at the
Office Web components toolpack? It has samples on enabling Cell coloring
and drillthrough, maybe it can be extended to formatting?

http://www.microsoft.com/downloads/d...BEB5D477-2100-
4586-A13C-50E56F101720&displaylang=en

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell