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 toproduct 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...
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 toproduct 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...
level span is a bit confusing. please post some pics to explain it. thanks
ReplyDeleteHi,
ReplyDeletethis is my mail id ksreddy.cognos8bi@gmail.com
send me screen chat
Thanks
satish
Thanks Man. Its pretty clear
ReplyDeleteits clear .
ReplyDeletesuppose consider a consider a crosstab report having elements like this
Product line | Product Type | Product name
What we do here is remove product line and put another product type in the place of Product line
Product Type | Product type | Product type
now click on product type .change the source item property as mentioned :)
very nice explaination.... thanks alot.... Gurus, i would like to understand clearly, the arcitechture of cognos 8 BI. Pls guide me in that. I want to know the request flow when a report is run till it is rendered to users. Pls help me out. Thanks in advance.
ReplyDeleteHey good explanation do you offer online training Congnosguy@gmail.com
ReplyDeletePlease let me know if you offer training I have a passion of learning cognos tools
ReplyDeleteThanks please email me Congnosguy@gmail.com
Pls post difference along with snapshot in details. At fahad1358@gmail.com
ReplyDelete