Adding a condition to a subreport

This procedure provides instructions for adding a condition to a subreport by using a copy of the A06b — Asset Aging – Drill-Down View subreport as an example.

• • To add conditions to a subreport
  • To pass a value through the report hyperlink

To add conditions to a subreport

1. Log on to the SAP BusinessObjects Business Intelligence BI launch pad.
2. Navigate to the Documents tab.
3. In the Folders menu, expand Public Folders > BMC Analytics for BSM > Asset Management.
4. Navigate to the A06b — Asset Aging – Drill-Down View subreport.
5. Copy and paste the report to the folder where you are storing the customized reports.
6. In the custom folder, right-click the report and select Modify.
    The Web Intelligence window appears showing the Asset Aging – Drill-Down View subreport.
7. Click Edit under the Data Access > Data Providers tab.
    The Query Panel appears open to the Query 1 tab for the data provider.
8. Navigate to the Asset Management > Asset Information folder in the Web Intelligence window navigation bar.
9. Drag the Enter/Select Company condition to the Query Filters list in the right pane.
10. Navigate to the Asset Management > Asset Information > Asset folder in the Web Intelligence window navigation bar.
11. Drag the Company dimension to the Result Objects list in the right pane.
12. Click Close > Apply Changes and Close.
13. Click Document Structure and Filters.
14. Drag the Company object from the left pane in the report, and align the Company column with other columns in the report. Increase the width of the table header and align it with the width of the table columns.
15. Click Refresh All.
16. Click Save.

To pass a value through the report hyperlink

1. Return to the Asset Management folder in the SAP BusinessObjects Business Intelligence BI launch pad.
2. Navigate to the A06a — Asset Aging report.
3. Copy and paste the report to the folder where you are storing the customized reports.
4. In the custom folder, right-click the report and select Modify.
    The Web Intelligence window appears showing the Asset Aging report.
5. Click Edit under the Data Access > Data Providers tab.
    The Query Panel appears open to the Query 1 tab for the data provider.
6. Navigate to the Asset Management > Asset Information > Asset folder in the Web Intelligence window navigation bar.
7. Drag the Company dimension from the navigation bar to the Result Objects list in the right pane.
8. Click Close > Apply Changes and Close.
9. Click Edit Report.
10. Right-click the measure Var_ProdCatTier2 and choose Duplicate.
11. Double-click the duplicated measure to open the Variable Editor tool.
12. Set the name to Var_Company.
13. Set the Qualification to measure.

14. Set the formula to the following value: 

    =If(IsError(If(DrillFilters([Company])=""
    ;If(DrillFilters()=""
    ;[Company]
    ;If(DrillFilters([Company])=""
    ;[Company]
    ;"ALL")
    )
    ;DrillFilters([Company])))=1;"ALL";If(DrillFilters([Company])=""
    ;If(DrillFilters()=""
    ;[Company]
    ;If(DrillFilters([Company])=""
    ;[Company]
    ;"ALL")
    )
    ;DrillFilters([Company])))
15. Click OK on the Variable Editor dialog box and Yes on the confirmation window that appears.
16. Double-click the Var_Link measure.
     The Variable Editor window appears.

17. Change the URL in the Formula field to pass the value for the Company condition to the Asset Aging – Drill-Down View subreport.
     The new value is as follows: 

    ="<a href=../../opendoc/openDocument.jsp?sFolder=HomePublicFoldersBMC%20Analytics%20for%20BSMAsset%20Management&sDocName=A06b%20-%20Asset%20Aging%20-%20Drill-Down%20View&sDocType=wqy&sReportName=Report&lsSAsset%20Aging%20Buckets="+URLEncode([CI Aging Year Buckets])+"&lsMEnter/Select%20Manufacturer%20Name(s)="+URLEncode([Var_Manufacturer])+"&lsMEnter/Select%20Company="+URLEncode([Var_Company])+"&lsMProduct%20Categorization%20Tier%201="+URLEncode([Var_ProdCatTier1])+"&lsMProduct%20Categorization%20Tier%202="+URLEncode([Var_ProdCatTier2])+"&lsMProduct%20Categorization%20Tier%203="+URLEncode([Var_ProdCatTier3])+"&lsMEnter/Select%20Product%20Name(s)="+URLEncode([Var_ProductName])+"
    &sRefresh=yes target=_self>"+Count([Instance ID])+"</a>"
18. Click OK and Yes on the confirmation window that appears to ask if you want to modify this variable.
19. Click Save.
20. Navigate to the A06a — Asset Aging report.
21. Refresh the report.
22. Click a hyperlinked asset count value.
     The A06b — Asset Aging – Drill-Down View report is opened.
23. Refresh the report.
24. Verify the company and additional information in report A06b.