Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

big_dreams
Contributor III

SAP BPC object not visible

Hello everyone,

Just wanted to know is there any limitation of SAP connector with SAP BPC object.

I am trying to fetch query using BEX query connector. I can fetch all fields from except field which derive from BPC.

Is there any setting we need to do in sap side or qlik sense connector?

Please assist me, its urgent.

Regards,

1 Reply
balabhaskarqlik
Honored Contributor

Re: SAP BPC object not visible

Check these areas:

https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Clients/SAP-BEx-connec...

Qlik Support look at the matter and concluded it is a limitation in the Bex- connector:

There is a limitation in SAP that sets the maximum number of drilldown characteristics in a BEx report to 49. This means that the number of displayed characteristics can be maximum 50 but there can be additional free characteristics in the report. In the select window for the QV BEx Connector the characteristics and the free characteristics are listed together under Dimensions. Therefore it is possible to select more than 49 characteristics for the QV script and thereby cause the extraction to fail.

An alternative or workaround could be to extract a maximum of 49 dimensions (characteristics) for each extraction and store each result in different QVDs. Then JOIN and/or CONCATENATE data from the different QVDs. The key figures are not concerned with this limitation i.e. for each extraction you can extract a good number of key figures.

BEX has a limitation of 2 million cells per report. However, you can create a larger query. Try to follow some steps below to improve the extraction.

1. in the connection string, increase timeout "Timeout=3600". This will hold the connection for a longer period of time. The standard time settings is '1000', or 10 minutes.

2. Remove the total rows from all characteristics. This might reduce to half the size extract.

3. Remove filters and restrictions from Default Values area and place them into Characteristics Restrictions. Filters and restrictions under Default Values are still buffering unnecessary data into the server memory,

4. If possible, ask to the BI admin, to increase the server memory for buffering.

5. All fields under the Free Characteristics are buffered as well. Remove all unnecessary dimensions.

Community Browser