Last night, I was creating a simple boonlean conditional data item that I used to drive a boonlean variable and then used that variable as a style variable to edit the box type and cause certain rows to not render when my boonlean condition was false.
This morning, when trying to open my report I recieved this error message and the report cannot be opened:
This document does not contain a valid report specification.
Reason:
The namespace prefix is not allowed to start with the reserved string "xml".
URL:
Line:
9168
Character:
304
Source:
<selection><dataItem name="Other Expenses Condition"><expression>IF ([Other Expenses]=0) THEN (0) ELSE (1)</expression></dataItem><dataItem name="Systems Expense Condition"><expression>IF ([Systems Expenses]=0) THEN (0) ELSE (1)</expression></dataItem><dataItem name="COGS/COS Condition"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">if(([Cost of Goods Sold]=0) AND ([Cost of Services]=0)) THEN (0) ELSE (1)</expression></dataItem><dataItem name="COS Condition"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">IF([Cost of Services]=0) THEN (0) ELSE (1)</expression></dataItem><dataItem name="COGS Condition"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">IF([Cost of Goods Sold]=0) THEN (0) ELSE (1)</expression></dataItem><dataItem name="Revenue Condition"><expression xmlns:xml="http://www.w3.org/XML/1998/namespace">If([Revenue] = 0) THEN (0) ELSE (1)</expression></dataItem><dataItemMember name="Transient"><dmMember><MUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts].[Acnt1]->:[PC].[@MEMBER].[Transient]</MUN><itemCaption>Transient</itemCaption></dmMember><dmDimension><DUN>[CHM PL Cube].[CHMW-Accounts]</DUN><itemCaption>CHMW-Accounts</itemCaption></dmDimension><dmHierarchy><HUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts]</HUN><itemCaption>CHMW-Accounts</itemCaption></dmHierarchy></dataItemMember><dataItemMember name="Group"><dmMember><MUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts].[Acnt1]->:[PC].[@MEMBER].[Group]</MUN><itemCaption>Group</itemCaption></dmMember><dmDimension><DUN>[CHM PL Cube].[CHMW-Accounts]</DUN><itemCaption>CHMW-Accounts</itemCaption></dmDimension><dmHierarchy><HUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts]</HUN><itemCaption>CHMW-Accounts</itemCaption></dmHierarchy></dataItemMember><dataItemMember name="Contract"><dmMember><MUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts].[Acnt1]->:[PC].[@MEMBER].[Contract]</MUN><itemCaption>Contract</itemCaption></dmMember><dmDimension><DUN>[CHM PL Cube].[CHMW-Accounts]</DUN><itemCaption>CHMW-Accounts</itemCaption></dmDimension><dmHierarchy><HUN>[CHM PL Cube].[CHMW-Accounts].[CHMW-Accounts]</HUN><itemCaption>CHMW-Accounts</itemCaption></dmHierarchy></dataItemMember><dataItem name="Percent3"><expression>IF(caption([Mem Cap Diff]) in ('Rooms','Food and Beverage','Other Operated Departments','Miscellaneous Income'))
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
Has anyone seen anything like this before?
Hello,
Were you able to solve this problem? If so, could you please share the steps you took?
I am having the same problem with a report created by someone else in Cognos 10. I now need to modify the report.
Thank you,
Lili