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

Parallel Period Returns Nothing

Started by antoxic87, 06 Jul 2012 05:05:13 AM

Previous topic - Next topic

antoxic87

I have one query with few items. one of them defined like that:

tuple(
currentMember([Cube_PlannedInspections_v1].[Calend ar Date].[Calendar Date(All)]);
[Measure1])
-
tuple(
parallelPeriod ( [Cube_PlannedInspections_v1].[Calendar Date].[Calendar Date(All)]].[Year]
;1;currentMember([Cube_PlannedInspections_v1].[Cale nd ar Date].[Calendar Date(All)]));
[Measure1]
)


another - like that:

parallelPeriod (
[Cube_PlannedInspections_v1].[Calendar Date].[Calendar Date(All)].[Year];1;currentmember([Cube_PlannedIns pections_v1].[Calendar Date].[Calendar Date(All)]))

The first expression returns right value and the second returns nothing. Why? How I can display real parallel period in report?