C O G N OiSe - the COGNOS community  
10 Mar 2010 09:52:38 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: February 8th, 2010 - COGNOiSe.com passes 10,000 registered users.
 
   Home   Help Search Calendar Login Register  
Pages: [1]
  Print  
Author Topic: How retrieve number of members in a sublevel of hierarchy  (Read 104 times)
SimoCogn
Full Member
***

Forum Citizenship: +0/-0
Offline Offline

Posts: 6


« on: 26 Nov 2009 08:48:27 AM »

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
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!