C O G N OiSe - the COGNOS community
10 Mar 2010 09:52:38 AM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
:
February 8th, 2010
- COGNOiSe.com passes 10,000 registered users.
Home
Help
Search
Calendar
Login
Register
C O G N OiSe - the COGNOS community
>
Legacy Business Intelligence
>
COGNOS ReportNet
>
Report Studio
>
How retrieve number of members in a sublevel of hierarchy
Pages: [
1
]
« previous
next »
Print
Author
Topic: How retrieve number of members in a sublevel of hierarchy (Read 104 times)
SimoCogn
Full Member
Forum Citizenship: +0/-0
Offline
Posts: 6
How retrieve number of members in a sublevel of hierarchy
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
IBM Cognos 8 Platform
-----------------------------
=> COGNOS 8
===> COGNOS 8 Administration
===> COGNOS Connection
===> Framework Manager
===> Report Studio
===> Query Studio
===> Analysis Studio
===> Go! Dashboard
===> BI Modeling (Transformer)
===> Event Studio
===> Metrics Studio
===> Metric Modeling (Metric Designer)
===> SDK
=====> Developing with Web Services/ReportNet SDK
===> Mobile Analysis
===> Composite Information Server
===> COGNOS 8 Go! Mobile
===> PowerPlay Studio
===> Cognos Now!
===> Business Viewpoint
=> IBM Cognos Express
===> Express Manager
===> Xcelerator
===> Advisor
===> Reporter
===> Architecture and Administration
=> Upgrade to C8
===> Impromptu to C8
===> IWR to C8
===> Impromptu to CRN
===> IWR to CRN
===> PowerPlay to C8
===> ReportNet to C8
===> Architect to Framework Manager
-----------------------------
Implementation-Based Software Offerings
-----------------------------
=> MetaManager: PowerTools for IBM Cognos
=> Integrated Version Control
=> CPM Explorer (for Microsoft Outlook)
=> Other Add-On Products and Utilities
-----------------------------
Legacy Business Intelligence
-----------------------------
=> COGNOS ReportNet
===> ReportNet Administration
===> COGNOS Connection
===> Framework Manager
===> Report Studio
===> Query Studio
===> Analysis Studio
===> Event Studio
===> Metrics Studio
===> SDK
=====> Developing with Web Services/ReportNet SDK
=> COGNOS PowerPlay
=> COGNOS Transformer
=> COGNOS Impromptu
=> COGNOS NoticeCast
=> COGNOS Visualizer
=> COGNOS Query
=> COGNOS UpFront
=> COGNOS Architect
-----------------------------
Planning & Consolidation
-----------------------------
=> TM1
=> COGNOS Planning
=> COGNOS Controller
=> COGNOS Finance
-----------------------------
Scorecarding and Dashboard Software
-----------------------------
=> COGNOS Metrics Manager
-----------------------------
ETL, App Development and other tools
-----------------------------
=> COGNOS DecisionStream/Data Manager
=> COGNOS Performance Applications
===> Customer Analytics
===> Financial Analytics
===> Supply Chain Analytics
=> COGNOS PowerHouse
===> Axiant
=> Automation
=> COGNOS Access Manager
=> COGNOS Power2000
=> COGNOS Accelerator for SAP R/3
=> Workforce Performance
-----------------------------
Corporate Performance Management
-----------------------------
=> Corporate Performance Management (CPM)
-----------------------------
OEM
-----------------------------
=> General
=> Application Integration
=> Performance Tuning
=> Rebranding Cognos
=> Security
=> SAAS
=> Testing
-----------------------------
COGNOS-related services and products
-----------------------------
=> COGNOiSe yellow pages
===> Consultants
===> Employment agencies/consultants
===> Hardware
===> Software
===> Other
-----------------------------
General Discussion
-----------------------------
=> IBM Cognos Links
=> Job advertisements
=> COGNOS certification
=> Wishlist
=> Introduce yourself and your company!
=> General Discussion & Gossip
=> Forum suggestion box
=> Miscellaneous downloads
Loading...