TNPM Wireless Component - Tips for Building TCR Reports
BengSee 2700018NMH Visits (8500)
Few tips are outlined here to share our experience while building TNPM (Wireless) TCR Reports based on NPR report specification.
These may seem trivial, but when it is required, it may take some time to reach the solution.
1. To save the TCR Report Template to Local File System
2. I want to delete data item from report page, but the data item should be remained in the query.
Scenario: A data item is defined with complex formula/syntax, and it is displayed at report page for debugging/unit test.
Once finalized, the data item is deleted from the report page (probably just hit 'Delete' button).
By doing so, the data item is deleted from the query, and any dependency on it is broken.
To avoid data item deletion from the query, do the following setting in Report Studio:
a. From the menu Tool -> Option, click on the tab 'Report'.
b. Un-check the option 'Delete unreferenced query objects'.
Alternately, if a data item is not required to be shown in report page, it can be cut away, instead of delete.
3. For quick development unit test, run the generated SQL for each query built on SQL client.
a. Set the focus on the query built.
b. At the 'Properties - Query', click on the option 'Generated SQL'.
c. Select the parameters (if any) and the generated SQL statement is showed.
d. Copy the generated SQL statement, and run it on the SQL client.
4. Using Traffic Engineering Functions at TCR Report.
Traffic engineering functions are not modeled at Common Packs or Base Common Packs.
However there are cases where traffic engineering functions are required during report run-time.
Scenario: The report definition requires the result of CRITB for DefinedCircuits at a given GOS.
a. Create a query and attach a Custom SQL to it.b. Click into the 'SQL' and the custom SQL may look like the following.
Note the highlighted for Traffic Engineering Function usage.
c. The query would contain the data items defined in the Custom SQL.
d. These data items are used for report presentation.
Will focus on report creation in the upcoming post.