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
SAP CUBE BUILDING AND DATA LOAD PROCESS
SAP CUBE BUILDING AND DATA LOAD PROCESS
Victor Noyola
-
- 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
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.
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.