CCM Dashboard error: query name not valid (0SM_CCL_QUALITY_DETAIL

[former_member210731]

Hi,

I have enabled CCLM services and got the custom code data into Solman and have also enabled the dashboard, It is showing alert messaage and have attached below screenshot

I has given the below error messages.

Invalid input: query name not valid (0SM_CCL_CRITICALITY_DETAIL does not exists or was not activated)

An error has occured while trying to execute BW query 0SM_CCL_CRITICALITY_DETAIL

Invalid input: query name not valid (0SM_CCL_OBJECT_COUNT does not exists or was not activated)

An error has occured while trying to execute BW query 0SM_CCL_OBJECT_COUNT

Invalid input: query name not valid (0SM_CCL_SEVERITY_DETAIL does not exists or was not activated)

An error has occured while trying to execute BW query 0SM_CCL_SEVERITY_DETAIL

Invalid input: query name not valid (0SM_CCL_OBJECT_COUNT does not exists or was not activated)

An error has occured while trying to execute BW query 0SM_CCL_OBJECT_COUNT

Invalid input: query name not valid (0SM_CCL_QUALITY_DETAIL does not exists or was not activated)

An error has occured while trying to execute BW query 0SM_CCL_QUALITY_DETAIL

Also, we have around 10 ERP landscapes (DEV,QAS & PRD) connected to one single solman and I have enabled the CCLM data fetch jobs for all.

How do i segregate the CCM Dashboard for each of the landscape (Sourcesystem / Landscape)?

Regards

Mahendra K

[former_member201176]

Hi all,

one additional answer.

The dashboards are designed as management dashboards they will give an overview on the CCLM objects overall. It is not possible to analyze the data for different landscapes with these dashboards.

Best regards,

Thomas Fischer

[Former Member]

Thank you Thomas, I wish I could award points but didn't originate message. Your explanation fixed the problem for me. Thanks again,

David

[Former Member]

Hi Mahendra,

I'm having same exact problem, did you ever find the answer? Thanks,

David

[former_member201176]

Hi all,

to activate the dashboards, first the Custom Code Lifecycle Management from SAP has to be implemented and all related BW objects have to be activated (infocubes, queries).

The following queries have to be activated:

• 0SM_CCL_OBJECT_COUNT
• 0SM_CCL_QUANTITY_DETAIL
• 0SM_CCL_QUANTITY_MONTH
• 0SM_CCL_QUANTITY_WEEK
• 0SM_CCL_QUALITY_DETAIL
• 0SM_CCL_QUALITY_MONTH
• 0SM_CCL_QUALITY_WEEK
• 0SM_CCL_USAGE_DETAIL
• 0SM_CCL_USAGE_MONTH
• 0SM_CCL_USAGE_WEEK
• 0SM_CCL_SEVERITY_DETAIL
• 0SM_CCL_SEVERITY_MONTH
• 0SM_CCL_SEVERITY_WEEK
• 0SM_CCL_CRITICALITY_DETAIL
• 0SM_CCL_CRITICALITY_MONTH
• 0SM_CCL_CRITICALITY_WEEK

1. Start transaction code RSA1 (BW Setup)
2. Click on "BI content"
3. Click on "Object Types"
4. Navigate to "Query Elements" - "Query" - "Select Objects" Double Click
5. Navigate to "SAP Solution Manager - Custom Code Lifecycle Management"
6. Navigate to "CCLM Object Statistics"
7. Press F7 in the window to see the technical names, if they are not displayed
8. Select all queries listed above, by clicking on "Transfer" (for
   0SM_CCL_OBJECT_COUNT see below)
9. To select 0SM_CCL_OBJECT_COUNT click on "Object ID" (below "SAP Solution
   Manager - Custom Code Lifecycle Management")
10. Select 0SM_CCL_OBJECT_COUNT, by clicking on "Transfer"
11. Flag on the right side all entries and click on "Install" with subselection
    "Install"
12. Wait
13. Check the status - then the query is activated

The queries can be executed and checked via the transaction "RSRT".

Best regards,

Thomas Fischer