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

Problem with a year/month line graph

Started by James_Bonnell, 23 Sep 2010 12:54:06 PM

Previous topic - Next topic

James_Bonnell

I'm using Cognos 8.4.1, in Report Studio, trying to get a Line Chart to work right.

Here's what I have:

Transformer Model with Account, Department, and Time dimensions.

Current FY ([FISCAL_YEAR] -> ?Fiscal Year?)
Prior FY (prevmember([FISCAL_YEAR] -> ?Fiscal Year?)
CY Actuals (tuple([Current FY], [Total Expenditures], [EXPENSE_AMOUNT]))
PY Actuals (tuple([Prior FY], [Total Expenditures], [EXPENSE_AMOUNT])
Months (children([Current FY]))

What's working: I see the measures on the line graph, and the Months on the X axis.

What's NOT working: the amounts are supposed to vary by month!  Right now, I get a straight line for the entire year (well, sure, it's a tuple of the current year).

I can get one year to work right by filtering, but not current and prior year.

I can do two lists, one for only Current FY and one for only Prior FY, and have the correct totals show by month.  Saving them to Excel, in about 15 seconds I had the exact graph I was looking for.  I'm clearly missing something.  Can anyone give me some suggestions?

James_Bonnell

Well, I didn't figure out how to do what I wanted from the cube... so I did it from our relational star schema.

I'd still like to know what I'm doing wrong on the cube/multidimensional method, but at least I have a working model...