Skip to Content
0

OLAP UNV on BEx query limited to 50 dimensions in Webi. But BICS & Relational UNX not. WHY???

May 22, 2017 at 11:15 AM

114

avatar image

Hello Experts.

We created a multiprovider and BEx query on top of it with about 70 characteristics (dimensions) and 100 key figures (measures). Then we created an OLAP universe on top of the BEx query and now we face a limitation of only being able to have a maximum of 50 characteristics in a Webi query.

I recently logged an OSS ticket with SAP and they said it is due to a BW/BEx limitation and you cannot have more than 50 characteristics in one query.

BUT. If this is a BW/BEx limitation, how come I don't have this limitation when creating a report using a Relational UNX or direct BICS connection on the exact same BEx query (IDT)?

SAP referred me to this post but I still don't get why only OLAP is limited and BICS and UNX are not. BICS vs BAPI vs DF Relational Connection

Please help I really want to understand why this is happening. Unfortunately it is not as simple as just using the BICS and UNX universe because I need hierarchy functionality (accessing specific levels as flat objects) in UDT.

We are on NW 7.4 and BO 4.2.

Thanks

Antonette

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Loic DE L'EPREVIER
Jun 06, 2017 at 10:00 AM
0

Hi,

This limitation is indeed enforced by BEx model, you can refer to documentation in page https://help.sap.com/saphelp_nw75/helpdata/EN/f1/0a5625e09411d2acb90000e829fbfe/frameset.htm.

You can use any number of characteristics in the query. Note, however, that the number of characteristics in the drilldown is restricted. An unlimited number of characteristics is permitted in theFree Characteristicsarea. Note, however, that the rows and columns can contain a maximum of 50 - <number of structures> characteristics only.

This rule is valid whether you connect with BAPI UNV Universe or with BICS Direct Access.

If you need to build a Web Intelligence report with objects based on Hierarchy levels, then you may use a function called 'MemberAtDepth' which will let you define same kind of logic that is available with UNV OLAP Universes.

Best regards,

Loic

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thank you Loic

I don't experience the limitation with BICS . . . . that is why this is so confusing.

Antonette

0