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

To be charted, the report must contain at least one measure

Started by erics, 20 Feb 2015 11:23:04 AM

Previous topic - Next topic

erics

So, I'm trying to create the simplest of line graphs.
The table has 3 columns, the date, a number (yyyymm), and total in sales.
I've tried creating this as a chart in the report studio, but ended up with an empty studio.
So, to test my data, I put the data in the query studio. In my query studio I see all 3 columns with the proper data. However, when I click to change layout to a chart, I get an error that the report must contain at least one measure. I assumed that the date in yyyymm should me a measure and the total price as well no?
I've tried setting the date both as an identifier and as an attribute, neither works. Am I missing a step in there?

bdbits

A measure should have the Usage in your model set to Fact.
An Identifier is an equivalent to a key column in a database table.
An attribute is just, well, an attribute.

While I suppose if your date is stored as a number, you could treat it as a fact. But that makes no sense. Dates are not measures.