cancel
Showing results for 
Search instead for 
Did you mean: 

Online document for MDX of BPC

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (1)

Answers (1)

Former Member
0 Kudos

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-b32ffe04...

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-96149969...