Hi

The Testing set is used to validate you Data Mining Model following Training. The Training set is used when creating the Training Model.

Your source data is divided into these...

Hi Terry

No worries, think I misread your requirement. If I've got it right the user selects 'A' and only wants to see the row labels for B + C.

To do...

Hi Phil

It would depend on the type of analysis you wish to perform. If you are going to be doing plenty of Date based analysis e.g. year to date...

Hi Terry

Possibly try the following:

CALCULATE(SUM(Sales[Sales]),ALL('FilterTable'[Column1])) - SUM(Sales[Sales])

Using your example - user selecting 'A':

The CALCULATE will return Sales (A+B+C) ignoring the user filter. The second SUM (after the minus sign) will...

Hi

The best way to capture the workload is to run a 'Server Side Trace' using tsql - you can use the SQL Profiler GUI to generate this . To re-run...

I'm not sure to be honest, table statistics might be a starting point, you'd possibly be looking at some in-depth T-SQL performance tuning techniques - which are probably best answered...

Hi

Is your "Date Dimension" working correctly. This would be the dimension used to aggregate by [Academic Year]. Is the dimension correctly allocating the TimeId to the appropriate Academic Year?

Cheers

-Matt

In response to your 2nd question.

"2. In the destination Table have the following columns. I must add the data from the flat file to my destination table and for each...

Hi

You may also want to investigate the queries that SSAS is making to your SQL Database during the Cube\Partitions processing.

This could be done by using 'traditional' T-SQL performance tuning...

Hi

If I've understood you correctly you just need to re-run the subscription 'on-demand'. To do this you need to execute a stored proc in the ReportServer database. The stored procedure...

Hi

I've found this link useful in the past for performance counters;

http://www.grumpyolddba.co.uk/monitoring/Performance%20Counter%20Guidance%20-%20SSAS.htm

The following link is to a microsoft whitepaper on ssas performance

http://www.microsoft.com/downloads/details.aspx?FamilyID=3be0488d-e7aa-4078-a050-ae39912d2e43&displaylang=en

Cheers

-Matt

Hi

Appologies if my previous post was misleading. Yes, they are completely different, yet it seems it is still good practice to run these commands following and upgrade from sql2000 to...

Hi

If you haven't done so, you may need to update the statistics;

e.g

DBCC UPDATEUSAGE(<databasename>)

--and

exec sp_updatestats

-Matt

Hi

You could also use Reporting Services & Report Builder.

Hi

You may also want to check for any truncation errors at either the data flow Source or Destination and how these are being handled in the error output of the...