.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

Problem of processing a cube

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :


I had a problem when I wanted to process a cube in SSAS 2008, I changed a SSIS package that supplies a table in SQL Server

View Complete Post

More Related Resource Links

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  

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

Cube processing

HI All, I am new to SSAS and but i suppose to work on cube part. I have created cube with two partition both of 5 days using getdate()-10 to getdate()-5  and getdate (4) to getdate() ,,,,so tel me if i process full cube once and then other partition in full process,then will the 5 day process data overite the full data into 5 day data or not.   regards Shraddha

Cube Processing

Hi all, I have a cube and it is processed every 6 hours. 3 different process calls the SSIS package through SQL Server Agent to process the cube, and they all may call the SSIS package at the same time. But for that I set an Indicator which tells the cube is processing and it waits for a minute and re-checks it and then processes the cube. My problem here is while the cube is processing other ETL jobs might update/delete/insert the data into Fact Tables. What will happen when cuube is processing and these things are done simulatneously. Can anyone explain what will be the possible outcome. Thanks Vineeshvineesh1701

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...

Deployment and processing problem



I have an analysis services project in Visual Studio, and now I added a column to one of the tables composing the dimensions (it's a MOLAP DB) and made it the primary key, and then I updated the tables composing the measure groups by deleting the key field to the dimension table and replacing it with a field that refers to the new column in the dimension table. The problem is that when trying to deploy the changes, I get errors for the measure group tables that say the data source view doesn't contain a definition for the old column that I deleted and thus of course is not supposed to be there. Why can't it identify the change and process it correctly, and what can I do?



Problem with displaying and processing dynamic data


I need to dynamically generate a list of images in table format.  The images can be found in either art or picts, in temp, or in temp and in one of the other two (duplicate image). 

The idea is to display any duplicates prior to copying anything over from temp to either art or picts, so I'm thinking of adding radio buttons if the same image is found in two folders.  I also want to add a submit button.  The user selects the image they want and clicks the button.  If they want the new file it's copied over then deleted.  If they want to keep the existing file the new one is just deleted.  If they select nothing, both versions of the file are deleted.  So the table will look something like this:

temp         art            picts         process
z-123                                           delete button
() z-234                       () z-234  

cube deployment fails- A duplicate attribute key has been found when processing

I am trying to create a cube using the same process that I always do. however this time I get an error message "Warning 4 Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_ALL_ResultsNewest', Column: 'MktCapGroup', Value: ''. The attribute is 'Mkt Cap Group'.  0 0 
This is using alot of data but I have created similar size cubes before. I create simple cubes with a single dimension and all the attributes related to a single master attribute. I am a data analyst, not a technologist and don;t have any real understanding of cube internals beyond the basics.

Re-processing Dimensions with a ROLAP cube


Hi all.

I have set up a ROLAP Cube because of the advantage that you do not need to re-process the cube.  AS will always go to the underlying data source for the most up to date data.  Unlike MOLAP you do not need to re-process your cube to refresh the data.

BUT.  I find this is only true for my FACT data (or for my measures).  Say for instance my dimension changes - I add the member "Australia" to the country dimension.  This new data is NOT filtering down to AS automatically, I need to re-process my dimensions for the cube to be valid again.

So my question is this.  If you have dimensions changing with each datawarehouse load, what is the advantage of ROLAP?  Is there a way for ROLAP to figure out that a dimension has changed and re-process it automatically?



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 ?

XMLA for Cube Processing fails when called from SQL Agent Job


I have some XMLA which runs fine in SSMS, but fails when called as a step in an agent job. Here is the XMLA:

  <Process xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

And here is the error from SQL Agent:

An exception (0xe0434f4d) occurred in the ANALYSISCOMMAND subsystem.  The step failed.

I am running this on SQL 2005 SP3 Developer Edition. I have even tried uninstalling and reinstalling the instance. The PC also has SQL 2008 instances installed (I'm not sure it that is relevant or not). I can get the SQL Agent job working fine on SQL 2008 and another SQL 2005 box.

Can anyone help?


dimension's incremental process generates processing on all partitions in cube


Hey eb

Have any one noticed this behavior??

Incremental process (process update) of dimension generates reprocessing of indexes on all cube's partitions,even when no change has occured in that dimension.

I am using SSAS 2005 sp2.

This is disturbing because my cube holds some 700 daily partitions so processing indexes on all of them - on an hourly basis - is very time consuming.

Also it flashes that cube's cache!


I did noticed that changing heirarchies memberskeysunique property to True + changing the toppest attribute in this heirarchy mambernamesunique to true solves this problem.

Is this a must then to prevent recalculating indexes on partitions every process update of dimension??



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.

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?

Cube Processing Taking Random Timings every day.....



I have a question which i am facing from long back...

My question is...

our Business System has a cube which is processed daily morning.

It should take around 1.30 hours to Process this cube. But its not the same every day.

I wont bother if it takes a little bit more than that, but its taking different timings every day.

one day its around 2 or 3 or 5 or 7 or sometimes its going to around 10 also.

i am really suprised to see why the same cube on the same server is taking such a huge difference in timings everyday.

Can some one Explain me what i need to do to make the timings not to go too long.


Dimension Processing Problem Using AMO


Hi Guys


Got a problem creating cube using AMO.

I am using a table which holds the dimensions and measures I want in my cube.



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