COGNOiSe.com - The IBM Cognos Community

Hello to all,

Our Cognos package has the following levels for our Geography dimension:
Continent
   Region
      Country   

We currently have this report studio report that has the following Grouping in the LIST HEADER:
Continent (ex: America)
   Region   (ex: North America)
 
We have applied a Break Page by Region in order to change pages for each region and therefore one tab by region in excel.

We filter the only query on Continent = America
So this way the report produces 3 excel tabs when exported to EXCEL. Those tabs are: North America, Central America and South America.

We now want to ADD 3 additional tabs when the report runs in Excel to those already beeing produced already.
That will actually display the Countries but only want those for Norht America: USA, Canada and Mexico

So i presume we would have the following list group design:
Continent (ex: America)
   Region   (ex: North America)
      Country (only those for North America)
   
How do we do this ?


Thanks !

Quote from: sanchoniathon on 12 May 2015 10:40:11 PM
Hello to all,

Our Cognos package has the following levels for our Geography dimension:
Continent
   Region
      Country   

We currently have this report studio report that has the following Grouping in the LIST HEADER:
Continent (ex: America)
   Region   (ex: North America)
 
We have applied a Break Page by Region in order to change pages for each region and therefore one tab by region in excel.

We filter the only query on Continent = America
So this way the report produces 3 excel tabs when exported to EXCEL. Those tabs are: North America, Central America and South America.

We now want to ADD 3 additional tabs when the report runs in Excel to those already beeing produced already.
That will actually display the Countries but only want those for Norht America: USA, Canada and Mexico

So i presume we would have the following list group design:
Continent (ex: America)
   Region   (ex: North America)
      Country (only those for North America)
   
How do we do this ?


Thanks !

Since when is America a continent?  :o

Data issues notwithstanding, it sounds like you have a dimensional source? Can you filter using the children function?

 ;) Ok you got me there ... while trying to go to fast and trying to hide my real data structure i got it wrong. Let's try this again but differently:

1- We are dealing with a relational data source

2- Our cognos package has the following levels in our Enterprise DIMENSION
Enterprise type
  Enterprise Region
    Enterprise Name

3- We have filter only a specific Enterprise Type = MidSize

4- We currently have a break page on Enterprise Region and this is currently producing 3 tabs when exported to excel as for in our example we only have 3 regions(East,Central and West) for our Enterprise Type=MidSize.

QUESTION: We now need to display a tab (in addition to the 3 tabs already beeing produced) for EACH Enterprise Name  for the Enterprise Region = East.

So in our example, we should have another 3 tabs for a total of 6.

Thanks for any valuable advice!

Hello to all, simply to let you know that i've found on another forum how to do such a thing:

So i managed to create a new data item called Dynamic with a logic similar to this in it:
IF ( [Region]  = 'East') THEN
    ( [SubRegion] )
ELSE
    ( [Region] )

and then simply use that newly created data item in the Break Page instead of the original "Region" data item.


It seems to be producing the expected results.

Thanks to everyone here !