Anyone doing custom reports in SCI?

Question

My team and i have an SCI instance that has been running for about six months.  We are on Version: 1.2.0.0.1200 and we are finding setting up our own reports to be a little difficult.  does anyone have any pointers on setting something like like lowest used AP in a given AP group.

thanks for your responses.

shimshim · Answer

Recommend that you will first upgrade to SCI 1.3, as it had improvements in Custom Reports.

Open Anaylzer Report
Choose AP Statistics Cube
Expand the filters section (click on 'No Filter')
Drag the 'Day' level into the expanded filters area
Select the day to be reported, e.g. select the 'Today' checkbox, and click OK
Drag the 'AP Group' level into the expanded filters area
Double-click the AP Group you're interested at, and click OK
Double-click on the AP MAC measure
Double-click on the RX Data Bytes measure
Double-click on the TX Data Bytes measure
If you're interested in the total traffic, create a custom measure out of RX+TX:
    Right-click on Rx Data Bytes
    Choose User defined measure -> Calculated Measure
    In Name, fill in: Total Traffic (GB)
    In Format pullbox, select "General Number"
    on the right box, replace the content with: ([Rx Data Bytes]+[Tx Data Bytes])/1073741824
    (the last part is so the result would be in GB instead of bytes)
    click OK
    a new summary column will now appear.
Choose which column you want the lowest 10 from (likely, Total Traffic), right click on its' header, and choose 'Top 10, etc'
Change 'Top' to 'Bottom', and 'by' to 'Total Traffic (GB)'
Click OK
And you have it 🙂

You can now optionally remove the "RX Data Bytes" and "TX Data Bytes" if you're not interested to have them.