cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR OLAP Process Application

monica_marquez2
Participant
0 Kudos

Hi all!

This is our problem, when i try to process my application called "Finance", it always fails and appears the following error message:

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_tblFactFinance', Column: 'MARCA',

Value: 'MARCA.GRUPO_ESTDST'. The attribute is 'Marca_H1_ID1'

MARCA is a Dimension.

Could anybody say me what is happening?

The same issue is happening when we optimize Finance aplication.

Thanxx

Accepted Solutions (0)

Answers (3)

Answers (3)

monica_marquez2
Participant
0 Kudos

Thanx!

Former Member
0 Kudos

Hi Monica,

I have faced this kind of problem earlier. This is happening due to some invalid records in your application.

Are you able to optimize your application? You run the below command on all the 3 fact tables - FACT, FAC2, and FACTWB

select * from tblfactFinance where MARCA = 'NULL'

Hope this helps.

monica_marquez2
Participant
0 Kudos

Hi all!

We havent any Marca='NULL' in DB.

We have tried to restore a AppSet with SAP-> Server Manager, but we get an error:

"CANNOT OPEN BACKUP DEVICE D:'foldename. OPERATING SYSTEM ERROR 5 ( ACCESS IS DENIED)"

My user has all permissions.

Any suggestion is welcome!

Thanxx

Former Member
0 Kudos

Hi Monica,

Are you able to optimize your application? What error are you getting?

PatrickFavre
Advisor
Advisor
0 Kudos

Hi,

Try to see if SAP note number 1391999 can help you.

Kind Regards,

Patrick