Allowing Measure to Ignore Slicer Filter

[i_am_john]

I have a fairly simple report using Cognos 11 report with a SSAS cube data source. I have a query that has a couple of slicers on it; one for the territory and one for dates (between 2 dates).

For most of the measures in the list, I want the slicers to apply, but there is one I want to ignore the date filters so I get life-to-date values.

My first attempt was to create a calculated measure using the root() MDX function in the SSAS cube. This works when I query the data directly from the cube using MDX, but it does not return any values when I pull it into my Cognos query.

Could I build a calculated measure in Cognos to do this?

[MFGF]

I have a fairly simple report using Cognos 11 report with a SSAS cube data source. I have a query that has a couple of slicers on it; one for the territory and one for dates (between 2 dates).

For most of the measures in the list, I want the slicers to apply, but there is one I want to ignore the date filters so I get life-to-date values.

My first attempt was to create a calculated measure using the root() MDX function in the SSAS cube. This works when I query the data directly from the cube using MDX, but it does not return any values when I pull it into my Cognos query.

Could I build a calculated measure in Cognos to do this?

Hi,

Depending on how your measure is calculated, you could perhaps try using a completeTuple() function in your expression to specify exactly what member combinations are being used in the calculation (ie overriding the slicer)? Not sure if this will work for you, but it might be an avenue you can explore?

Cheers!

MF.

[i_am_john]

Thanks MFGF! The completeTuple function did the trick. I don't know how that function didn't come up in my googling.

https://www.ibm.com/support/knowledgecenter/SSEP7J_10.1.1/com.ibm.swg.ba.cognos.ug_md.10.1.1.doc/c_olap_completetuple.html#olap_completetuple

completeTuple([Measure I wanted LTD], currentMember([Cube].[DateDim].[CalendarDate]))