Custom reports in Actix (January Rel)

[GunsNroses]

Hello, I'm a newbie at this forum and Actix. I created own report template by changing one of existing analyses, but i don't know how to call up it? I still have default analyses in Analysis list. Thx for any help.

[Jerry]

To create a new report:




Open up the Attribute Explorer and then locate the attribute on which you want to base your report.

Right-click the attribute and choose Display on Workbook.

Right-click each subsequent attribute that is relevant to the report and choose Display on Workbook (active).

Now you can customize your report by adding new sheets and link to other resulted sheets. You should use formula to get the result automatically. Save that excel workbook and that is your excel template. Do not remove, edit the worksheets created by Analyzer to store the exported data (for example, the CrossTab Formatted Data worksheet).

[GunsNroses]

Sorry, I don't understand what formula should I use to get the result automatically?
I want to generate report including ActiveSet_EcNo, EcNo for each SC and same plots for RSCP just by calling in menu Analysis my own report type that was created in Tools=>Analysis Manager. I've saved it in Analysis Manager, but don't know how to use

[GunsNroses]

Guys, any help pls, still can't solve this problem

[Jerry]

what you want to put in your report, KPI statistics, chart or what? No one can help if you don't tell us.
You should learn the excel functions to get your result. Many functions can satisfy your need, like count(), average(), etc

[GunsNroses]

I need to put in my reports charts of EcNo and RSCP for each SC, and summary coverage EcNo and RSCP plots (I guess it called UU_ActiveSet_EcNo and UU_ActiveSet_RSCP in DownLink Measurements)

[GunsNroses]

here are images of what i have done:
1. I have created query with plots I need
http://i47.tinypic.com/2q34t2t.jpg
2. It has appeared in Analysis Manager list
http://i49.tinypic.com/bi2p3q.jpg
3. How can I use it to generate report automatically?

[Jerry]

If you want to make your customized excel report, than you dont need to make Network Image. Follow the steps I said to make the excel report. I also made 1 report to present the Ec/Io and RCSP chart ( I used pivot but you can change it depend on your excel expertize).

All we need to do now is to save that excel workbook. There is no restriction on where you can save it. However, it will automatically appear on the Workbooks menu if you save it in the Workbooks folder within the Analyzer user data area (http://ftp.actix.com/resources/1502/Projects/KB/Framework/User_File_Locations.htm). This is typically:


C:\Documents and Settings\All Users\Application Data\Actix\Analyzer\Workbooks
Now let's run the report. How you do this, depends on where you saved it. If you saved the report in the folder specified above, it will become an entry on the main Workbooks menu after you restart Analyzer.
http://ftp.actix.com/resources/1502/Projects/KB/TechLayer/Reports/Images/SimpleExample4.gif
If you saved it somewhere else, use the Open Workbook / Report command and browse to the folder where you saved the file.

When you select the report, the Stream Selection window opens, listing all of the data sources that are currently open.

http://ftp.actix.com/resources/1502/Projects/KB/TechLayer/Reports/Images/SimpleExample5.gif
Select a logfile or super stream to run the report.

[GunsNroses]

Thank you for this answer! But i can't download attached file cause of my newbie rep, can you upload it on external server?