Line Chart in Report Author 10.1.2 (NONE-CUBE)

[gosoccer]

Folks,
I have created a line chart without any issues:

X-AXIS: Showing last 30 days
Y-AXIS: Actions that was taken
Measure:A total based on counts generated from the model.

Now, I need to add a marker (AS A DOT) on the line chart that it'll show the current date
on the line itself. So, it'll look like something like the attachment.

When I add a date to the Chart Property-under
Marker-Position = Query Calculation
Data Item Value = [DATE_TIME]
(See Attached).

I get the following error,
RSV-RND-0092
      The datasource must be evaluated to a numeric value.

[anjan]

Hi,

You can use Combination Chart in RS, add all the required measure in the series.

There is a option for each measure to set the chart type, set chart line for the measure which need to showed as marker and set "Show line" properties as no. This setting will show only point on the chart.

I have attached the image for your reference.


Hope this helps.

Regards,

[gosoccer]

anjan,
thx for the reply. The issue I am facing is to show the last date on the line chart.
Please see attached.

The document provided by IBM explains the use of tail but I'm not using cubes
and using DMR.

I just need to get the DOT to appear on the last day of the line chart.

How to Create Sparkline Charts
http://www.ibm.com/developerworks/data/library/cognos/page102.html

:)Thx so much!

[bdbits]

DMR stands for Dimensionally Modeled Relational, so if you use a DMR model your data source would be dimensional. In which case, tail should work just fine. Did you try it and get an error?

[gosoccer]

I am sorry. it is not DMR. I have mis-spoke or a little confused between Relational and Dimensional. It is Relational.
Yes, I tried tail and I get the following error.
tail([DATE_TIME]0
Invalid Coercion ...string to memberset for Date_Time in tail([DATE_TIME])

[gosoccer]

I'm using regular RELATIONAL Data within the Report Author. The tail command doesn't work since this command is for DMR (cube and non-cube)

If someone knows how to tell the Marker to place a DOT on the line associated to the last day of the date_time
presented in the X-AXIS of the graph, I would greatly appreciate it.

I am getting the error when I use the options:
Numeric Position: Query Calculation
Data Item Value: [DATE_TIME]
Category Index 1
See attached!!

Error Raised:
RSV-RND-0092

      The datasource must be evaluated to a numeric value.

     Details
RSV-SRV-0042 Trace back:RSReportService.cpp(756): RSException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(263): RSException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(828): RSException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(277): RSException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(884): RSException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(670): RSException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(292): RSException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(79): RSException:



Thank you so much for your time