Display DIMENSION PROPERTIES in the all member -
09-20-2004
, 07:11 AM
I need use DIMENSION PROPERTIES in my work.
I modified the example in the online help of Analysis server below
----------------orginal example-----------------
WITH
MEMBER [Measures].[Store Size] AS
'Val(Store.CurrentMember.Properties("Store Sqft"))'
SELECT
{[Measures].[Unit Sales], [Measures].[Store Size]} ON COLUMNS,
{[Store].Members} ON ROWS
From Sales
-----------------------------------------------------------------------
The Store Size didn't display with the ancestor of [Sore Name]
I want to display the Store Size of a [Store City] as the sum of Store Size
in the City.
How can I do that? |