If you are unable to create a new account, please email support@bspsoftware.com

 

XQE-PLN-0243 Relational querySubjects defined using dimensional terms can not...

Started by dougp, 27 Jan 2022 12:24:56 PM

Previous topic - Next topic

dougp

Using IBM Cognos Analytics 11.1.7IF6 to develop a report I'm getting this validation error:

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0243 Relational querySubjects defined using dimensional terms can not be supported. Term: "[Expenditure].[Acceptance Date]" is referred from a relational querySubject.

I saw another post about this (https://www.cognoise.com/index.php?topic=34042.0) but it didn't solve my problem.

I'm trying to join a DQM package to a spreadsheet.  What's really strange is that if I cut [Acceptance Date] from the list, the report validates.  [Acceptance Date] comes from the package, along with many other query items, most of which make it all the way through the query logic to the list.

[Acceptance Date] is a query item on the [Acceptance Date] query subject in the package.  (dbo.AcceptanceDate.AcceptanceFullDate in the database)  It's the only item I'm using from that subject.  It works fine directly from the package.  This problem is specific to combining it within a data module.

I'm also the Framework Manager modeler, so...  Is there something I messed up in my model that could be causing this?

MFGF

Quote from: dougp on 27 Jan 2022 12:24:56 PM
Using IBM Cognos Analytics 11.1.7IF6 to develop a report I'm getting this validation error:

RSV-VAL-0010 Failed to load the report specification. XQE-PLN-0243 Relational querySubjects defined using dimensional terms can not be supported. Term: "[Expenditure].[Acceptance Date]" is referred from a relational querySubject.

I saw another post about this (https://www.cognoise.com/index.php?topic=34042.0) but it didn't solve my problem.

I'm trying to join a DQM package to a spreadsheet.  What's really strange is that if I cut [Acceptance Date] from the list, the report validates.  [Acceptance Date] comes from the package, along with many other query items, most of which make it all the way through the query logic to the list.

[Acceptance Date] is a query item on the [Acceptance Date] query subject in the package.  (dbo.AcceptanceDate.AcceptanceFullDate in the database)  It's the only item I'm using from that subject.  It works fine directly from the package.  This problem is specific to combining it within a data module.

I'm also the Framework Manager modeler, so...  Is there something I messed up in my model that could be causing this?

Hi Doug,

Is this a DMR package? I have seen weird results when trying to use DMR packages to feed list reports (OLAP packages too) - seems to get very confused building a relational structure from a dimensional package.

What happens if you try to use a crosstab - do you see similar issues?

Is there an option to master/detail the spreadsheet in a report, or does this need to be at the metadata level for wider use?

Cheers!

MF.
Meep!

dougp

It's a relational package using DQM.

There's nothing dimensional about this.  Everything is relational.  (of course, this is an assumption based on how I perceive spreadsheets)

I've never seen this problem before when using a data module to combine packages with spreadsheets.

Crosstab = same error message

I'm not understanding what you mean about master/detail.  I need to join the spreadsheet to the package data on a data item that must be calculated from the package.  Due to apparent limitations in data modules, I couldn't create the calculation in a way I could use.  So I had to not create relationships in the data module.  I have one query (expenditures) coming from the package and one query (budget) coming from the spreadsheet, then joined into another query (output) in the report authoring tool.

I have 10 dimensions and 3 measures in the output query.  Only AcceptanceDate causes problems.