Skip to Content
0
May 22, 2017 at 11:15 AM

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

490 Views

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