-
Member
Reputation: 258
Simple problem
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.
Last edited by croleg; 2011-06-28 at 02:46 PM
-
2011-06-28 02:33 PM
# ADS
Circuit advertisement
-
VIP Member
Reputation: 1791
Re: Simple problem
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 Default PAS: london
pl rate threads for their usefulnes
share & care
-
VIP Member
Reputation: 1791
Re: Simple problem
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..
Auto_art Default PAS: london
pl rate threads for their usefulnes
share & care
Bookmarks