How to change MDX for Universe base on Universe

[Former Member]

Dear All,

Our customer has a query about Universe base on MSAS2005.

They can created a Universe and used it for Webi report well.

The following MDX is right.

SELECT

{[Measures].DefaultMember} ON COLUMS ,

ADDCALCULATEDMEMBERS ([Account].[Accounts].[Account Level 01].MEMBERS)

DIMENSION PROPERTIES MEMBER_UNIQUE_NAME, MEMBER_CAPTION ON ROWS

FROM [OpCentre]

Customer want to know how can they create a universe object on the u201CAccountsu201D ."Accounts" should have a full list of accounts under the whole account hierarchy.

They also want to know is there any guideline for creating universe objects other than the default generated objects?

Thanks in advance!

Wayne

Edited by: Wayne Peng on Mar 11, 2009 11:59 AM

[Former Member · Accepted solution]

Neither of the links below seem to work, can you repost with valid URL's please :

OLAP Universes - how to, samples and recommendations

BOBJ on Netweaver BI best practices room

[Former Member · Accepted solution]

Hi,

Here is a link that works, I hope:

<li>[OLAP Universes - how to samples and recommendations|https://wiki.wdf.sap.corp/display/globalregions/OLAPUniverses-howtosamplesand+recommendations]

Here are other useful links:

<li>[Clients and Semantic Layer|https://wiki.wdf.sap.corp/display/globalregions/ClientsandSemantic+Layer]

<li>[Best Practices. Web Intelligence XI 3.x on SAP NetWeaver BI|https://wiki.wdf.sap.corp/display/globalregions/BestPractices.WebIntelligenceXI3.xonSAPNetWeaver+BI]

Didier

[Former Member · Accepted solution]

Sorry Didier, but I still can't access these documents. Is there any reason these documents can not be posted to SDN?

[Former Member · Accepted solution]

Hi

- Open https:
help.sap.com

- Go to SAP BusinessObjects ->All products (see at left hand side pane).

- Select the language required -> Select BusinessObjects XI 3.1 from Release (the third drop down).

- After the list of documents is populated scroll till bottom of the page.

- You would find Using SAP BW in Universe Designer guide there.

- Try downolading it from there.

Or you can also try this [link|http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_sap_olap_universes_en.pdf] to download the guide.

Hope this helps!!!

Regards

Sourashree

[Former Member · Accepted solution]

Sourashree -

I have the doc you mention, but I'm trying to get the 3 documents Didier is trying to provides links to.

Thanks anyway.

[IngoH · Accepted solution]

Here are the SDN Links:

Best Practices:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/008d15dc-f76c-2b10-968a-fafe5a12...

OLAP Universes How to:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Other material:

/people/ingo.hilgefort/blog/2008/11/19/businessobjects-integration-with-sap-netweaver-bi--technical-material

Ingo

[Former Member]

Hi

Please refer to the user guide of Using SAP BW in Universe Designer[here|http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf]

Hope this helps!!

Regards

Sourashree

[Former Member]

Hi Wayne,

You can find useful information and documentation related to OLAP universes and especially to customize objects using MDX here: [BOBJ on Netweaver BI best practices room|https://portal.wdf.sap.corp/irj/portal?navigationtarget=collaborationconnector://portal_content/com.sap.ip.collaboration/Rooms/a0e6dc62-2c0f-2b10-f4ab-fecf87cebffd/workset&windowId=WID1222154242607&NavigationContext=navurl://7f6f53bebf57a991a023fca93dc3f9cd]

To give you a brief description on what it is possible, you can cerate custom calculated measures using MDX.

You can also use designer functions such as @Select or @Prompt to make universes more flexible.

Didier

[Former Member]

Hi Didier,

Thanks for your information and our customers also looking similar type of requirement. The above link is not working properly and it doesn't shows any information.

Can you kindly have a look and advice....

Regards,

Preetham

[Former Member]

Hi,

The link I provided is a public link if you have access to SAP SDN.

You can also try this link [OLAP Universes - how to, samples and recommendations|https://portal.wdf.sap.corp/irj/go/km/docs/room_project2/cm_stores/documents/workspaces/e0722765-2c0f-2b10-7eb0-f40944b3d00b/olap%20universes%3a%20how%20to%2c%20samples%20and%20recommendations.doc]

Didier

[Former Member]

Hi Didier,

The above link also not working, can you kindly have a look and let us know so that we will get a chance to go through another best document from SDN.

Regards,

Preetham

[Former Member]

I can't open the links you provided either and I have an SDN logon. I'd love to review the material as we're struggling to get some Top N queries working against a universe built on a BEx query.

Any other way to share these?

[former_member539471]

hey ,

did u get to download what diader sent?

pls reply.

thanks