Re: CubeMeisters please help.

Hi Myles,
OOPs,
It was only the sql Server enterprise manager that was timing out looking at
the view.
Cube Processing is fine.
thanks
bob
"Bob" <bob@xxxxxxxxxxx> wrote in message
news:ePx7tR7aFHA.2756@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Myles,
> Thanks.
> The crosstab is coming along nicely.
> One question more if I may.
> There is one piece of data that is at individual 'egg' record level that I
> want to drag up to batch level.
> So I do a subQuery (Select top 1 blah blah).
> This makes the overall query so expensive that it times out.
> I am willing to accept the expense as it will only be run during the
> creation of the cube and for incremental cube updates.
> How can I tell SQL Server 2000 to let it run regardless of how long it
> takes.?
> Thanks again.
> Bob
>
> <Myles.Matheson@xxxxxxxxx> wrote in message
> news:1118106965.736548.272810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hello Bob,
> >
> > That's correct creating a view or a star schema with the counts of
> > fail types should give the answer you are after. I have just solved
> > this problem on project we are currently doing.
> >
> > There is an OLAP news group for Analysis services and OLAP cube design.
> > See microsoft.public.sqlserver.olap
> >
> > Its more on technical Issues with Analysis services.
> >
> > Seeing you may have your answer I guess this was the correct newsgroup
> > ;)
> >
> > Myles
> >
>
>


.

Relevant Pages

  • Inconsistent negative numerical values in SQL2K database table
    ... not contain a '-' (minus sign). ... This "condition" came to light when a cube built on the fact table (where ... SQL Server table or in the cube interpretation of the table values that is ... Sample data from SQL Server 2000 SP3 Query Analyzer ...
    (microsoft.public.sqlserver.server)
  • Re: Inconsistent negative numerical values in SQL2K database table
    ... >and that value shows with a minus sign. ... The cube sees all values as ... >copied from another SQL Server 2000 server. ... >The cube reports: 66.63 ...
    (microsoft.public.sqlserver.server)
  • OLAP not recognizing negative SQL Server table values
    ... not contain a '-' (minus sign). ... This "condition" came to light when a cube built on the fact table (where ... SQL Server table or in the cube interpretation of the table values that is ... Sample data from SQL Server 2000 SP3 Query Analyzer ...
    (microsoft.public.sqlserver.olap)
  • Re: long processing time
    ... The AS Operations Guide was just recently posted and got dropped from their ... >> 1) Have you ran the Optimize Schema wizard in the Cube Editor? ... >> inner join between the fact table and *all* of the dimension tables. ... >>> through SQL server. ...
    (microsoft.public.sqlserver.olap)
  • Re: long processing time
    ... currently it is processing 2 partitions in parallel. ... >1) Have you ran the Optimize Schema wizard in the Cube ... >the RDBMS (SQL Server or Oracle), ... >> The cube which took 9 days to process has time dimension ...
    (microsoft.public.sqlserver.olap)
Loading