Good Afternoon,
I had created a few custom reports that functioned fine prior to the uprade. Now these reports generate the following error:One or more of the main return fields in the report are from multiple data sources.Attempting to run a a report with multiple unrelated data sources will cause a cross-join.This type of join will most likely not yield the intended results.
Prior to the upgrade I was able to get results form every availbale data source while creating the report. Are cross data source queries now unsupported? Thank you.
Hi Russo1203,
That is interesting; crossing datasources isn't supported, and wasn't supported in the past although it appears it may have been working for you in some cases.
If you or someone in your org has SQL skills, it is possible to write SQL queries to query the EW database directly, and we also expose all the SQL code for any given query which you can see by double-clicking it. That can be a useful starting point for someone drafting their own SQL queries.
-Kelly
To clarify: crossing datasources is not allowed in the WSUS Analytics category. In other categories it can be done in some cases.
Are you running version 1.7 SP1 (1.71.201)? If not, and your reports are not from WSUS Analytics, I'd recommend upgrading to that version and retry your reports. If they still return errors, can you export the report definition(s) and send it/them to Customer Support so we can have a look?
Kelly,
I have emailed as your requested and included exports of 3 reports for which the error is recived. 2 I created and 1 of the predefined. Thank you.
Thank you; we'll review the reports you've sent and do some testing and I'll respond back to your email.
