The easiest way would be to run the SSIS package only through a SQL Agent job. You would then have history available through SSMS.

You could also set up the...

with member [Measures].[Total] as

[Measures].[Amt] * [Measures].[Qty]

DRILLTHROUGH MAXROWS 1000 SELECT

{[Measures].[Total]}

on columns,

nonempty([Employee Master].[Empid].members) on rows

from

[Sales_Cube]

I think the 'DrillThrough' statement will give you the results you are looking for. It returns all rows from the data set and does not apply any aggregation.

Here is...

This could also be caused by waiting for a lock on all the tables in the query.

Depending on what you are doing with the data you may want to...

Instead of intersecting the answer sets, I would suggest intersecting the people who had those answers. So you would need to construct two MDX set statements that use the answers...

Thanks for clarifying Mike, I thought he was trying to extract data into a CSV file.

I still think SSIS would be a good choice if the CSV file comes...

Hello,

Ideally it would be beneficial to have your partitioning so that archived or static data is in a separate partition. If it is not possible to change the partitioning in...

I agree that an SSIS solution would typically be the best solution for transferring data to a CSV file. It tends to be more easily modified/debugged down the road.

James

If you are working from a network drive that has backups running during the day it may very well trigger this message. It all depends on the backup software you...

Sorry, it appears Microsoft has removed ProClarity Desktop Professional from it's available MSDN downloads. In this case you should browse the cube via Visual Studio (BIDS) and then run a...

Also, I do have one tip. If you are not that strong in MDX I would recommend you install ProClarity (If you have an MSDN account) and create your report...

I would continue trying to get the SSIS data flow task to work. I was able to extract over 2 million rows from an OLAP cube into a CSV file...

rumsmaster (5/14/2012)

---

Hello James,

Once you are done deploying your project in SSAS, open Excel, select Data from the main ribbon, then Get external data, then from other sources and finally click...

rumsmaster - How exactly do you 'Import a cube into Excel'?

Hello,

It looks like you are attempting to return a large number of records. I would recommend you first create a new MDX Query that returns a small amount of data...