.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

MSAS Cube synchronization under 10 MB/sec on one server, 36 MB/sec on other

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

Brief Problem Description:  MSAS Cube synchronization under 10 MB/sec.


We run more than 20 servers supporting Microsoft SQL Server and  Analysis Services.

 In all cases the operating systems is 2008 R2 enterprise.

The systems are all modern 64 bit with 64GB to 256GB of main memory.

Servers have dual “teamed” 1 Gb/s network connections.

We implement the concept of a staging server and a live server.

On the staging server  the MSAS cube is regularly updated from the local SQL Server DB. The live cube server is then synchronized from the staging cube. Users only go against the live cube.


View Complete Post

More Related Resource Links

Getting Below error while accessing SQL server cube

Getting Below error while accessing SQL server cube   Error Generating Drop Down Values   Odbc driver returned an error (SQLExecDirectW).   Error Details Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. URL: http://SIMAPPWQS99/olap/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000) SQL Issued: SELECT "- AppReceivedTimeYQMDD"."Year" FROM "Medicare E2E Tracking" ORDER BY 1

Cube Writeback SQL Server 2008 R2 (SSAS, write back)

CUBE WRITE BACK in SQL SERVER 2008 R2 Did anybody get the SSAS write back functionality to work against a decent sized datawarehouse? I'm not asking about a little demo but a significant sized footprint e.g. 14M Rows measures, 6-8 wired Dimensions with 8-10 attributes each. I setup a test server using a Dell XEON ( 2x4core) with 48 GB RAM hardware and the latest Sql Server 2008 R2 release. I used the What-If scenario in Excel 2010 and modified a higher level, hoping SSAS would push the values down. After about 15 minutes and after having used 48 GB memory (on average 5% CPU) Excel throw an error - short on memory - and stopped the action. I found the same behavior in Sql server 2005 and 2008 and was hoping this would work now but apparently not so. Here are my questions: Is anybody using this at all? how can one calculated (roughtly) how much memory is requiered? is there any paper that describes best practise? Thanks for any help in advance, Dirk  

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Deadlock during CUBE Synchronization

When OLAP database synchornizes with other OLAP database, we get error saying ""Transaction errors: Aborting transaction on session %". what might be reason for this error when CUBE/database syncs with other database. As per understanding, sync should not hold any locks> any help here will be greatly appreciated.SugeshKumar

Profile Synchronization on a Single-Server Farm

Profile synchronization is documented to not work on a stand-alone SharePoint 2010 installation, but is it supposed to work on a single-server farm?  Profile import works fine in our single-server SharePoint 2007 farms.  The SharePoint administrator here is telling me that we need to add another server to our SharePoint 2010 single-server farm to get profile synch to work.  That does not make sense to me.  A farm should be able to run all the service applications on 1 server (which is the normal configuration in an evaluation environment).  Jeff B

Modifying MDX for a Cube deployed on AS Server



I have a cube deployed on an SSAS Server. Is there any way I can modify the cube's MDX online (without taking it offline) via a C# App?


Appreciate your soon reply!


Does Cube Synchronization Support Network Service Account



We are doing Cube Sync between 2 servers. Analysis Service on Both Machines are running under built in Network Service account. When i do cube sync i get following error;

Executing the query ...
Errors in the OLE DB provider. The server returned the following error:  (Either the user, DOMAIN\MACHINE$, does not have access to the Country database, or the database does not exist.).
Backup and restore errors: An error occurred while synchronizing the 'Country' database.
Execution complete

Does SSAS Sync supports using Network Service Account?

If Yes then how do i do this. I tried creating a role in SSAS database and Give Full Rights to Network Service account of source server but i keep getting error DOMAIN\MachineName$ not found.

Please advise.



0x80040154 error processing a cube from SQL Server 2008 R2 x64 database engine to OLAP Server 2000 x


I recently upgrade from SQL Server 2000 x32 to SQLServer 2008 R2 x64 but only the database engine not the Analysis Server, I used to use this code to proces the cubes.


but now it do not  work more with the error:
Error at create server:
Error      Source                    Description          HelpFile HelpID
---------- ------------------------- -------------------- -------- -----------
0x80040154 ODSOLE Extended Procedure  Clase no registrada NULL     0

(1 row(s) affected)

I found this article:

It means that I can not process the cube using the same method any more ?

Cannot Browse cube correctly after upgrading SQL Server 2005 to SQL Server 2008


I upgraded to SQL Server 2008 from 2005 and now when browsing my cubes only one measure displays at a time e.g. i can view two measures actual month and YTD the two displays but when i drag a dimension to the row, the actual month disappears and only YTD displays. if i remove the YTD measure the actual month shows again. Without the dimensions in the rows they both show. Does anybody have a suggestion on how to resolve this? it worked perfectly well before the upgrade.


Project Server 2007 Cube Building Error




I have no experience with MDX and it appears that during the cube building process for Project Server 2007 there seems to be some deficient MDX scripts.  I looked at the SASS logs with no luck and looked in the application logs with no luck.  I scripted out the problematic cube MSP_Portfoilio_Analyzer and found the 'Reported' syntax but don't really know how to correct or if there is even a problem.  The cube has built in the past with no problems.  Any help would be appreciated.


Server build is as follows:

Microsoft SQL Server 2005 - 9.00.3200.00 (X64)   Oct  2 2007 12:23:02   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)  


The server has both SQL Server and SSAS installed.

Cube access to another user from same server

if i am trying to assign  the cube access to someone The following system error has been occured:
the trust relationship between the primary domain and the trusted domail failed.(Microsoft.AnalysisServices)

Web Synchronization require which server edition license?


I read somewhere that mention Web Synchronization is only supported in SQL 2005 Enterprise edition. Is this true?

My client is using SQL 2005 Standard, does this mean I can't use web synchronization?

How can deploy a cube from production server to local server?



How can deploy a cube from production server to local server?

I tried to do it from BIDS, I have opened production server database from BIDS but nothing happened when I click project file.

I couldnt change default deployment

Also I have tried Wizard but couldnt find product server asdatabase

Any help will be appreciated



is it possible to process the cube using vb.net/c# which exists in the remote server?




can we process the cube exists in the remote system, using vb.net/c#


i am able to process in the same system, where analysis service available.


i couln't process this from the client system.


is there any soluctions?



SSAS Configurations for SQL Server Database and Cube on one Server


Currently, my system has SQL Server 2008 and SSAS on one server,

and when querying is active, SSAS shows memory problems.

From the web, I found this document,

SQL Server Databases and cubes on one Server


and as the document suggests, I'd like to change memory related setting for SSAS.

But the document is based on 2005 version.

Any suggested parameter values for 2008 ?

call JavaScript - jQuery code from ASP.NET Server-Side

jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.

jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend