Active IQ Unified Manager Discussions

OCI DWH Cognos join error

sunilyadav
8,047 Views

Hi,

I am working out to create some reports for our requirements which are not available in templates, so I have to customize it.

I am logged in DWH reporting.

Queries:

1. I want to generate report on how many and which servers are connected to my storage box. So the columns I want to add will be storage name from storage asset and hostname from host asset. But when I drag the hostname, I get error:

RQP-DEF-0103

       Cross joins (between query subjects: [Host Assets].[Host], [Storage Assets].[Storage]) are not permitted for the user who has the identity '{All Authenticated Users, Everyone, Portal Administrators, Report Administrators, Readers, PowerPlay Administrators, Adaptive Analytics Administrators, Controller Administrators, Directory Administrators, Authors, Metrics Administrators, Server Administrators, Express Authors, Query Users, Consumers, Planning Rights Administrators, ReportingAdminCM, ReportingProAuthorCM}'.

I have to create report which is combination on multiple assets. So what is the solution for it.

regards.

14 REPLIES 14
Public