dbTalk Databases Forums  

Can't See Member Property

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


Discuss Can't See Member Property in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
john.r.carter@bankofamerica.com
 
Posts: n/a

Default Can't See Member Property - 01-09-2006 , 09:34 PM






This is my first time working w/ member properties so I will try to
explain my issue in complete detail.

I have a dimension named Time. The structure is outlined below.
Time
Year
Month
Day - w/ Member Property DayName
When I browse this dimension I can see the name of each day for every
day member. This is great.
However, when I run a simple query against the cube, I can no longer
see the property. Here is my query:

SELECT
{[Measures].[Net Purchase Amount] }ON COLUMNS,
{[Time].[Day].Members} ON ROWS
FROM [Payments and Purchases]

When I double click on the day member it brings up the properties box
and within that box I do not see my property. This is very confusing
for me. I thought that since I see me property when I browse the
dimension that everything was fine.

Can anyone tell me what I am doing wrong...Or is there a better way to
get the day number and name for a time dimension.

Thank You in Advance for your help,
JC


Reply With Quote
  #2  
Old   
abhijeet
 
Posts: n/a

Default Re: Can't See Member Property - 01-10-2006 , 03:31 AM






hi John,
I am not sure, but adding dimension properties clause to ur axis should
help to get the member properties. it shud b modified to

{[Time].[Day].Members} DIMENSION PROPERTIES [Time].[property name] ON
ROWS

i guess.
abhijeet


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.