What has changed for OLAP Universe in BOXI3.1 SP2

[Former Member]

All,

I would like to understand what has changed in BOXI3.1 SP2 in comparison with BOXI3.1 base version for OLAP universes.

We design Universe on top of MSAS 2005 cubes and create webi reports.

Based on BOXI3.1 SP2 what's new document- the enhancements seem to affect the Universe Designer- providing a developer with more control and options.

I am interested in learning if the release has any features that improves performance of BO against MSAS cubes.

Any feedback would be much appreciated.

Edited by: ramaks on Dec 11, 2009 11:02 PM

[Former Member]

Hello,

1. Input Controls

2. You can see MDX query generated.

3. Query on Query

4. BI Servises

and for the rest do a search on Help:sap.com with keywords XI31_SP2_whats_new.

Thank You!!

[Former Member]

Hi,

Here is the list of feature we have added in SP2 for OLAP universes:

<li>Definition and Where editors enabled

<li>Prompt editor

<li>MDX dictionary

<li>New parameters and controls at universe generation time

<li>Refresh Structure (aka Universe Update or Universe Life Cycle Management)

<li>Universe SDK enhancements.

You will find in attachment a PDF that describes the enhancements.

Regards

Didier

[Former Member]

Didier, I read on ealier post where is was suggested by you that there have been performance gains for MS OLAP queires (maybe other OLAP too...) on top of a BO Xi 3.1 sp2 universe over ealier universes. Do you have any benchmarks or any other information about these improvement to help folks decide whether it makes sense to use OLAP cube to improve performance or to use other strategies including developing a relational aggregate data layer?

THankyou.