Hi All,
I am trying to use the date functions to get the current year in my data item and I get this error when I validate my data item
CURRENT_DATE(), Sysdate() ,Year(date)...etc.. and my source data for the report is package published through TM1.
RSV-VAL -0010 Failed to Load the report specification XQE-CON-0007 XQE error encountered :XTM-CON -0001. An attempt to login to the TM1 server failed. The TM1 error code is : SystemServerNot Found. The TM1 error message is : SystemServerNotFound. Admin host :null Server Name : Null
And if I use Current_date instead of current_date() it returns me the date with out error . Can anyone explain me what is the problem.
Thanks,
Hi,
If I was doing this, I would use the extract() function to extract the year from the current date, ie:
extract(year, current_date)
Does this give you the result you need?
MF.
Yes, that gives me the result, but wanted to know why I am not able to use other date functions.
Thanks,
Because current_date is a Cognos function while the other ones are database specific. TM1 is not Oracle or SQL so you would get an error.
i am facing same problem if we want month in string format(i.e jan) how can i get that
if i use extract(month,current_date),iam getting '1' but instead of 1 i want to show 'jan'
how can i get this?
Thanks,
Karthee
This might help:
http://cognostips.weebly.com/blog/month-name (http://cognostips.weebly.com/blog/month-name)
thanks BigChris,
But it also showing same error.
Thanks,
Karthee
Hi Karthee,
What error are you you getting? Did you see Manu0521's comment:
QuoteAnd if I use Current_date instead of current_date() it returns me the date with out error