How to run MDX Test

[Former Member]

Hi Experts - Could anyone let me know how to test the query in transaction MDXTEST ?

Whats is the relevancy of results ?

and how its helpful in debugging ?

Thanks

Rohan

[former_member142702 · Accepted solution]

Hi

just copy the query in the multiline field on the right side and press the blue play button (Run Query Multid.)

This way you will be able to see what results are exactly delivered from SAP BW and this way be able to localize problems either on the BO or the BW side.

Regards

Stratos

[Former Member · Accepted solution]

Thanks , Just a small question - on running mdxtest

i got - catalog and cube

in catalog i enter the cube name and in cube field i selected the query from drop down..... then its showing all the available objects ? What to do now ??

After that nothing happening after pressing blue button. Pls. suggest.

Edited by: rohan1103 on Feb 10, 2010 9:42 PM

[former_member142702 · Accepted solution]

First of all you have to extract the MDX code that is created in your BOBJ system. Are you using WebI or CR?

Regards,

Stratos

[Former Member · Accepted solution]

I m using Webi.

Please help me.

[IngoH · Accepted solution]

You either get the MDX via tracing from Web Intelligence or you can also generate a test sequence (button on the right hand side) in transaction MDXTEST or you create your own MDX statement manually.

Ingo

[Former Member · Accepted solution]

Hi,

I have turn on the MDX Trace on the server. Where do I see the MDX Code If I run webi report.

Thanks,

Nis

[Former Member · Accepted solution]

Hi

i found these messages in MDA LOG:

+ServerParameterBase: ServerParameterBase[12]::getHierarchy( ) = [/GKV/BWKUENDJ]+
 +ServerParameterBase: ServerParameterBase[12]::getHierarchy( ) = [/GKV/BWKUENDJ]+
 +ServerParameterBase: ServerParameterBase[13]::getHierarchy( ) = [/GKV/BWORGL2A ORGEH 000]+
 +STRUCTURE: saputils::GetDimensionByUName+
 +STRUCTURE: Calling MDDataProviderBW.GetDimensions ...+
 +STRUCTURE: RFC function call MDDataProvderBW.GetDimensions returned S+
 +STRUCTURE: Call to MDDataProviderBW.GetDimensions took 0.000 seconds+
 +CUBE: SAPCube::~SAPCube+
 +CLIENT: Unreserved Structure YBWACKUE/YBWA_PKM_KUE_002_VTBO_BO_V01+
 +STRUCTURE: SAPStructure::~SAPStructure+
 +CLIENT: SAPClient::~SAPClient+
 +SAPDimension::~SAPDimension+
 +FIS: SAPHierarchy::~SAPHierarchy+
 +FIS: SAPDimension::~SAPDimension+
 +FIS: SAPHierarchy::~SAPHierarchy+
 +FIS: SAPHierarchy::~SAPHierarchy+
 +SAPConnection: SAPConnection::disconnect+

What does it mean?

BO could not resolve the hierarchy?

[Former Member]

Thanks