Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Error while processing OLAP Cube

Posted on by 32

Hello,

I've got some problem while processing a cube on analtsis services.

I've got 2 cubes that were working but, we needed to extend the NameAlias.

So what I did. Extended our report tables to match the longer NameAlias, refreshed the Ds in cube project, deployed and ... 2 scenarios for 2 cubes

- one cube process successfuly, but trying to open it on excel takes 15-20 min and ends with errors that it cant refresh the data.

- te second cube left me several dimension attribue errors

////

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

Errors in the OLAP storage engine: An error occurred while the 'CATEGORYNAME' attribute of the 'Kw Prod Route Trans' dimension from the 'AX365_ProdRouteTrans' database was being processed.

OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_prodroutetrans_view', Column: 'COSTGROUPID', Value: ''. The attribute is 'COSTGROUPID'.

# Edit 1.

Creating a new excel with connection to the processed cubes end succesfully. Only the old excel with all filters etc. can't refresh.

  • ToddB Profile Picture
    ToddB on at
    RE: Error while processing OLAP Cube

    Hi Radek,

    Thank you for posting that creating a new excel resolved the issue.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans