SAP CUBE BUILDING AND DATA LOAD PROCESS

Post Reply
User avatar
vicsense
Posts: 3
Joined: Thu Jul 03, 2008 4:26 pm
Location: MEXICO

SAP CUBE BUILDING AND DATA LOAD PROCESS

Post by vicsense »

I have a TI process that updates a cube and load data, but some times it works fine, and most of the times the process is aborted and the log shows the next message:
"[0BUS_AREA].[001]","[0CHRT_ACCTS].[CMEX]","[0COMP_CODE].[01]","[0GL_ACCOUNT].[CMEX6105100001]","[0CALMONTH].[200701]","[0FISCPER].[K22007001]","[0FISCVARNT].[K2]","[0CURRENCY].[MXN]","[Measures].[0BALANCE]","[0CALMONTH2].[All]","174716.57",Data Source line (1) Error: Data procedure line (7): Wrong Number of Dimension Elements.

But i have all these dims in my cube, as I said before, it worked several times before...

Also I'm testing this process changing the number of accounts that is pulling from SAP BW, and if I choose more than 19 it stops working... and displays any of the next messages:
Error: Data procedure line (0): MDX query execution failed - HRESULT: 80004005, Minor Code: 0, Source: MDrmSap.2, Description: An unexpected internal provider error occurred.

Error: Data procedure line (0): MDX query execution failed - HRESULT: 80004005, Minor Code: 0, Source: MDrmSap.2, Description: Comando MDX no válido en 0GL_ACCO UNT

We are making some test to connect to SAP BW and import the cubes and information to TM1, but it is not working as expected.

Any Ideas or suggestions?

TIA

Victor
Victor Noyola
John Hammond
Community Contributor
Posts: 300
Joined: Mon Mar 23, 2009 10:50 am
OLAP Product: PAW/PAX 2.0.72 Perspectives
Version: TM1 Server 11.8.003
Excel Version: 365 and 2016
Location: South London

Re: SAP CUBE BUILDING AND DATA LOAD PROCESS

Post by John Hammond »

Victor

I have just had a similar error and it is spurious. TM1 has got its knickers in a twist. Unload the cube and you will stop the error occurring.
Post Reply