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

Calculation of single members of the set

Started by Mart, 02 Oct 2012 02:39:46 AM

Previous topic - Next topic

Mart

Hi,

I want to ask you for an advice.

I've got report, where I calculate some measures within periodsToDate set.

Like this:
-----------
<code>
total ([Revenue] within set [YTD_period])
/
total ([Opportunity] within set [YTD_period])
</code>

Where set expression looks like:
-----------
<code>
periodsToDate ([GSPT_Cube_Danzsale].[Period].[Period (All)].[Year],[GSPT_Cube_Danzsale].[Period].[Period (All)]->?p_period?)
</code>

In the same query, I'm showing the values for the whole previous year:
-----------
<code>
children (prevMember (parent([GSPT_Cube_Forwin_Mix_Country].[Period].[Period (All)]->?p_period?)))
</code> as [PY_period]

It's all good, when I want to show year to date values of the sets members thanks to Total function, but my problem is to count the measure for each member of the sets "separately" to show monthly values in the sets.

Do you have any ideas please?

Thanks,
Martin