on 01-03-2008 12:06 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.