Maximum No. of Drilldown Characteristics - Anyway to to overcome

[Naga_P]

Hi,

We are on 3.0B vesion of the BW system, using 3.5 Frontend for BEx. In the BEx, during the query generation, we are not allowed to have more than 50 chars / KFs in the drilldown for the query. The is explained in OSS note : 540641..

Would anybody know of a way to overcome this limitation. We need a query with about 55 chars / KFs in the drilldown.

Thanks in advance for any insights.

Naga

[Former Member · Accepted solution]

Hi Naga,

You may have 49 drilldown characteristics in a query with one structure and 48 with a query with 2 structures. These are limits from the OLAP engine which can not be changed.

A possible workaround is to use display attributes. Attributes allow to present the required info in a separated drilldown column (row) and from the other side are not really considered as characteristic.So you may get more than 50 levels in a query.

Best regards,

Maxim