Skip to Content
0
Former Member
Oct 29, 2008 at 11:34 PM

Syntax for custom dimensions and measures in a BW Query based OLAP Universe

102 Views

I'm at a client who has setup an OLAP Universe based on a BW Query. The standard objects appear to work as expected.

We are trying to create a simple custom (i.e. restricted) dimension and a custom (i.e. calculated) measure just to see them work and understand the syntax necessary.

We've seen all the documents (for mdx and olap univ) mentioned in various threads and have tried to follow the instructions, but haven't yet had a successful object created that doesn't fail either at parse or at runtime (due to generic XML syntax error).

Does anyone have a couple of simple examples of each of these showing the entire object definition (SELECT area, WHERE area, etc.)? In all cases, if we don't have something defined in the SELECT area, the parse fail; even thought the documents seem to suggest that only placing an XML expression in the WHERE area is necessary...

The examples we are trying attempt the following (ignoring the formatting and the <EXPRESSION> tags we've been trying):

custom dimension => set to a string if two criteria are met i.e.

if (@select(xxx\dim1)="YES";"PASS";"FAIL")

OR

aggregate( {??date??.CurrentMember:??date??.CurrentMember.lead(-2)}, @select(xxx\dim2) )

custom measure => just take the difference of two other measures i.e. @select(xxx\yyy1) - @select(xxx\yyy2)

Thanks, <>R