Hi

I am new to MDX so please forgive the simplicity of this issue.

I have created a MDX query using the following code:

SELECT { [Time].DEFAULTMEMBER } ON COLUMNS ,

{ [BOM production].[All BOM Productions].CHILDREN } ON ROWS

FROM [Production]

WHERE ( [Measures].[Production Qty Started] )

Now I need to filter the results by a Member property. This member
property is a datetime field.

I am trying

SELECT { [Time].DEFAULTMEMBER } ON COLUMNS ,

{Filter([BOM Production].[Prod No].Members,
([BOM Production].CurrentMember.Properties("Created Date")) >
01/01/2000 )} ON ROWS

FROM [Production]

WHERE ( [Measures].[Production Qty Started] )

This is giving me an error. Any ideas?

Your help is much appreciated.

Hi,

If yu can tell what error message you are getting, that would be helpful in
solving the problem you are facing.

In the meantime you can also try enclosing the date in double quotes. i.e.

{Filter([BOM Production].[Prod No].Members,
([BOM Production].CurrentMember.Properties("Created Date")) >
"01/01/2000")} ON ROWS

Hope this helps you.

Thanks
Charu

"midi" wrote: