Get MDX log - Rich Client - 4.1 SP2

[former_member183473]

Hi,

I've been trying to get the the MDX genarated by webintelligence for quite a while now..

Can anyone shine a light to the right direction?

I've capture the logs using the following .ini file

size = 100000;

keep = true;

log_level = low;  

log_dir = @"c:\log";

[from_subunit("MDA")]

sap_log_level = log_info;

sap_trace_level = trace_info;

But there's no mdx in there.

Thanks in advance.

Best

Leandro

[arijit_das · Accepted solution]

Check SAP KBA

1923351 - How to retrieve MDX statement for BI 4.0 Web Intelligence Rich Client

1711416 - BI 4.0: How to enable MDA tracing for OLAP-based universes

You might need to include importance=xs; parameter and remove log_level = low.

[former_member183473 · Accepted solution]

That does not work for 4.1.

It complains that those parameters are no longer supported.

Thanks for the quick reply

[arijit_das · Accepted solution]

did you try making log_level = high ?

[arijit_das · Accepted solution]

1586166 - How to enable tracing for BI4.x client applications

This talks about 4.1 too where importance parameter has been replaced with log_level.

[former_member183473 · Accepted solution]

Did that one, but no MDX showed up on the log.

Searched for "select" on the file and for the query name, but couldn't find anything.

Tried activating the log "high" on the server side and looking at the webintelligence server, no success as well.

This is frustrating.

Thanks for the help man, do you have any other ideas?

Best

Leandro

[arijit_das · Accepted solution]

Your report is on top of OLAP universe -right ? If you use BICS, that will not generate MDX.

[former_member183473 · Accepted solution]

It is on top of a BICS connection... Am I able to catch that MDX?

Best

Leandro

[arijit_das · Accepted solution]

BICS does not use MDX.

[arijit_das · Accepted solution]

Check this doc for details:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/302cb4a7-226d-3010-0099-9555032fc...

[former_member183473 · Accepted solution]

Did not know that....

Thanks for the help man.

Best Leandro