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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Burst of BI report from TM1 data with error

Started by tshw, 17 Mar 2016 01:29:54 PM

Previous topic - Next topic

tshw

Has anyone successfully burst a BI report with a dimensional query of TM1 data ?
I'm getting an error:
XQE-GEN-0002 An unexpected exception occurred: com.cognos.xqe.resultsets.ContextMember incompatible with com.cognos.xqe.data.values.Value

When I had a query that wasn't truly dimensional, the bursting worked... but there were too many outputs/attachments that were blank in TM1's current year selection, so I rewrote the whole report to dimensional query to filter out those items without current year data. The new dimensional report runs fine when not bursting... but if I run it in a burst, I get the above error.

Anyone successfully burst a dimensional BI report ?

MFGF

Quote from: tshw on 17 Mar 2016 01:29:54 PM
Has anyone successfully burst a BI report with a dimensional query of TM1 data ?
I'm getting an error:
XQE-GEN-0002 An unexpected exception occurred: com.cognos.xqe.resultsets.ContextMember incompatible with com.cognos.xqe.data.values.Value

When I had a query that wasn't truly dimensional, the bursting worked... but there were too many outputs/attachments that were blank in TM1's current year selection, so I rewrote the whole report to dimensional query to filter out those items without current year data. The new dimensional report runs fine when not bursting... but if I run it in a burst, I get the above error.

Anyone successfully burst a dimensional BI report ?

The error sounds like you're trying to use a member as a value somewhere in your report? Perhaps in the burst specifications?

MF.
Meep!

tshw

#2
Thanks MFGF,

That may have been one of the issues... I ran into multiple issues (with unrelated error messages) including using a Member Set in a page set... which works interactively... but doesn't with bursting.
I was finally able to get bursting working by using a member property vs member set.