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
;
Sep 18, 2020 01:23 PM