Hello All-

If I look at the Warehouse cube in the Foodmart example (using
Analysis Manager), I see its fact table is "inventory_fact_1997". I
can, however, get values for 1998 - for example:

select
{[Measures].[Store Invoice], [Measures].[Supply Time],
[Measures].[Warehouse Cost],
[Measures].[Warehouse Sales], [Measures].[Units Shipped],
[Measures].[Units Ordered],
[Measures].[Warehouse Profit]} on columns,
{CrossJoin({[1997],[1998]},
CrossJoin({[Product].[All Products], [Product].[Good Imported
Beer]},
{[All Warehouses]}
)
)
}
on rows
from Warehouse

Where are those 1998 values coming from? I don't see any "time_id"
values in the "inventory_fact_1997" table that join to any 1998 date
(in the "time_by_day" table).

Thanks in advance,
Chris Keith

There two Warehouse partitions. One for 1997 one for 1998.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Chris Keith" <chrisxkeith (AT) hotmail (DOT) com> wrote