What is the difference between BO Designer connect BW QUERY and BW CUBEuFF1F

[Former Member]

HI friend,

What is the difference between BO Designer connect BW QUERY and BW CUBE？

which one is better?

Best regards.

Howard

[Former Member · Accepted solution]

Hi,

OLAP universes provide the same capabilities on top of BEx queries or Infocubes.

However, some features you can define or use in a BEx query cannot be emulated at this stage on, an Infocube, such as:

<li>Security

<li>Structure

<li>Keydate variable

<li>Currency conversion

<li>Navigational attributes

<li>Hierarchy and hierarcy node variable

Moreover, in general, the performance is better when using a BEx query.

So the recommendation for the current release is to use a BEx query.

Regards,

Didier

[Former Member · Accepted solution]

HI Didier,

Thank you.

and BEx Query can control authoritative.

Regards,

Howard.

[Former Member · Accepted solution]

Hi Howard,

You can use autorization variables in SAP BW and maitain the security there, using that you can apply diferent security not only at Infoobject levet you can apply security per BEX Query.

Here is some informaion about BEX and SAP BusinessObjects

BI metadata feature _______SAP OLAP BAPI support level

Characteristics (incl. Time and Unit)_______ InfoCube/BEx Query

Hierarchies_______ InfoCube/BEx Query

Basic Key Figures_______ InfoCube/BEx Query

Navigational Attributes_______ BEx Query only

Display Attributes_______ InfoCube/BEx Query

Calculated Key Figures / Formulas_______ BEx Query only

Restricted Key Figures_______ BEx Query only

Custom Structures_______ BEx Query only

Variables_______ BEx Query only

I hope this help you.

BEst regards,

Fede

[Former Member]

close