Hey,

a friend provided me this link http://technet.microsoft.com/en-us/library/cc966527.aspx

check out points 7, 8.

I incremented the values of the above properties based on recommendations and logical estimation.

Regards,

Samer

I incremented the values of the above properties enabling SSAS to utilize further server resources inaddition to other similar properties related to timeouts including the server timeout property which had...

Issue resolved, turns out I needed to modify some SSAS properties such for analysis to utilize more server resources, these include:

OLAP \ Process \ AggregationMemoryLimitMin,

OLAP \ Process \ AggregationMemoryLimitMax

OLAP \...

Dear friend, modifying these SSAS properties were sure did solve the problem, thanks a lot for the tip!

Best Regards,

Samer

this cube reads from 1 fact which has around 31 million records. I was afraid that there was an issue with a query timeout , but it is set to...

it was Gone From SSAS ie. no longer under the Databases node (it was the only db under the databases node)

Note that currently I have 2 sets of files which...

I changed the directory without stopping the service prior doing so, a services restart was requested after i did the change afterwhich i lost my permissions as admin and the...

Dear George,

I guess I'm facing the same scenario as I need to move the OLAP data to another directory, actually another drive due to disk space issues. I tried to...

you have to declare a variable of type string let it have the value of the smtp server(IP address), use it in the mail notification task, its easy to configure...

As...

obviously the data records are not being sent down the flow since only headers are being written to the file. Review the T-SQL statements or the source components at the...

you can use the OLEDB Command, if you have a lot of rows coming down the source then performance will suffer depending on the complexity of the statement your doing....

Best solution, if file generated from an external source as a client ask for a new export of the file with more decent format: every column has " " text...

The NEEDS NEW METADATA notification usually occurs when the package is not synchronized with the database structure (probably missing columns or varying datatypes/column width for certain fields). Check in the...

Changing the row delimiter has nothing to do with how the file adapter detects the blank spaces at the end. Moreover I cannot use a flat file connection manager before...

I need to get rid of the blank spaces at the end of each row before I can put the file in a connection adapter.

as demonstrated in the image the...