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
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])