Hi,

to assign the returns to the orders, the corresponding ID must be a dimensio´n. Then you can select it on axis 1 and you get the sales and returns ordered...

Jason,

assuming that you use the Pivot Table functionality to retrieve the data in Excel, you can control whether or not the totals include all values.

Just right-click the pivot table and...

This seems to be a pattern... It...

Mia,

this is the SQL 2005 forum - you might want to post your question in the 2008 forum.

Reporting Services management is quite different from 2005 to 2008, and in particular...

You should make sure that the foreach loop variable is an absolute path.

When you run SSIS from BIDS, the current directory is most likely the dorectory where your .sln file...

Hi,

i'm afraid your information is insuficcient for a real good answer.

I would suggest to activate logging on the copy task so you can see which path actually is taken.

From what...

Jerstep,

I think you will have to detail your plans to browse the cube a bit further.

From your posting I see two different approaches to browse the data:

* find the manager...

Gavin,

maybe you can work around this by setting the Top Level dimension entries of all but one of the chains to "~".

This will only show the sums of the one...

Hi,

your problems aris from the diff with the 0 date. If you use this, dateadd(month) will always add 30 days...

it seems that this one

DATEADD("day",-1,DATEADD("month",1,((DT_DBDATE)(DateStrimg + "/01"))))

would do the job...

WM_JUSTMY2CENTS

I dont think you can delet data from the excel file from the SSIS Excel Destination.

You could creat a script task that runs before the DFT which does the...

Have you tried running the package with the SQL Profilter active? This often gives you a hint where the problem lies (e.g. misspelling of a SQL keyword).

Can you give us the exact error message?

Does SSIS complain or SQL Server?

If the latter is true, you may want to start SQL Profiler on your target database and...

Yes,

updating the statistics did help.

But I wonder if maybe I should switch to an indexed view for better View retrieval performance.

Have you ever done that?

But maybe I should first...

Stefan,

i'm afraid you're right.

The bad thing is that using my approach is the only way to be somewhat generic about the view. I am using this inside a custom SSIS...

Hi,

I started playing with the sample size. But even the 30.000 sample size now gives a super performance for my query...

It seems I have to delete or some sql server...