Hi All,

I have a base table on which I'm going to be basing my fact table for a
relatively simple star schema.

The problem I have is that historically this table contains data at time
time granularities - it is always either days or months, but it cannot
be guaranteed to be all one or the other. (Where the rows are days,
there will be one day for each day in the month and the monthly row will
not exist - the rows form a strict partition on the data, there will be
so intersection between day rows and month rows.)

I could create monthly based facts (combining the days into their
months), but I'd prefer to be able to include all this data and then
build the cube with it as is.

Then, when analysing, I'd like to drill down to the lowest available
level, to the day if possible, to the month if not.

Is this possible?

thanks,

- chris.

Should be possible if you define your time dimension as parent-child,
with its "Members With Data" property set to permit non-leaf data (in
this case, month) loading. Performance may be poorer than a regular
dimension. You can select whether the data loaded directly at the month
level is visible as a child node (Nonleaf data visible).


http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agdimensions_5ab7.asp
The Members With Data property indicates whether nonleaf members of a
parent-child dimension are allowed to have associated fact table data.
By default, nonleaf members are not allowed to have associated fact
table data, so the property is initially set to Leaf members only. The
related Data Member Caption Template property controls the names of data
members when the Members With Data property is set to Nonleaf data
visible. For more information about these properties, see Properties
Pane (Cube Editor Data View) and Properties Pane (Dimension Editor Data
View).

Important If a parent-child dimension is included in a cube with a fact
table that has rows associated with the dimension's nonleaf members, you
must set the dimension's Members With Data property to Nonleaf data
visible or Nonleaf data hidden. Otherwise, processing the cube fails.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!