INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

MDX filter on column value ?

MDX filter on column value ?

(OP)
Hi I have a cube that looks like so:

CODE

<Dimension name="Customers">
    <Hierarchy hasAll="true">
        <Level name="Customer Group" column="CUST_GROUP" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
        </Level>
        <Level name="Customer" column="PARENT_ID" nameColumn="PARENT_CUST_NAME" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never" ordinalColumn="PARENT_CUST_NAME">
        </Level>
        <Level name="SubCustomer" column="CUSTOMER_ID" nameColumn="CUSTOMER_NAME" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
            <Property name="Customer Name" column="CUSTOMER_NAME" type="String">
            </Property>
        </Level>
    </Hierarchy>
</Dimension>

and I want to write and MDX query to select only data relating to member with PARENT_ID value of 20222

.. Something like:

CODE

select NON EMPTY { [Measures].[Total Value] } ON COLUMNS,
   NON EMPTY {[Product].[All Products].Children } ON ROWS
from [Sales]
where [Customers].[All Customerss].[CR].value[20222]

At the moment, the square brackets represent the value of nameColumn ... but I want the actual column filed.

 

RE: MDX filter on column value ?

I think it should be

select NON EMPTY { [Measures].[Total Value] } ON COLUMNS,
   NON EMPTY {[Product].[All Products].20222 } ON ROWS
from [Sales]
where [Customers].[All Customerss].[CR]

Ian

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close