Calling of Previous Year Values Using Cube

[ajhuzky]

Hi Everyone.

needed help on this. i am currently using Cognos 8.3 for building reports. i have created a data item for my current year which is [year] = ?pr_year? and previous year as [year] = ?year? - 1

so far when validating the data item, i don't have any error on it. when the data items were dragged in the report layout then after validation, i am encountering this error:

QE-DEF-0459 CCLException
OP-ERR-0025 The following OLAPPlanner internal error occurred: 'OPASSERT(this->GetItem()->GetMetaItem()->GetDimensionType() == OPMetaItem::DimensionType_Measure) in OPValueSet::AddMeasureValueSet() at OLAPPlannerValueSet.cpp:1930'.

hope somebody can help me on this.  ;)

thanks,

ajhuzky

[robben_2009]

you can use MDX functions to get relative date.
you can get data item named [current year] .expression :[YEAR]->?par_year? ,
and another data item named [previous year].expression :prevMember([current year])