If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Adding Reference Points to a chart using markers

Started by CognosBIUser1, 07 Sep 2017 01:10:46 PM

Previous topic - Next topic

CognosBIUser1

Hi

I have a chart that shows Actual for each months starting from previous Fiscal Year and up to current months in this fiscal year. (Fiscal Year Starts in March)

The requirement is to show a marker on the current month and Previous year current month.

How do I achieve this ?

Some More information :

Environment : Cognos 10.2.2
Relational Model
Report Studio
Chart Type : Clustered Smooth Line

Since the marker index needs to be dynamically calculated depending on the number months we have data for.
I was trying to do some calculation with Category Position using Layout calculation but every time I tried this it throws an error saying :
"RSV-VAL -0032 The following expression if ([MonthlyTrend].[Marker1] >0 ) then (10) else (0) is not valid. If the item exist in but not referenced
in the layout , add it to the property list."

But for a chart there is no properties list and I am not sure why I am getting this error message.



Below are the available  options to use when it comes to markers in Cognos:
 
Number Position : Query Calculation
Data Item Value : Marker1

Category Position : 1) Layout Calculation
                    2) Category Indexes
                    3) Percent on Axis


Which of the above property should I be using ?

New_Guy

Hi,
You can set the properties on the x-axis nodes of the graph. See if this helps. Create a data item a 'if ([MonthlyTrend].[Marker1] >0 ) then (10) else (0)' and add that data item as the property.
Good luck
New guy