.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

Measure Error in Cube

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

Hi All,

One of our cubes has one measure showing #Error in SSMS and #value! in Browser. This is not a calculation and is coming straight form the fact table. The value shows up correctly in fact table and the cube processes without any errors. Any ideas?


Thanks in advance.

View Complete Post

More Related Resource Links

Obect reference error when using "Last Value" cube measure


Hi, I'm getting a pretty sweet object reference error when I change one of my measure from "sum" to "Last Value":

"Object reference not set to an instance of an object"

I get it when I try to process the cube from VS (SSAS 2008).  Once I change it back to "sum" the cube processes fine.  I have another cube, all else equal, that processes fine with a last value measure. I also tried "Last non-empty value" but that also failed.  Any thoughts?

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 Processing Error

Hi All when i process the cube some times i get the error  "OLE DB or ODBC  Error: Operation Cancelled; HY008. Internal Error: The Operation Terminated unsuccessfully  " https://connect.microsoft.com/SQLServer/feedback/details/286505/error-in-processing-cube?wa=wsignin1.0 In above link Microsoft they said to increase Query time out, i made it 0 even it repros I am using SQL Server 2008.   Thanks

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?  

processing measure group : memory error : the operation cannot be completed because the memory quota

Hi, I'm stucked with this problem. Untill last week, the cube processed without any problem. Since last week, I'm getting this error. I have been searching in different forums, and I tried some suggestions, like changing memory limit properties, ... It is getting worse.. So I reset all properties to default again. I am running SQL-Server + MS-AS 2005 SP2 on server with 4GB of memory. This is a dedicated server, nothing else is running on it. The fact table has +/- 14 million records, several dimensions en 2 measure groups. I don't have problems to process the dimensions, but when I try to process the cube or the measure groups of that cube separately , the error persists. I have changed the datasource view, and replaced the fact table by a Named query. Even when I put a 'WHERE datapart( year , fact_date ) >= 2009 ' clause to reduce the number of records to +/- 5 million, I'm still getting the error. I don't understand what is wrong, the cube always processed since +/- 2 years. As I said, I have found a lot of this kind of Issues on different websites, I have been trying to change some properties. But this still does not solve the problem. Could it be that MS-AS settings are corrupt somewhere ? Is it a good idea to re-install MS-AS 2005 + SP1 + SP2 ? Or is there another reason possible ? I really appreciate any kind of help, because I'm

Error while processing the cube

Hi All,  I am trying to execute a cube using the xml script. Below is the error what I am facing.   Message Executed as user: NT AUTHORITY\NETWORK SERVICE. ...s="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults"><root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"><Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" /><Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception"><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: [DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.; 08S01." Source="Microsoft SQL Server 2008 Analysis Services" HelpFile="" /><Error ErrorCode="3240034316" Description="Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'IA DIST VEH VOL A1', Name of

Error querying SSAS cube.....permission problem???

I've been developing a BI solution with SQL/SSRS/SSAS 2005.  I've done all the development with an account that has full admin permissions on the server.  Now I am trying to give users access to the data without admin permissions.  When a user runs an SSRS report that queries an SSAS cube I get the following error:   An error has occurred during report processing. (rsProcessingAborted)  Query execution failed for data set 'Division'. (rsErrorExecutingCommand). Since I don't get this message when I run the report I'm thinking it's a permission thing.  I set up a domain user group, 'SQL Users', and gave them access to the SQL Server Reports database and the Report Manager but don't know if I have to grant permissions on the SSAS database.  SSAS doesn't use the same security settings that SQL uses.  I added SQL Users as a role in my database but that didn't help. I'm not sure what else to try...

Error that has nothing to do with my cube

I right click on my AS cube and click "Process".  It tells me the server content is out of date would I like to build and deploy first.  i say yes.

I get this error

Error 1 File system error: The following file is corrupted: Physical file: \\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.0.dim\1.Start Date.(All).sstore. Logical file . Errors in the metadata manager. An error occurred when loading the Product dimension, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Dim Product.1.dim.xml'. Errors in the metadata manager. An error occurred when loading the Adventure Works cube, from the file, '\\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Adventure Works DW.0.db\Adventure Works DW.2.cub.xml'. 

This file has nothing to do with my database/project and is not even in the solution.  Why is my deploy getting failed due to this file?


error in process cube


hi all

im trying to process a cube and im geting this error:

OLE DB error:the qurery has been canceled because the estimated cost of this query (1039) exceeds the configured thredshold  of 300

any help?

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 ?

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 update Cube.Measure "DESCRIPTION"



How to update DESCRIPTION from $System.MDSCHEMA_MEASURES without re-deploying and re-processing the cube.

I'm using the Cube.Measure DESCRIPTION propertie to let the end user know what the measure meens, I update this propertie offen, How to do this without needing to redeploy en reporcess the entire cube ?

many thanks,

Alter measure group: Impact on cube processing?

Hi All,

I have a XMLA script to alter source column (<ColumnID>) of a measure. I would like to know
following regarding the script:

1 - Do I have to 'Process Full' the cube or other processing options are applicable?
2 - The cube takes 2 hrs to process. Will there be reduction in process time processing the cube
    after running the script or will it take the whole 2 hrs?
It running cube on production so I would like to minimize the impact of the alter script.

Thanks in advance for any help.

same measure total differs in same cube


Hi.  Folks at http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/4dad8e33-315e-4d36-a781-94448ce7e7ad seemed anxious to mark my finding "answered" so I'm posting here for an explanation of what seems to be a bug in ssas.

I am getting different totals in one measure group depending on whether the ssas db is first deleted before processing.  The total is incorrect if the db isnt first deleted prior to a "process full" on this measure group.  The measure involved is sourced from a money column that uses (all) 4 decimal places not just 2.  For over 300 million facts, I havent seen the error amount to more than $1.15.  But that is unacceptable in this app.

To some extent we've exhausted the money vs currency display argument.  This doesnt seem to matter if we do a full deployment after the ssas db is deleted. 

Is this a bug?  Does it only affect measures sourced by money columns?  Only if they go past 2 decimal places?  Only after a large number of deletions and a few inserts in the source star table?

Normally, this measure group processes Add.  Will I find that isnt working either?   The star source row deletio

ERROR"The Item could not be found in the OLAP Cube"


Our business unit uses an excel templates where they can get real time analysis. They run these reports on a daily basis.
Every time we do any changes in the structure of dimension, they get these error " the item could not be found be found", and they have to recreate these reports which is time consuming and frustrating to them.

Is there a way out to solve these problems? We constantly add and change things in the cube, but it results on them having re-create everything.

any suggestions? Is there anything I can do from excel standpoint?



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.

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