Hi,

If the reason to use the SP is to schedule the processing the cube, I would suggest creating a DTS to do just that.

You should use the "Analysis Services Processing...

Thank you Steve.

We will try out your suggestions.

Tiago.

I need to rename the database in Analysis Services, not SQL Server.

In my experience for performance issues retrieving the cube, I would suggest doing when loading the cube (thru a view). I.e., processing the cube would be marginally slower but retrieves...

The only task you need in the DTS is the one to re-process the cube in "refresh mode", because everything else must be done in the SP. I.e., in the...

You need to use the "Analysis Services Processing Task" (is the cube icon on the task section).

For more information search "Analysis Services Processing Task" in Books Online.

Hi,

I am facing this problem is some situations where the OLAP server runs the query in less then 1 second (according to the query log) but Excel takes 50 minutes...

Hi,

Tried out the example above and when executing the query I got this error message:

Server: Msg 7302, Level 16, State 1, Line 1

Could not create an instance of OLE DB...

Hi,

I am experience some performance and limitations problems using PTS to retrieve data from Analysis Services to Excel.

I once so a presentation of Reuters retrieving data using XML/A. However, I...

The cube as 12 partitions with data slices for increasing the retrieve response. However, the relational table is just one because on July I can have data for April.

The question...

Steve,

Regarind the PivotTables options "3. Under the "Data options" section check the box for "Enable drill to details"." is not available, although the cube has drill through enable and my...

The problem is that after 12 months (the cube as information relevant for one Fiscal Year) the number of rows in the fact table can be over 20 million rows....

Thanks for your replies.

Steve,

The one contract can have from 1 upto 200 slots associated (being the slot the 'quantity associated').

We were able to find another solution after some tentatives....

Apparently the problem is that Excel can only retrieve data for members names which the total length does not exceeds 256 characters .

Hi,

I am also not able to install the metadatascripter . Actually, I was able to installed it on my PC. However, I had to...