How do I resolvre this error in Report Manager - 5200 : Error executing query: 42
When I try to print preview the report I get the following error:
5200 : Error executing query: 42
Running the report in HFM Workspace I get the below Error:
5200: Error executing query: 42;hasPovDims=1;povXML=<?xml version="1.0"?><datasources><datasource name="ICS LIVE" dsid="1aff6a49_11d6b8dda0f_62d1" allowEdit="1"><dim name="Scenario" dimIndex="0" dsName="ICS LIVE" keyDimName="Scenario" memberName="Actual" displayName="Scenario: Actual"/><dim name="Year" dimIndex="1" dsName="ICS LIVE" keyDimName="Year" memberName="2012" displayName="Year: 2012"/><dim name="Period" dimIndex="2" dsName="ICS LIVE" keyDimName="Period" memberName="P3" displayName="Period: P3"/><dim name="Entity" dimIndex="4" dsName="ICS LIVE" keyDimName="Entity" memberName="USA_CLIENT.BOE_GLOBAL" displayName="Entity: USA_CLIENT.BOE_GLOBAL"/></datasource></datasources>