Some users may have issues creating a community account. For more information, please click here.

How to show Hidden reports in v 5.5.26

How to show Hidden reports in v 5.5.26

Default Report Changes in 5.5.26:

Some out of the box reports are now hidden by default starting v 5.5.26

Reason:

We have added some enhanced additional reports in v 5.5.26.

Not all old reports may be required by each customer and hence, these are disabled by default.

If needed, customers can show these Hidden reports based on their use case.

Steps to show Hidden Reports:

Explained below is the definition of BDNA_A_REPORTS view.

The list of report names in the first CASE WHEN clause is the list of reports HIDE in 5.5.26.

In order to show the reports, comment out or remove the line of report name in the list and run the scripts to re-create BDNA_A_REPORTS view.

(This is SQL server version, Oracle is similar to this)

 

DROP VIEW BDNA_A_REPORTS;

 

CREATE VIEW BDNA_A_REPORTS AS

SELECT

  CASE

    WHEN REPORT_NAME IN ('Hardware Entitlement Dashboard',

    'Operating System Summary',

    'OS Distribution by Family',

    'OS Distribution by Manufacturer and Name',

    'Purchase Order Normalization',

    'Server Software Windows 32Bit Readiness',

    'Server Software Windows 32Bit Status',

    'Server Software Windows 64Bit Readiness',

    'Server Software Windows 64Bit Status',

    'Software Asset Management',

    'Software Compliance Dashboard',

    'Software Entitlement',

    'Top Licensable Server Software',

    'Top Licensable Server Software with CPU Counts',

    'Top Licensable Software for Workstations and Laptops',

    'Top Software Manufacturers with Licensable Indicator',

    'Top Software Products',

    'Win Server CPU Compatibility',

    'Win Server Hardware Readiness',

    'Win Server HDD Compatibility',

    'Win Server RAM Compatibility',

    'Windows Desktop Migration Software Readiness',

    'Windows Server Hardware Readiness',

    'Windows Server Migration Software Readiness',

    'Hardware Entitlement'

       ) THEN     

      CASE

        WHEN (SELECT COUNT(*) FROM BDNA_CP) > 0

        THEN 'HIDE'

      END

    WHEN REPORT_PATH NOT LIKE '%pricing.template%'

    AND REPORT_PATH NOT LIKE '%lifecycle.template%'

    AND REPORT_PATH NOT LIKE '%UserReports%xdash'

  THEN

    BDNA_A_CUBES.DISPLAY_OPTION

    WHEN REPORT_PATH LIKE '%pricing.template%' THEN

      CASE

        WHEN (SELECT 1 FROM BDNA_CP WHERE CP_NAME = 'HW SW Pricing' AND  IS_SUBSCRIBED = 'Y') > 0 AND BDNA_A_CUBES.DISPLAY_OPTION = 'SHOW'

        THEN 'SHOW' ELSE 'HIDE'

      END

    WHEN REPORT_PATH LIKE '%lifecycle.template%' THEN

      CASE

        WHEN (SELECT 1 FROM BDNA_CP WHERE CP_NAME = 'Lifecycle And Support' AND  IS_SUBSCRIBED = 'Y') > 0  AND BDNA_A_CUBES.DISPLAY_OPTION = 'SHOW'

        THEN 'SHOW' ELSE 'HIDE'

      END

    WHEN REPORT_PATH LIKE '%UserReports%xdash'

      THEN 'SHOW' ELSE 'HIDE'

  END

  DISPLAY_OPTION,

  BDNA_A_CUBES.CUBE_WEIGHT,

  BDNA_A_REPORTS$.*

FROM BDNA_A_REPORTS$

LEFT JOIN BDNA_A_CUBES ON BDNA_A_CUBES.CUBE_NAME = BDNA_A_REPORTS$.REPORT_CUBE

;

Labels (5)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
4 of 4
Last update:
‎Feb 27, 2020 01:56 PM
Updated by:
 
Contributors