Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 21 Apr 2014 02:46:49 PM

Title: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: gosoccer on 21 Apr 2014 02:46:49 PM
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.





Title: Re: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: anjan on 22 Apr 2014 08:58:27 AM
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,
Title: Re: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: gosoccer on 22 Apr 2014 02:48:06 PM
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!
Title: Re: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: bdbits on 22 Apr 2014 05:32:33 PM
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?
Title: Re: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: gosoccer on 22 Apr 2014 09:30:49 PM
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])
Title: Re: Line Chart in Report Author 10.1.2 (NONE-CUBE)
Post by: gosoccer on 24 Apr 2014 10:03:26 AM
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
Text only | Text with Images