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

How retrieve number of members in a sublevel of hierarchy

Started by SimoCogn, 26 Nov 2009 09:48:27 AM

Previous topic - Next topic

SimoCogn

Hi all,
i have a question about how to calculate the number of items (not null) that are contained in a hierarchy level:

for example i have the hierarchy TIME:
Time:
  year
  quarter
  month
  day

I use it in a crosstab:
in the rows i put some measure and in the column i put Quarter level and , nested, month level (i want to visualize both quarter and monthly detail of the measure in the row of the crosstab)

The problem is how to retrieve the number of month for each quarter that are not null:
for example , my report time period is only 1 year, from January to December, but in each quarter some months are empty of value (es only January is present in the 1 quarter, only April is present in the 2 quarter and so on...) (see later)

Q1:
  Jan
Q2:
  Apr
Q3:
  Aug
  Sept
Q4:
  Oct
  Nov
  Dec

In this example, i want to retrieve (using a DataItem) a number that is equal 1 for Q1, 1 for Q2, 2 for Q3 and 3 for Q4

Someone can help me ?
Tanks

Sim