.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

Cannot browse cube

Posted By:      Posted Date: October 03, 2010    Points: 0   Category :Sql Server
I have 2 problems in browsing the cube in Visual Studio 2008 (on the Cube Browse tab):
1. When I click the browser tab, the browse window shows this error:
The query could not be processed:
o XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.

2. When I click the Reconnect icon or try to move an item from the Measure Group window to the cube broswe window, I get this error, "Error HRESULT E_FAIL has been returned from a call to a COM component."

I have tried setting the data source to impersonate every way possible to no effect.  Why is this failing?

I am running SQL Server 2008 Analysis Services.

View Complete Post

More Related Resource Links

Browse SSAS Cube Data From Your iPhone

Does the world want an iPhone app that allows you to connect, browse and pivot SSAS cube data?  What features would that app have?  Is there existing apps that are close?  Looking for others thoughts on this concept.  Thanks in advance!

Excel problems to browse the Cube.

Hi,    I have a cube and i'm facing problems with to access the SSAS 2008 cube from Excel 2003.  Initially i tried to access from one machine (Windows XP & Excel 2003)  it worked. When i try to access from another machine (Windows 7 & Excel 2003) i'm getting the below error message. Excel Was unable to get necessary information about this cube. The cube might have benn reorganized or changed on the server. Contact the OLAP cube administrator and, if necessary, set up a new data source to connect to the cube. Please help me.

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

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.


Can't browse Cube and Explore data. Class not registered (Exception from HRESULT: 0x80040154 (REGDB



I'm using MS SQL Server 2008 and office 2010. I can't browse cube and can't explore data in Visual Studio, BIDS.

 I'm getting this massage:

Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (Microsoft Visual Studio)

Program Location:

   at System.Windows.Forms.UnsafeNativeMethods.CoCreateInstance(Guid& clsid, Object punkOuter, Int32 context, Guid& iid)
   at System.Windows.Forms.AxHost.CreateWithoutLicense(Guid clsid)
   at System.Windows.Forms.AxHost.CreateWithLicense(String license, Guid clsid)
   at System.Windows.Forms.AxHost.CreateInstanceCore(Guid clsid)
   at System.Windows.Forms.AxHost.CreateInstance()
   at System.Windows.Forms.AxHost.GetOcxCreate()
   at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state)
   at System.Windows.Forms.AxHost.CreateHandle()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

Browse Button is disabled


I have created a BDC using Application Definition Editor. The connectivity with the Oracle database worked well when setting it up. I was also able to successfully create the BDC Column

But when I try to add a new record, the Browse Button next to Check Names is disabled. What could be the issue?



Below is the ADF XML. Hope it can help locate a clue


<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="" Name="TESTLOB" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
    <LobSystemInstance Name="TESTLOB_Instance">
        <Property Name="rdbconnectionData Source" Type="System.String">(DES

can blackberry browse local websites


Greetings,  :smileyhappy:

 I am a vb.net developer using visual studio 2010 and sql server 2005 express, windows 7.

 Blackberry device that I am using is 8520. Now I have configured my blackberry to use wifi and I can connect to the internet successfully using my 8520. My development computer is also connected to the same router via ethernet cable, a normal lan cable.

 I have developed a test application and I would like to browse the application from my device using my wifi connection to connect to my development pc. My blackberry device is set to automatically obtain an IP address and my wireless router dchp is enabled. My dev pc IP is

 So in the blackberry browser I type I should get the default IIS7 page. I don't get that. If I type I don't get my test page. I turned off my anti virus also and windows firewall but I still cannot navigate to the page.

 I cannot use the visual studio blackberry plugin because it does not support visual studio 2010. All I want to do is browse my test

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

Clustering on cube slices

Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

Restore - Cube Analysis Services 2005

Hi, I'm from Brazil. Sorry for my English. I made a backup for my cube that has more than 2 GB, but de backup is created with only 50 mb. The backup don't showed erro message. I restored this backup without erro, but when I tryed query the cube, i receive this message: The query could not be processed: o File system error: The following file is corrupted: Physical file: \\?\C:\SQL Server\MSSQL.2\OLAP\Data\teste.59.db\"Nome_Servidor" - "Nome_Database".190.cub\Fato Inadimplencia Safra Contrato.190.det\Fato Inadimplencia Safra Contrato.167.prt\172.fact.data. Logical file . Someone can help? I realy need make this backup.Fabrício França Lima | MCP, MCTS, MCITP | Visite meu site: http://fabriciodba.spaces.live.com/ | Dicas de artigos SQL: Siga-me no twitter @fabriciodba.

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

Instant Refreshment of Cube

HI All, Is that possible cube get refreshed as soon as data updated into the relation database?   Kindly Suggest Regards Amit

How to determine when the cube refresh has completed?

I'm trying run code after a cube refresh is completed, but I can't seem to figure out how to write code to determine when the cube refresh has been completed. If it were a simple calculation, I could use the code below to determine the "calculation state", but there doesn't seem to be "refresh state" that I'm aware of. Any help will be GREATLY appreciated!! Application.CalculationState = xlDone

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.

Problem in Cube processing

Hi All, I have created cube and processed with the setting "Stop Logging",and it would take 30 min to complete processing with the error shown  Error in Olap storage engine The attribute key cannot found when processing table "Factcalldata", column programid,value 7070.the attribute is Programid.   Kindly let me know is this is the reason which is responsible for Longer processing Time ,i have created partition and aggregation in all measure groups.   Regards Amit  

Creating a 3D cube and display content on each side

Dear all, I would like to show different content in each of a cube face that I can manipulated in space. My customer has see this in a desktop 3 D application somewhere on the net and would like to have this integrated in my applciation I am really interresting to integrate this has it is a good customer but have never done it Does any one have a done this already or sample for doing it ? regards SergeYour knowledge is enhanced by that of others.

Retrieve cube data directly from Relational database - is this possible?

I have a cube created in SSAS R2 2008. Now i would like to retrieve some data from this cube, using MDX language, and then to process it in Relational SQL database! Is this possible? I am new in SSAS, please help!  
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