Share
Report
76Hello,
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.
All responses (
Answers (
