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 |