Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a client that has been running a connection to a Dynamics AX Cube. It has been working fine up until now, suddenly over night it has stopped working.
It seems to be connecting to the cube ok through an OLEBDB connection, but it fails with a 'General Error' once it gets to the Select statement.
We have simplified the script to look like this.
LIB CONNECT TO 'Dynamics Ax - Cubes';
LOAD
"[Measures].[Ending amount]" as [Ending amount];
SELECT
[Measures].[Ending amount]
FROM [Inventory value cube]
;
Does anyone have any idea why it has suddenly stopped working.
P.S we are using the MDX generator to create the script and it is connecting and load the data fine.
Thanks in advance for any help.
Cheers
Jon
I found this error by using the SQL Profile, which occurs when Qlik queries the cubes:
XML for Analysis parser: The CurrentCatalog XML/A property was not specified.