Join Query: Expression Parsing Error

[Rovinesh]

Hi Experts,

i have a question that i hope that someone can answer for me.

I'm trying to make a join query. Usually I have no problems with that, but with this one i get a QE-DEF-0030 expression parsing error everytime i try to make it.

The two queries i'm trying to join are:
- [Received Orders] With two data items: Date and Count Received Orders
- [Completed Orders] which is another joined with two data items: Last Date and Count Completed Orders.

When i join the two i link them with date.

But i get a expression parsing error.
I Tried every cardinality combination and it stil doenst work.

Can someone please help me,

Thanks in advance,

[blom0344]

What does it say when you check the error details?

[Rovinesh]

Hi blom,

this is the error i get:

QE-DEF-0030

      Expression parsing error.

     Details
DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2013-01-16-09:09:07.145-#82

[blom0344]

Any chance you can scan the cogserver.log on the Cognos server?  How about the date dataitems? Are these the same datatype?

[Rovinesh]

I don't have access to the cogserver.log. About the two date dataitems:

The first is Date with the expression [Database Layer].[ReceiveDate].[Date]
The second is Date with the expression maximum([Database Layer].[ResolveDate].[Date]). This is to get the last date of every order, since  an order has different assignments.

They are both dateTime types

[bi4u2]

Your issue is with the query that you have the maximum calculation. You need to say something to the effect of maximum([Database Layer].[ResolveDate].[Date] FOR ORDER_NO)

[Rovinesh]

Thank You bi4u2!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

i didn't knew you could do that, but it works now, so thank you again!