.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

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

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
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  

View Complete Post

More Related Resource Links

OLE DB Error: Network-Related or Instance-Specific while Deploying SSAS 2008 Cube

Hi, I encountered the below listed error while attempting to deploy SSAS 2008 DB: Error 1 OLE DB error: OLE DB or ODBC error: Login timeout expired; HYT00; A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Named Pipes Provider: Could not open a connection to SQL Server [5]. ; 08001.  0 0  I am running a standalone MSSQL 2008 named instance on Windows Server 2008 R2. Here are the steps I have taken but yet the issue is not resolve: 1) Enable Remote connections on the server 2) Enable TCP\IP 3) SQL Browser is Running 4) Set Firewall Inbound Exceptions for SQL Browser, Default Port 1433, UDP Port 1434 5) Using Management Studio I can successfully connect to the MSSQL named instance from the app server 6) I can ping I MSSQL box from the app server 7) Read and implemented all steps in the MSDN post below: http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx Thanks for your help.

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

Can SSAS 2005 run with Sql Server 2008 database engine?

Are there any known issues of running SSAS 2005 with SQL Server 2008 database engine?

not able to write log messages in event log on windows 2008 server

Hi, I am trying to write in Event Log on windows 2008 server with a windows service application. But I got this error: Service cannot be started. System.ComponentModel.Win32Exception: The parameter is incorrect at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type) at Siemens.SHS.Utilities.Common.LogManager.LogToEvent(String pLogName, String pSource, String logEntry, EventLogEntryType type) at Siemens.SHS.PEP.TaskCore.StartTask(String pPluginFilePath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.StartTasks() at Siemens.SHS.PEP.PlugnExecute.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)How can I write to Event Log on x64 platform as Windows 2008 server?Any help appreciated, thanks in advance,Cigdem

Problems with SSRS 2008 Install when configuring a back-end database on a SQL Server 2008 R2 environ

We are tyring to configure SQL Server Reporting Services (SSRS 2008) not the R2 version with a SQL Server 2008 R2 version of database. We are facing error when the configuration manager within SSRS tries to execute its scripts against the database. Do you think that SSRS 2008 may have trouble using a SQL Server 2008 R2 version as the back-end? Also, what kind of permissions does the ID installing SSRS needs to have on the SQL Server database ?  Not much is available in the documenation or online.

Migration of cube from SSAS 2008


Is it possible to migrate a cube from SSAS 2008 to SSAS 2005?


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 ?

Can multiple users connect simulateously to an offline cube created by SSAS 2008?


We have created an offline cube on a network drive from SSAS 2008 and users are able to successfully access this serially using the Excel 2003 cube add-in or Excel 2007, in concert with version 10 driver, but when a user is already connected, the second attempt to connect will get the message :

Connection to <filename> server, <dbname> database, <cubename> cube failed.  OLAP Server error: The following system error occurred:  The process cannot access the file because it is being used by another process. ., File system error: An error occurred while opening the '<filename>' local cube file.

This is regardless of whether users connect specifying read-only and we have found it impossible to connect to a cube if the file has the read-only attribute set.

Is there any way to solve this without users taking copies onto their workstations?



SSAS 2008 R2 Cube being queried by Excel 2010 Pivot Table - 60x slower than with Excel 2003!


SQLServer 2008 R2

Excel 2010 x64

Hi All,

I have a fairly complex Excel report where a raw data sheet is updated from 10 or so PivotTables pulling from an Analysis Services Cube, (2008 R2), with a VBA script that refreshes all pivottables, and then does some post-processing, formatting etc.

This was originally developed in Excel 2003, and the updating of all the pivot tables ran in under 10 seconds

I've now recreated in Excel 2010 and *each table* is taking up to a minute to refresh!

I've also observed that I can get the refresh time of a single table back down to 1sec, if I delete all other pivottables from the worksheet/book.

Its deeply frustrating, as I'm touting 2010 as being the way for our business to go...it won't help the cause if I deliver something with a x60 increase in runtime!

I've run traces of both the 2003 and 2010 versions executing against the SQL Server, the only thing I can see is that the 2003 version passes 1 single MDX query, whilst the 2010 version appears to be firing it in sections.

I've posted this in the Excel forum too.

Please can anyone help?

Many thanks,





SSAS 2008 R2, Browse cube error in VS and Management Studio - The specified procedure could not be f



I have an issue when trying to browse the cube (which was processed successfully) in either BIDs or Management Studio (2008 R2 version).

The error details are below. Can someone please help me? Ta


The specified procedure could not be found. (Exception from HRESULT: 0x8007007F) (Microsoft Visual Studio)

Program Location:

   at Microsoft.Office.Interop.Owc11.PivotView.get_Totals()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.get_TotalsEnumerator()
   at Microsoft.AnalysisServices.Controls.PivotTableHash.GetTotal(String uniqueName)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject)
   at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetDataObject(TreeNode node)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.OnItemDrag(ItemDragEventArgs e)
   at System.Windows.Forms.TreeView.TvnBeginDrag(MouseButtons buttons, NMTREEVIEW* nmtv)
   at System.Windows.Forms.TreeView.WmNotify(Message& m)
   at System.Windows.Forms.TreeView.WndProc(Message& m)
   at Microsoft.AnalysisServices.Controls.MetadataTreeView.WndPr

how to perform write back in cube?



I want to perform write back operation in my sales cube.


New DSV named query or copy and reuse an existing cube dimensions (is the latter valid) - SSAS 2008


I have a [DateAsAt] table in the DSV. This is linked to 3 fact tables to analyse and slice them from an as at date perspective (lets call them FactA, FactB and FactC). But I want to reuse this dimensions (almost like an alias) and although I have tried this and it seems to work, I just want to follow some due dilligence to make sure what I am doing is valid.

I have not created a new Named Calculation for a new date dimension that will be used in a Transactional way (not an as at way), and in stead simply copied the [DateAsAt] dimension, and pasted it back into the dimensions section of the cube (the default name it was given was [DateAsAt 1], but I changed it to [DateTransaction].

Although the relationship between the [DateTransaction] dimenion's source in the DSV (I.e. [DateAsAt]) is linked to FactA, FactB and FactC, I set a new dimension relationship between [DateTransaction] and FactTransactionD in the Dimension Usage area of the cube.

Is this valid? or MUST I create a seperate source for [DateTransaction] in the DSV and set its relationships there?

SSAS 2008 taking all server memory


We just upgraded to SSAS 2008 64 bit (and windows 2008 R2) a couple of weeks ago and now we have an issue that I can't seem to figure out.  Our cubes have not changed at all.  Previous to the upgrade we were running server 2003 and SSAS 2005 54 bit.

The issue is over the past week the SSAS servers have decided to take up almost all the memory (about 90%) on the server and render itself useless.  It is the SSAS service that is taking up almost all the memory and if I stop other services to free up some it just takes that up too.  So here is a break down of the issue and what I have tried.  The issue seems to be happening faster and faster now so I am at a loss currently.

Setup that has issue:

  • SSAS 2008 SP1 64 bit on SQL 2008 R2
  • Default configs as that worked previously in 2005
  • not structure changes
  • machine has 2 quad core procs and 16 GB mem
  • accessed via web calls and linked server on SQL server on different machine

What I have tried

  • install CU10 (due to other issue)
  • rebuild aggregations
  • reduce memory limits to 40% for low and 50% for max respectively

Results of what I have tried so far: memory still hits the 90% within 24 hours so that tells me the changes have done nothing.  I don't know what to do. <

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.


Processing SSAS 2008 cube using third party scheduler

What are the different options to process SSAS 2008 cubes automatically using third party scheduler? What is the most recommended approach?

Error: "HTTP Error 500.0 - Internal Server Error" - Windows Server 2008, IIS7, SSAS 2008, msmdpump.d



We are migrating from Windows Server 2003 / IIS6 to Windows Server 2008 (32-bit) / IIS7 and I am having trouble getting our OLAP HTTP access re-established.  I had this working fine under IIS6 but am now getting the error "HTTP Error 500.0 - Internal Server Error" when attempting to access msmdpump.dll via a browser.

Our existing Win2003 server emits a blob of useful XML when you access the dll via a browser, the new Win2008 server just issues a HTTP 500 error.  Obviously when I get around this error we'll be using standard OLAP clients like Excel and Report Builder etc.

I have followed these instructions:

The Windows Event Logs contain no errors relating to the failed attempts.  I temporarily configured Failed Request Tracing and got a couple of traces of the error occurring.  The most pertinent thing I could find in the FRT was:


ModuleName IsapiModule

Windows Server 2008 Cluster Disk write caching - SQL Server 2008

I was told by the windows admin that you cannot disable write caching in windows server 2008 when the drives are clustered. Can someone please tell me how to turn it off. I find it very hard to believe you cannot turn it off. i know on a normal server how to do it, by right clicking the drive, properties, hardware, click on the drive, click properties, uncheck write caching...However, this is disabled on my cluster. 
John M. Couch Insight Enterprises Inc. 6820 S. Harl Ave, Tempe, Az 85283 Email: john.couch@insight.com
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