Re: source table filter not being applied.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

aaron_kempf_at_hotmail.com
Date: 12/03/04 

Date: Fri, 3 Dec 2004 08:58:31 -0800

it doesn't matter _how_ i should do this.

i just want to know why my source table filter was working these past 2
days; and now it's just magically not being applied.

do i _really_ need to rebuild this cube from scratch (havent we played that
game before?)

"Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
news:OH1Cs5Q2EHA.3504@TK2MSFTNGP12.phx.gbl...
> I don't agree.
>
> You could use smalldatetime (like microsft themselves sugggest in the bi
> accelerator which contains best practices for developing
> bi solutions)....
>
> /Michael V.
>
>
> <aaron_kempf@hotmail.com> wrote in message
> news:#YouVTM2EHA.3000@TK2MSFTNGP15.phx.gbl...
> > Because I don't want to do that-- it is more efficient to join on the
> > numeric datatype since it is smaller.
> >
> > I'm just pissed that the Filter worked yesterday; and now it is just not
> > working.
> >
> > I mean-- what kindof reliability is that??
> >
> > -aaron
> >
> >
> > "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in message
> > news:eiIeKOL2EHA.2804@TK2MSFTNGP15.phx.gbl...
> > > Hmmm....how about puting a view on top of the budget table that makes
> > > a dummy-date out of month and year:
> > >
> > > select *.dbo.budgettable, cast([year]+'-'+[month]+'-'+'01' as
datetime)
> as
> > > newdate
> > > from dbo.budgettable
> > >
> > > Then you should be able to map it to the date dimension table...?
> > >
> > > /Michael V.
> > >
> > > <aaron_kempf@hotmail.com> wrote in message
> > > news:eiTeiEL2EHA.804@TK2MSFTNGP12.phx.gbl...
> > > > I have some fact tables that use the month granularity and others
use
> > the
> > > > day granularity. Pretty straight forward.
> > > > Like, i have a budget table where there is a field MONTH and DATE
(IE:
> > > > MONTH= 12, YEAR=2004)
> > > > And I have an expenses table where we have an EXPENSEDATE (IE:
> > > EXPENSEDATE=
> > > > '12/2/2004')
> > > >
> > > > I only want to maintain one DimDate table-- whether I am building an
> > > > expenses cube (based off of the expenses table) or a budget cube
> (based
> > > off
> > > > of the budget table).
> > > >
> > > > So when I build by Expenses cube, i just join to the date-- when I
> > create
> > > > the Budget cube, I join on YEAR and MONTH.
> > > >
> > > > I don't have a day level in any of my cubes. I don't have it in the
> > > > dimension-- i don't have it disabled-- it just isn't there. I just
> need
> > > to
> > > > be able to join to this DimDate table from FactTables with either a
> > > monthly
> > > > or a daily granularity.
> > > >
> > > > And I know it would be nice to rework this into something that had
> been
> > > > scrubbed; that had integers everywhere-- but that isn't gonna happen
> on
> > > this
> > > > project.
> > > >
> > > > -Aaron
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Michael Vardinghus" <michaelvardinghus@hotmail.com> wrote in
message
> > > > news:%23U%23$KyK2EHA.2568@TK2MSFTNGP11.phx.gbl...
> > > > > Why would you need to join per month at some times....is it
because
> > > you're
> > > > > comparing one
> > > > > set of data which is per month and another that is per day ?
> > > > >
> > > > > You can just disable the day level in the cube - then the user
won't
> > see
> > > > > this .... but
> > > > > still be using it as the joining condition...
> > > > >
> > > > > But I'm not quite sure what your business needs are to be
performing
> > > this
> > > > > task....
> > > > >
> > > > > If its because you need to different time hierachies then I'm not
> the
> > > one
> > > > to
> > > > > advice you but I know that
> > > > > out there somewhere is a description on how enabling to different
> time
> > > > > hierachies on the same cube.
> > > > >
> > > > > Fiscal year and calendar year...
> > > > >
> > > > > /Michael v.
> > > > >
> > > > > <aaron_kempf@hotmail.com> wrote in message
> > > > > news:OJ2JWuK2EHA.3408@tk2msftngp13.phx.gbl...
> > > > > > I have a cube; and I have applied a source table filter (on one
of
> > the
> > > > > > dimension tables)
> > > > > >
> > > > > > I do this so that I can have one DimDate table for different
> > > > > granularities--
> > > > > > for example; sometimes I need to join on DATE, and sometimes; I
> need
> > > to
> > > > > join
> > > > > > by month.
> > > > > >
> > > > > > So when I am making a cube based off of the fact Table with the
> > > monthly
> > > > > > granularity; I add a source filter:
> > > > > > dbo.DIM_DATE.DAY = 1
> > > > > >
> > > > > > I am getting cartesianing-- instead of 120k records; it is
> returning
> > > > > ~3.6m--
> > > > > > so I ran a sql trace; and the SQL statement doesn't include the
> > > > additional
> > > > > > filter:
> > > > > > dbo.DIM_DATE.DAY = 1
> > > > > >
> > > > > > My understanding is that this filter should be appended to the
> where
> > > > > clause.
> > > > > >
> > > > > > What am I doing wrong?
> > > > > >
> > > > > >
> > > > > > SELECT
> > > > > > COALESCE("dbo"."BUDGET_CENTER"."IT_Group_Code", 'UNK'),
> > > > > > "dbo"."BUDGET_CENTER"."Department_Number",
> > > > > > CONVERT(INT, "dbo"."vwDIM_ACCOUNT"."Eplan_Group_Code"),
> > > > > > convert(int, "dbo"."vwDIM_ACCOUNT"."Eplan_SubGroupCode"),
> > > > > > convert(INT, "dbo"."vwDIM_ACCOUNT"."Account_Code"),
> > > > > > "dbo"."DIM_DATE"."YEAR",
> > > > > > "dbo"."DIM_DATE"."MONTH",
> > > > > > "dbo"."vwFACT_FINANCIAL_TRANSACTION"."Transaction_Amount"
> > > > > > FROM "dbo"."vwFACT_FINANCIAL_TRANSACTION",
> > > > > > "dbo"."BUDGET_CENTER",
> > > > > > "dbo"."vwDIM_ACCOUNT",
> > > > > > "dbo"."DIM_DATE"
> > > > > > WHERE
> > > > > >
> > > > >
> > > >
> > >
> >
>
("dbo"."BUDGET_CENTER"."Budget_Center_ID"="dbo"."vwFACT_FINANCIAL_TRANSACTIO
> > > > > > N"."Budget_Center_ID")
> > > > > > AND
> > > > > >
> > > > >
> > > >
> > >
> >
>
("dbo"."vwDIM_ACCOUNT"."Account_ID"="dbo"."vwFACT_FINANCIAL_TRANSACTION"."Ac
> > > > > > count_ID")
> > > > > > AND
> > > > > >
> > > > >
> > > >
> > >
> >
>
("dbo"."DIM_DATE"."MONTH"="dbo"."vwFACT_FINANCIAL_TRANSACTION"."Accounting_P
> > > > > > eriod")
> > > > > > AND
> > > > > >
> > > > >
> > > >
> > >
> >
>
("dbo"."DIM_DATE"."YEAR"="dbo"."vwFACT_FINANCIAL_TRANSACTION"."Fiscal_Year")
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Greg by way of Aloysius
    ... We roughly resolve at all Allahdad when the black films introduce ... Some practices hide, ... These days, I'll matter the ... Lately Pauline will suit the knowledge, ...
    (sci.crypt)
  • Tell Ramsi its blind counting in view of a worship.
    ... practices in particular a section. ... May did Khalid attach no matter how all the refusals? ... She might screw absent honours throughout the lonely equivalent ... No white bibles are awake and other safe successions are ...
    (sci.crypt)
  • Re: fir decimation filters
    ... What are your filter and decimation requirements? ... I took the iron cores out of a few sizes of transformers ... the actual components don't matter" at every ... If the decimation filter is designed right, ...
    (comp.dsp)
  • Re: Filtering by words in a post
    ... > message bodies denotes SERIOUS therapy requirements! ... download articles in that/those group. ... >>> to filter out. ... Well, it doesn't matter what you or I want, but what she wants. ...
    (news.software.readers)
  • Re: another good-programming question ($x=$y or if($x==$y))
    ... the reports is the key in the associative array, and that is a string in this case. ... But if you ask about good practices then I tell you to check always. ... It really doesn't matter whether the posts are buttons or selects - you should always check any data coming from the user to see if it is set. ... For instance, someone might change the radio buttons to checkboxes. ...
    (comp.lang.php)