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,
What does it say when you check the error details?
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
Any chance you can scan the cogserver.log on the Cognos server? How about the date dataitems? Are these the same datatype?
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
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)
Thank You bi4u2!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
i didn't knew you could do that, but it works now, so thank you again!