GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Cognos
Go To First  |  Previous Question  |  Next Question 
 Cognos  |  Question 175 of 180    Print  
Level Span
What is difference between Level Span And Group Span


  
Total Answers and Comments: 4 Last Update: July 22, 2009     Asked by: ARK CHOWDARY 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sivabisani
 

As per my knowledge, both words are same.

Level span is used to eliminate duplicates in data, in Cognos it is used repeat grouped item. Using level span we can see the grouped data group by group.
For example, when country and city are both grouped, you can choose to show the country name each time .
-- the country changes, by spanning Country by Country
-- the city changes, by spanning Country by City
-- there is a new record, by specifying no spanning
Spanning one grouped column by another column is helpful if the second
column contains many items.
Steps
Open the report that you want.
Click the column for which you want to set the group span.
In the Properties pane, click the Group Span property and click the
column you want to span.

Thanks,
Siva



Above answer was rated as good by the following members:
ARK CHOWDARY, NagaShilpaV
November 14, 2008 01:07:29   #1  
sivabisani Member Since: November 2008   Contribution: 14    

RE: Level Span

As per my knowledge both words are same.


Level span is used to eliminate duplicates in data in Cognos it is used
repeat grouped item. Using level span we can see the grouped data group by
group.

For example when country and city are both grouped you can choose to show the
country name each time .

-- the country changes by spanning Country by Country

-- the city changes by spanning Country by City

-- there is a new record by specifying no spanning

Spanning one grouped column by another column is helpful if the second

column contains many items.

Steps

Open the report that you want.

Click the column for which you want to set the group span.

In the Properties pane click the Group Span property and click the

column you want to span.


Thanks

Siva


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 1Overall Rating: -N/A-    
March 26, 2009 07:33:44   #2  
viramitraval Member Since: January 2009   Contribution: 1    

RE: Level Span

Let us discus about Group span first.

for Example
In List Report when you have product line product type & product name as a query item. You've product line & product type grouped Ok?
Now you want to span product line as per product type(i.e. you want product line to repeat whenever new product type is listed beside it). You can click on product line & change the Goup span property to product type. This gives you the proper result.
Now you want to span product line as per product name(i.e. you want product line to repeat whenever new product name is listed beside it). In this case you have to first group the product name query item then & then you can change Group span property of the product line to product name. Because Group span property lists the query items which are grouped in the list.

Lets discus about Level span now.

for Example
In CrossTab Report when you have product line as parent node in row product type as child node of product line & product name as child node of product type.
Now you want to span product line as per product type(i.e. you want product line to repeat whenever new product type is listed beside it). You dont have Group span property in CrossTab Ok? Here you can do some trick which is called Level span. You can add one more product type as child to product type & then cut product line from CrossTab. Then select Parent product type & change Source Type property to Data Item Value & Data Item Value property to product line. Now run the report you can see the product line level repeats whenever new product type is listed beside it. This is called a Level Span.

Remember one more thing you can not do same kind of Level Span using dimensional model. You can do Level Span using relational model only...


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 21, 2009 16:12:36   #3  
freaky_priscilla Member Since: July 2009   Contribution: 2    

RE: Level Span

As far as I know level span was in Cognos 1.1 and Cognos 8 had Group Span. I thought they had the same functionality and it was just renamed for whatever reason. Please correct me if i am wrong!


 
Is this answer useful? Yes | No
July 22, 2009 07:13:14   #4  
kiran_tsa Member Since: July 2009   Contribution: 3    

RE: Level Span
Level span is there in Report Net 1.1 and Group span is there from in 8.x. Both will work same if you want to repeat a grouped item with respect to change the nested data item under it. But rather than level span group span is simple to operate and we can change the level spanning for any no. of columns easily.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape