BO Reports on SAP BW

[former_member184597]

Hello,

I have few queries regarding integrating BOBJ with SAP BW. We have WebI reports on top of BEx queries made in SAP BW 7x.

1.I know that MDX is used to access data in OLAP Cube(BW Infocubes) but why do we need to encapsulate MDX expressions for conditions(Universe filters) in XML ? We dont use XML in case of normal objects like Measures.

2.Universe Dynamic Parameters(Last tab) : Are they be applicalbe for OLAP Universes as well. Why i am asking this is even if i set FORCE_SORTED_LOV to Yes the LOVs displayed in WebI are not sorted ? Are these parameters are not applicable if OLAP_UNIVERSE parameter is set to Yes.

- Vamsi Ch

[IngoH · Accepted solution]

Hi,

1.I know that MDX is used to access data in OLAP Cube(BW Infocubes) but why do we need to encapsulate MDX expressions for conditions(Universe filters) in XML ? We dont use XML in case of normal objects like Measures.

>> Because the Universe uses XML syntax to describe the actual request

2.Universe Dynamic Parameters(Last tab) : Are they be applicalbe for OLAP Universes as well. Why i am asking this is even if i set FORCE_SORTED_LOV to Yes the LOVs displayed in WebI are not sorted ? Are these parameters are not applicable if OLAP_UNIVERSE parameter is set to Yes.

>> Are you referring to filters based on variables from the BW query or filters manually created ?

Ingo

[former_member184597 · Accepted solution]

Hey Ingo,

Thanks for your reply.

So universe uses XML to interact with ODA/OLAP Engine. So which engine converts it into XML when there are only RESULT (only SELECT clause ) objects in report without any condition objects.

I mean both the filter types and in fact i expect them to behave same as they meant for same purpose. Are there any differences between them ?

- Vamsi Ch

[IngoH · Accepted solution]

Hi,

what are you trying to do / achieve

Ingo

[former_member184597 · Accepted solution]

Hello Ingo,

With respect to LOVs, i want to show them sorted by default for user. So thought of using FORCE_SORTED_LOV but still in vain.

- Vamsi Ch

[former_member184597 · Accepted solution]

Hello,

So can i consider it as a bug in OLAP Universes. How can i raise this to SAP Team for fixing it ?

- Vamsi Ch

[IngoH · Accepted solution]

Hi,

sorted on "what" ? the list of values has a key and a description.

Ingo

[former_member184597 · Accepted solution]

Hello,

Yes i we have a key and description. We have a product dim and as part of prompt i want to show all product names sorted so that user can select easily. Is there any way out ?

- Vamsi Ch

[IngoH · Accepted solution]

Hi,

the list is automatically sorted by the key and you can for example also use the feature of delegated search to enable a search in the complete list.

Ingo

[former_member184597 · Accepted solution]

Hello Ingo,

We have delegated search enabled for long lists only. But few LOVs have limited number of entires and want to show them sorted based on description like Product Name. Can we do that ?

- Vamsi Ch

[IngoH · Accepted solution]

Hi,

the list is based on the key. if you want to change that you would have to change the definition of the LOV.

Ingo