Formatting "scoped" calculated members

Hot Topic

Cant see Db created inside VS in the SSE Mgmt Studio
Discard Rows in a flat file
Data Source / ODBC error
Logon Failure
Installation support for XP SP2
Select multiple values from a dropdown in RS 2000?
Strings, Splitting, and Numerics
Start time of a overrunning job
Data Flow Source for dbf (DBASE IV) files
Cannot Connect to Server

SQL Server

Unable to replicate over websync but via the lan
Problem using SQL Server Mobile 2005 with Windows Mobile 5 application
DB Objects stored in VSS
Export - Changing Text in Drop Down
Can't connect to Report Server via Management Studio
unique values query
VS2005 and SQL Reporting Service
How to do Text Mining using SSIS
Query Designer in SQL 2005 Mgmt Studio a let-down?
Insert into Table with no values using the identity column

Formatting "scoped" calculated members

Hi,

How do I format calculated members that have been modified in a Scope-statement

Example:

CREATE MEMBER CURRENTCUBE.Test1
AS NULL,
FORMAT_STRING = "#,#.00",
NON_EMPTY_BEHAVIOR = { [Measure1], [Measure2] },
VISIBLE = 1 ;

SCOPE ([Company].[Company].children,[Measures].[Test1]);
This = [Measures].[Measure1]/[Measures].[Measure2];
END SCOPE;

My calculated member "Test1" looses its formatting in the Scope-statement and is therefore no longer formatted as "#,#.00". How can I change this




Answer this question

Formatting "scoped" calculated members

  • wang ya zheng

    Try the following:

    CREATE MEMBER CURRENTCUBE.Test1
    AS NULL,
    FORMAT_STRING = "#,#.00",
    NON_EMPTY_BEHAVIOR = { [Measure1], [Measure2] },
    VISIBLE = 1 ;

    SCOPE ([Company].[Company].children,[Measures].[Test1]);
    This = [Measures].[Measure1]/[Measures].[Measure2];
    FORMAT_STRING(THIS) = '#,#.00';
    END SCOPE;



  • Formatting "scoped" calculated members
Answer this question