dbTalk Databases Forums  

Display DIMENSION PROPERTIES in the all member

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Display DIMENSION PROPERTIES in the all member in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ad
 
Posts: n/a

Default 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?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.