Home » Applications » PeopleSoft, JD Edwards & Siebel » Using CURRENT_DATE in Reports (Siebel CRM On Demand)
Using CURRENT_DATE in Reports [message #358435] Tue, 11 November 2008 05:37 Go to next message
pauljjhenderson
Messages: 2
Registered: November 2008
Location: Donegal / Sheffield
Junior Member

Hi All,

Im very new to Siebel so please excuse any "silly" questions.

I am trying to create a report that will be run every month, its a simple report which shows name, activity description and date.

I have tried to run the report using:

Date."Fiscal Month" = "CURRENT_MONTH" as a filter but this returns an error.

Is there some syntax that I am missing, it returns an error:
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "CURRENT_MONTH". (HY000)
SQL Issued: {call NQSGetLevelDrillability('SELECT Contact."Contact Last Name" saw_0, Contact."Contact First Name" saw_1, Activity.Description saw_2, Date."Fiscal Month" saw_3 FROM "Activity Analysis" WHERE Date."Fiscal Month" = "CURRENT_MONTH"')}
Re: Using CURRENT_DATE in Reports [message #358462 is a reply to message #358435] Tue, 11 November 2008 08:12 Go to previous message
pauljjhenderson
Messages: 2
Registered: November 2008
Location: Donegal / Sheffield
Junior Member

I managed to find the solution after a bit of digging, here is what i needed to do:

When creating the reports, I chose the Filter for the Month, then:

Add -> Variable -> Session

Then I simply typed in CURRENT_MONTH

And it worked. Hope this helps someone else.
Previous Topic: Connecting to siebel using SiebelDataBean
Next Topic: Deployment Documentation for EBilling/EService/ECommerce
Goto Forum:
  


Current Time: Thu Oct 30 13:00:02 CDT 2014

Total time taken to generate the page: 0.13667 seconds