Skip to Content
author's profile photo Former Member
Former Member

Online document for MDX of BPC

Anybody know if there is a good online document which use used to study for MDX of BPC, the content of that part in BPC 5.1 administrators' guide is too simple and short.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 08:17 PM

    A couple items; BPC on MS doesn't really need heavy MDX and we try to limit the uses during a design, instead leveraging the script logic coding (which can use MDX) However, the NW version of BPC will leverage MDX more heavily in the future, upon release. The best references I have used are actually from Microsoft. Their web site, if you search, actually has a whole section dedicated to all the statements, examples, and facts for MDX usage. Just Google MDX dictionary at Microsoft.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 08:25 PM

    Hi!

    How to Use MDX Dimension Formulas Article(PDF 451 KB)

    In SQL 2000, AS does not recognize the separate dimensions as a single dimension when considering dimension formulas. In SQL 2005, AS does recognize the separation as a single dimension but consider formulas by hierarchy. These differences have created the need for this document

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/008d665b-94bf-2a10-78b2-b32ffe04ba73

    How to Use BPC Scripting Logic Article(PDF 1 MB)

    BPC scripting logic allows administrators to create calculations that are stored in the database and operate as data changes within the application. This guide covers the language syntax

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80ffae4b-99d5-2a10-4e9f-96149969aabb

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.