I had the same problem with BW where version was 3.5 or something. Working with QlikView support, they gave me a parameter to put in the connection string - something I remember like: LeafNotSupported=1. But this was BW Cube and you are concerned with APO table, so I am sure this will not help you.
What is your APO's BASIS release? You may want to upgrade to 5.5 and see hot it goes.
I would go ahead and open a ticket to QlikView for this problem anyway in parallel.
Hope this helps.
Thanks for the answer.
My APO's Basis Release is 701. I have the transports of SAP Connector 5.3 in the APO System.
Normal 0 21 false false false DE X-NONE X-NONE
1) QT2K900238 (Data extraction)
2) QT2K900101 (User profile)
and I have the SAP connector 5.4 in the Qlikview Server, I downloaded and checked whether 5.5 works but it does not work even for Test connection.
Due you mean to install the transports of 5.5 in SAP?
I will open a ticket with Qliktech on this Regard.
PS: I have Qlikview Desktop clients 9.0.7646.9 and 9.0.7502.8 On the Servers.
Yes the Problem is the compatibility of SAP Connector and the Transports. I switched the SAP Connector to 5.3 and it works. My problem is that the SAP Systems(Other than APO) work with SAP connector5.4 and not with SAP 5.3
For a common connector 5.5 I need to change the transports in SAP (APO) and in other SAP Systems. Otherwise I cannot maintain one common connector in the Server.
I suggest the same and request to go with QVC 5.5 SR3
Bugs corrected in version - 5.5 SR3
• New parameter for Connectionstring; RemoveAllBlanks=0/1 default=0. If used gives possibility
to get "old" behavior where fields in SAP containing only Blank characters got trimmed. The
default behavior leaves one Blank character to be able to distinguish from Null fields.
• Queries with only Characteristics and no Key figures gave no result in BW systems without