Hi all,
I'm new to OLAP/BW universes and I've run into some strange issues. I've generated a universe based on a Bex query and I'm getting invalid mdx errors when drilling on a couple of the hierarchies. There has been no customisation of the universe so I'm not sure how invalid mdx can be generated??? I've placed Product and Profit center hierarchies and a single Key Figure onto a report and when I drill down on the hierarchies I get the error. It only seems to happen when I have more than one hierarchy on the report. A single hierarchy with Key Figures does not cause an error.
Business Objects Edge 3.1 SP2
SAP Int Kit SP2
OS: Linux
BW 701 Level 6
Executing the mdx in MDXTEST gives the error "Invalid MDX command with {...}"
Webi log entry below.
Any advice would be much appreciated.
Cheers
Keith
kc3cdbtbdacs.cpp:3962:static ConnectionServer::Status tbCnxSrvrRecordSet::doCSExecute(ibo_ptr<IConnectionServer::JobResultSet>&, std::auto_ptr<ConnectionServer::ResultSet>&): TraceLog message 147
2010/05/04 05:34:26.997|>=|E|X|17343|1596992400| |||||||||||||||Uncaught Exception in SilentScope: C3_dacs:CSJob::Execute(*Res): 6.598
kc3cdbtbdacs.cpp:317:BOResult DoReportCSError(const ConnectionServer::Error&, int, const char*): TraceLog message 148
2010/05/04 05:34:26.997|>>|E| |17343|1596992400| |||||||||||||||**ERROR:C3_dacs:CS::Error : (DBD(1),ID:769) "The MDX query SELECT { [Measures].[DCF59QUC57XIIT50PJKVFYR8K] } ON COLUMNS , NON EMPTY CROSSJOIN( CROSSJOIN( { [0PROD_HIER PRDHA].[10001 0PRODH1] } , INTERSECT( INTERSECT( { Descendants( { [0PROFIT_CTR 1000YBPH].[000000000000000000000000100010000HIER_NODE] } , [0PROFIT_CTR 1000YBPH].[LEVEL02]) } , { Descendants( [0PROFIT_CTR 1000YBPH].[LEVEL01].MEMBERS, [0PROFIT_CTR 1000YBPH].[LEVEL02], LEAVES) } ) , { Descendants( { }, [0PROFIT_CTR 1000YBPH].[LEVEL02]) } ) ), [0CUSTOMER].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS FROM [COPA_C01/COPA_C01_Q002] SAP VARIABLES [!V000001] INCLUDING [0FISCPER].[V62010010] failed to execute with the error Invalid MDX command with {...}"
Edited by: Keith Liauw on May 5, 2010 2:18 AM