The General ledger cube cube either does not exist or has not been processed.

(0) Share

Report

Posted on by Community Member

I performed the installation of a base AX2012 R3 and applied the Microsoft Demodata, installed the Enterprise Portal and did deploy cubes. Some errors occurred during the deployment wizard.

I Performed the instalation of ax2012 R3 and I applyed Demodata Contoso, Analysis, Report and EP.

I need help with the EP, cubes are generating errors in EventViewer. Installed AX2012 R3 and added the Microsoft Demodata during the wizard to deploy cubes errors occurred and the process by SQL as well. The error below occurs, but General Ledger cube was processed. How can I solve this?

Querying Server: AX4BVENDAS, Database: Dynamics AX initial

Select {KPIValue('Inventory turnover'),KPIGoal('Inventory turnover'),KPIStatus('Inventory turnover'), KPITrend('Inventory turnover')} on Columns from [General ledger cube] where ([Company].[Company].&[BRMF],(STRTOMEMBER('[Transaction date - fiscal calendar].[Year quarter period month date].[Date].&[BRMF]&[' + vba!format(vba![date](), 'yyyy-MM-dd') + 'T00:00:00]')).Parent.Parent)

The General ledger cube cube either does not exist or has not been processed.

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.CreateKPIRow(Indicator indicator, Int32 indicatorIndex, String company, String currencyCode, String currencySymbol, String cssClass, NumberFormatInfo numInfo)

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Verified answer

Guy Terry 28,924 Moderator on at

Like (0)

Report

It says the cube does not exist, or has not been processed. Let's hope its the latter!

To process the Analysis Services Database, open a copy of SQL Server Management Server. Set it to connect to an Analysis Services Database, and connect to your SSAS database. Find the database in the panel on the left, right click on it and choose Process.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The cube was processed, that's the problem.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

At Sys Admin -> Setup -> Business intelligence -> Analysis Services -> Analysis servers, do you have an OLAP server defined for the partition you are using (the partition called 'initial')?

Is the server name correct? Is it the default for the partition? On the 'OLAP databases' tab, is the right database (on that OLAP server) selected as the Default?

In SSMS, you can expand down to the GL Cube. Can you browse it OK? Does it work here? Do the KPIs work?

Was this reply helpful? Yes No
Verified answer

Sathish_Chinnappan 1,318 on at

Like (1)

Report

Hi guy terry,

I having error like:

the general ledger cube cube either does not exist or has not been processed

i have only one cube (demand forecast accuracy cube) in Demand forecast Accuracy Initial db.

Any help would be appreciated.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Sathish,

Have you deployed the default cubes?:

technet.microsoft.com/.../dd309683.aspx

If yes, what are you doing to see the error?

Was this reply helpful? Yes No
Sathish_Chinnappan 1,318 on at

Like (0)

Report

Hi guy,

i tried to deploy cubes and i checked the process check box. It shows error like:

Internal error: The operation terminated unsuccessfully.

OLE DB error: OLE DB or ODBC error: Login failed for user 'CETAS\AX-SERVER$'.; 28000.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Dynamics Database', Name of 'Dynamics Database'.

Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'DATE', Name of 'Date' was being processed.

Errors in the OLAP storage engine: An error occurred while the 'Year' attribute of the 'Date' dimension from the 'Demand Forecast Accuracy initial' database was being processed.

Server: The current operation was cancelled because another operation in the transaction failed.

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report

Hi Sathish,

Can you connect to Analysis services database in SQL server management studio from the user you mentioned above? It seems that the user does not have access to the Analysis services database. Go to SQL server management studio and try to connect with server type 'Analysis services'.

Please verify and let me know if you have further queries.

Thanks,

Baber.

Was this reply helpful? Yes No
Sathish_Chinnappan 1,318 on at

Like (0)

Report

Hi baber,

Yes i can connect Analysis server and also i gave permission to the database.

I reinstalled SSAS.

now im facing different error:

The following system error occurred: A specified logon session does not exist. It may already have been terminated.

Was this reply helpful? Yes No
Sathish_Chinnappan 1,318 on at

Like (0)

Report

Hi,

can anyone got solution for this?

Was this reply helpful? Yes No