topic MDX query error in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/MDX-query-error/m-p/51431#M14117 <HTML><HEAD></HEAD><BODY><P>When I try to run a report that goes off of a cube I receive an error.&nbsp; I found an article on online about this issue and I basically delete and recreated the cube and still am receving the error.&nbsp; The problem is because CIS-213 doesn't exist in the data source but there must be a pointer to this somewhere.</P><P></P><P>An error occurred in processing the report element. Refresh the page to try again. Contact your administrator if this problem persists.</P><P>[a13137619332170.561645866554842_2_0] Error Rendering the Report</P><P>Formula error - An invalid member name was encountered in the MDX statement - near: "[OrgDim].[All OrgDim].[BPS-Business &amp; Public Services].[0415-Computer Info Systms/Academic].[CIS].[CIS-213]"</P><P></P><P></P><P></P><P>Thanks.</P></BODY></HTML> Fri, 19 Aug 2011 16:20:21 GMT nickb 2011-08-19T16:20:21Z MDX query error https://communities.sas.com/t5/SAS-Procedures/MDX-query-error/m-p/51431#M14117 <HTML><HEAD></HEAD><BODY><P>When I try to run a report that goes off of a cube I receive an error.&nbsp; I found an article on online about this issue and I basically delete and recreated the cube and still am receving the error.&nbsp; The problem is because CIS-213 doesn't exist in the data source but there must be a pointer to this somewhere.</P><P></P><P>An error occurred in processing the report element. Refresh the page to try again. Contact your administrator if this problem persists.</P><P>[a13137619332170.561645866554842_2_0] Error Rendering the Report</P><P>Formula error - An invalid member name was encountered in the MDX statement - near: "[OrgDim].[All OrgDim].[BPS-Business &amp; Public Services].[0415-Computer Info Systms/Academic].[CIS].[CIS-213]"</P><P></P><P></P><P></P><P>Thanks.</P></BODY></HTML> Fri, 19 Aug 2011 16:20:21 GMT https://communities.sas.com/t5/SAS-Procedures/MDX-query-error/m-p/51431#M14117 nickb 2011-08-19T16:20:21Z MDX query error https://communities.sas.com/t5/SAS-Procedures/MDX-query-error/m-p/51432#M14118 <HTML><HEAD></HEAD><BODY><P>I'm not familiar with MDX, but does the following technical note help?</P><P><A href="http://support.sas.com/kb/13/458.html">http://support.sas.com/kb/13/458.html</A></P></BODY></HTML> Fri, 19 Aug 2011 22:18:42 GMT https://communities.sas.com/t5/SAS-Procedures/MDX-query-error/m-p/51432#M14118 art297 2011-08-19T22:18:42Z