TNPM Wireless Component - Import Traffic Functions to Cognos Model and Expose it to Report Studio
ArbyTeh 270004SQRF Comment (1) Visits (5595)
This blog entry is to share the way to import Traffic Functions of TNPMW to Cognos Model & expose it to Report Studio.
Those Traffic Functions of TNPMW are available in VIRTUO Schema of TNPMW DB.
First, import the Traffic Function through Metadata Import Wizard as you would a regular database table, simply choose Functions rather than Tables in the Wizard.
Choose 'tcraccess' as your data source, and click 'Next >'
Then expand 'VIRTUO' -> 'Functions', you will see the traffic functions there, simply Check on "TRA
We are using CDMA VN Tech Pack Common Pack as an example.
Within the Project Viewer, expand to the path below:
Model -> Consolidation Views -> Tivoli Netcool Performance Manager (TNPM) -> TNPM CDMA VN NA Measurements (Consolidation) -> C_Route Measurements -> C_Route.Route -> C_Ro
Right click to 'C_R
Edit the name as 'cri
Drag the function into the Expression definition, and complete the formula as below:
Click on 'OK'
Now create the package and publish the package.
Go to Report Studio and create a report under this Package to test out the crit
Also, if you publish the Traffic Function, you will have it in the report studio as well.
Run the report to see the executed Traffic Function:
Compare the result directly with DB, its a match!