Dimension Question

I have a table that consists of:
companyid
name
industrycd
subindustrycd
regioncd
when creating the company dimension, should I be linking to other dimensions
(i.e. region, subindustry) or include the names of regions/subindustries
within the company dimension?
One of the primary benefits of OLAP is allowing users to drill down and
drill up through fact data using related dimension structures; see...
http://www.intelligententerprise.com/030320/605warehouse1_2.jhtml
So if there is a natural hierarchy of
Industry -> Sub Industry -> Company
then you would generally make use of that in your dimension to allow
this drill down and drill up to occur.
As the relationship between Industry and Region is likely to be
many-to-many; a second Region -> Company dimension would be the
simplest option to include this hierarchy.
A good resource for dimensional modelling concepts is...
http://www.rkimball.com/html/articlesFundamental.html
JP wrote:
> I have a table that consists of:
> companyid
> name
> industrycd
> subindustrycd
> regioncd
> when creating the company dimension, should I be linking to other dimensions
> (i.e. region, subindustry) or include the names of regions/subindustries
> within the company dimension?

Dimension Question

I have a table that consists of:
companyid
name
industrycd
subindustrycd
regioncd
when creating the company dimension, should I be linking to other dimensions
(i.e. region, subindustry) or include the names of regions/subindustries
within the company dimension?One of the primary benefits of OLAP is allowing users to drill down and
drill up through fact data using related dimension structures; see...
http://www.intelligententerprise.co...ehouse1_2.jhtml
So if there is a natural hierarchy of
Industry -> Sub Industry -> Company
then you would generally make use of that in your dimension to allow
this drill down and drill up to occur.
As the relationship between Industry and Region is likely to be
many-to-many; a second Region -> Company dimension would be the
simplest option to include this hierarchy.
A good resource for dimensional modelling concepts is...
http://www.rkimball.com/html/articlesFundamental.html
--
JP wrote:
> I have a table that consists of:
> companyid
> name
> industrycd
> subindustrycd
> regioncd
> when creating the company dimension, should I be linking to other dimensio
ns
> (i.e. region, subindustry) or include the names of regions/subindustries
> within the company dimension?

Different headers on page 1 and 2

Our report consists of a large header on page 1 and a smaller header on the
other pages. It is important that we have the page numbers and total page
number on both headers.
--
Anders EklundDon't use a header on page 1, just include the large header information at
the top of the report and then set your report header's PrintOnFirstPage
property to False.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> Our report consists of a large header on page 1 and a smaller header on
> the
> other pages. It is important that we have the page numbers and total page
> number on both headers.
> --
> Anders Eklund|||But the varibles for "Total pages" can only be used in the header, or?
--
Anders Eklund
"Douglas McDowell" wrote:
> Don't use a header on page 1, just include the large header information at
> the top of the report and then set your report header's PrintOnFirstPage
> property to False.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> "Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
> news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> > Our report consists of a large header on page 1 and a smaller header on
> > the
> > other pages. It is important that we have the page numbers and total page
> > number on both headers.
> >
> > --
> > Anders Eklund
>
>|||But the variable "Total pages" can only be used in the header, or?
--
Anders Eklund
"Douglas McDowell" wrote:
> Don't use a header on page 1, just include the large header information at
> the top of the report and then set your report header's PrintOnFirstPage
> property to False.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> "Anders Eklund" <AndersEklund@.discussions.microsoft.com> wrote in message
> news:20F556AB-5EC6-4AB0-B924-50E16E01CB1E@.microsoft.com...
> > Our report consists of a large header on page 1 and a smaller header on
> > the
> > other pages. It is important that we have the page numbers and total page
> > number on both headers.
> >
> > --
> > Anders Eklund
>
>