Simple problem

[croleg]

Hello
How can I make unload information about BCCH & TCH from the E/// OSS so, that BCCH and TCH were separately. For example channel information is unloaded:
CID____BCCH_TCH
10001__1 _____1,3,99,109
.................................................
19996__ 617 __617,678,701

I need that:

CID __ BCCH __ TCH
10001 __ 1 ____ 3,99,109
.................................................
19996 __ 617 __ 678,701

I tried it with the EXCEL, but does not work.

[auto_art]

u can use exert for the same..or try to extract through CNA template i provided here..
search for my post. there is a cna template for the same very use full.!

[auto_art]

do this way
open desktop intelligence or BO goto>file>new>generate standard report>select free hand sql in others option then finish.

paste follwoing query....withoute quote
"
SELECT *
from
cnadb.dbo.cna_cells_view

WHERE
cnadb.dbo.cna_cells_view.bsc = @variable('BSCNAME')

"

click on run..u r done..