I have a "real" Time dimensions with levels:
Year, Month, Day, Shift, Hour

The Shift level is built from a table (tShifts) in SQL. This table has a
field called StartOfWeek. I have created a virtual Week dimension based on
the StartOfWeek field in tShifts and it works ok. This dimension has a single
level - Week.

I now need to add Day, Shift, and Hour levels to the Week dimension. I tried
just adding the Day level, taking the expressions for Key and Name from the
Day level of my Time dimension. When I tried to save it I get an error msg:
"Virtual dimension week is invalid.\n The source for a level in the virtual
dimension was not found. <number of reasons why it may have failed...>"

Any suggetions on how to use the aggregations from the existing Time
dimension for my enhanced Week dimension? If the details provided are not
sufficient, I can provide more details.

Existing Required
Time Dim Week Dim
---------------------------
Year
Month
Week
Day Day
Shift Shift
Hour Hour

Thanks,

Les McPhee

Hi Les,

If you define Member Properties for Day/Shift/Hour fields, then you can
add those to the Week virtual dimension.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

What is the definition of those members props that allows me to add them as
levels below the Week level of my Week virtual dimension?

Existing Required
Time Dim Week Dim
---------------------------
Year
Month
Week
Day Day
Shift* Shift
Hour Hour

The StartOfWeek value on which the Week is based is store in the Shift table.

Les McPhee

"Deepak Puri" wrote:

You should be able to add Member Properties like "Day", "Shift" and
"Hour" (or with other suitable names) at the Hour (lowest) level. These
can then be added to the virtual Week dimension as levels below Week.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***