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 ?
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.
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.