cancel
Showing results for 
Search instead for 
Did you mean: 

Dimension Names - Meaning of extensions!?

Former Member
0 Kudos

Hi,

I'm relatively new to MDX, though I'm experienced in multidimensional databases, SQL, ... and got a (simple?) problem:

I got problems for an mdx - statement that normally is working, but when applied to some special cubes it throws errors - the only difference are the dimension names:

Working: SET itemcomp_1 Set AS '{ FILTER( { 72HXXORV7R1FCXO3KUH0IDGPF.MEMBERS }, COUNT(72HXXORV7R1FCXO3KUH0IDGPF.CURRENTMEMBER.CHILDREN ) = 0) }'

Not Working: SET pr_test2dim2 Set AS '{ FILTER( { 0CS_ITEM <22 blanks> Z0BS.MEMBERS }, COUNT( 0CS_ITEM <22 blanks> Z0BS.CURRENTMEMBER.CHILDREN ) = 0) }'

Other examples for non-working dimension names are:

0CS_ITEM <22 blanks> Z0BU_EBIT

0CS_ITEM <22 blanks> Z0BU_NOTES

0CS_ITEM <22 blanks> Z0NOTES

0CS_ITEM <22 blanks> Z0PL

So the statements don't work if there are blanks inside the dimension names!?

- I don't know if these dimension names in my (automatically created - by a 3rd party app -) statement are the "real" dimension names, or if the part after the 22 blanks is some kind of "specification" or another kind of command!?

- What could these additional blanks + names mean if they aren't the dimesions name? Some kind of hierarchy-setting?

I'm executing these commands with MS ADOMD via Visual Basic.

Could there be some restriction concerning the dimesion names?

Thankful for every help,

greets Robert

PS: I added "<22 blanks>" instead of real 22 blanks because the forum cuts it

Edited by: Robert Vierlinger on Jan 3, 2008 1:13 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Robert,

If you are using BW the attributes

0CS_ITEM <22 blanks> Z0BU_EBIT

0CS_ITEM <22 blanks> Z0BU_NOTES

0CS_ITEM <22 blanks> Z0NOTES

0CS_ITEM <22 blanks> Z0PL

In MDX you can write like this

[0CS_ITEM__Z0BU_EBIT]
[0CS_ITEM__Z0BU_NOTES]
[0CS_ITEM__Z0NOTES]
[0CS_ITEM__Z0PL]

I hpope this help you.

Former Member
0 Kudos

Hi Robert,

If you are using BW the attributes

0CS_ITEM <22 blanks> Z0BU_EBIT

0CS_ITEM <22 blanks> Z0BU_NOTES

0CS_ITEM <22 blanks> Z0NOTES

0CS_ITEM <22 blanks> Z0PL

In MDX you can write like this

[0CS_ITEM__Z0BU_EBIT]
[0CS_ITEM__Z0BU_NOTES]
[0CS_ITEM__Z0NOTES]
[0CS_ITEM__Z0PL]

I hpope this help you.