Dear Wendy,

Pretty easy. You have to make a dataflow in the package design. Let me know if you have BIDS installed? and then I will give you a step by...

Dear James,

Many thanks on the useful insights. I am new to SSAS and would like your help in future as well.

Regards,

Rafayz

Dear James,

How do you install ProClarity?? And can you post some links for Beginners MDX Queries?

Regards,

Rafayz

James, I think you are right......SSIS packages are quick.....but the MDX query actually needs to be optimized before it is put into action.

@smith..You can try and fetch a small dataset...

James, I would agree with you that it would for sure degrade performance issues.....Is there any other way out to this problem, in your opinion??

Regards,

Dear Joy,

Not much help but I can come up with a couple of ideas.

1)- The first is that you can export data from SSAS using different dimensions on different excel...

Dear Smith,

I think you are right on the money. Yeah one million rows is the limit. I will look into the MDM query today and will let you know something.

Best,

Rafayz

Hello Joy,

I haven't tried 7 million records ever but it should work although it will take some time.

Regards,

Rafayz

Samuel,

The log shows that your setup file is corrupted. I would suggest you installing from a newer medium and that after you have deleted all the bad installed files.

Just...

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 analysis...

Dear,

The simple answer to this is to deploy the cube and then import it in excel.

Regards,

Rafayz

I have faced this problem several times while installing between SQL Server 2008 R2 standard and enterprise edition. The solution to the problem is that after un-installing the current instance...