October 23, 2008 at 8:30 am
Hi,
I have an MDX query, in which I'm filtering the data based on a where clause and it works fine.
SELECT {[Measures].[A],[Measures].} ON COLUMNS,
{[Dim1].[Hierarchy].Children} ON ROWS
FROM
[CUBE]
WHERE
{[Dim2].[Date].[2007-12-31]}
Now I have modified the filter in the where clause of my query to following:
SELECT {[Measures].[A],[Measures].} ON COLUMNS,
{[Dim1].[Hierarchy].Children} ON ROWS
FROM
[CUBE]
WHERE
{[Dim2].[Date].[2007-12-31] OR [Dim2].[Date].[NULL] }
This query returns the following exception:
Mondrian Error:No function matches signature ' '
any suggestions....
Thanks,
Raj
October 31, 2008 at 12:35 pm
Hi,
replace OR with , (comma).
[font="Arial"]Tomislav Piasevoli[/font][font="Arial Narrow"] - Business Intelligence Specialist - [/font]http://www.softpro.hr
October 31, 2008 at 1:38 pm
Hi Tomislav Piasevoli,
Thanks for your reply.
I have replaced 'OR' with comma (,) and its giving me a different error. Modified query looks like:
SELECT {[Measures].[A],[Measures].} ON COLUMNS,
{[Dim1].[Hierarchy].Children} ON ROWS
FROM
[CUBE]
WHERE
{[Dim2].[Date].[2007-12-31],[Dim2].[Date].[NULL] }
and the error is: WHERE clause expression returned set with more than one element.
Thanks,
Raj.
October 31, 2008 at 4:25 pm
OK, I think I know what you need.
WITH MEMBER [Dim2].[Date].[MM]
AS
' Aggregate( { [Dim2].[Date].[2007-12-31], [Dim2].[Date].[NULL] } ) '
SELECT
{ [Measures].[A], [Measures]. } ON COLUMNS,
{ [Dim1].[Hierarchy].Children } ON ROWS
FROM
[CUBE]
WHERE
( [Dim2].[Date].[MM] )
Something like that. You should make an aggregate of two members and then put that multiple member (MM) aggregate in slicer.
[font="Arial"]Tomislav Piasevoli[/font][font="Arial Narrow"] - Business Intelligence Specialist - [/font]http://www.softpro.hr
November 4, 2008 at 11:38 am
Thanks Tomislav Piasevoli, for your reply.
When I changed my query to
WITH MEMBER [Dim2].[Date].[MM]
AS
' Aggregate( { [Dim2].[Date].[2007-12-31], [Dim2].[Date].[NULL] } ) '
SELECT
{ [Measures].[A], [Measures]. } ON COLUMNS,
{ [Dim1].[Hierarchy].Children } ON ROWS
FROM
[CUBE]
WHERE
( [Dim2].[Date].[MM] )
it throws the following error:
Mondrian Error:Hierarchy for calculated member '[Dim2].[Date].[MM] ' not found
Thanks,
Raj
April 25, 2017 at 4:16 am
IF I want use OR condition then What I have to Do ? Following query give me error : No function matches signature '<Member> OR <Member>'.
WITH
SET [~ROWS] AS
{[Location_Cluster.default].[Location_Cluster].Members}
member [Date].[Rang] as
'Aggregate(([Date].[End_Date].[2017-01-28]:[Date].[End_Date].[2017-01-28]))'
member [Taxonomy].[Name] as
'Aggregate([Taxonomy].[Taxonomy_ID].[3] or [Taxonomy].[Taxonomy_ID].[178])'
SELECT
NON EMPTY {[Measures].[Total_Quantity], [Measures].[Total_Margin], [Measures].[Location_Count]} ON COLUMNS,
NON EMPTY [~ROWS] ON ROWS
FROM [APCS_SALES_CUBE] Where ([Date].[Rang],[Cluster.Cluster_Id].[3],[Taxonomy].[Name],[Company.Company_Name].[Compnay_Name].[2])
If I replace OR with , then it will work, but I want OR condition.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy