Hw to chk Report SQL?

building reports webintelligence
1

hi all,
I have created a universe on BEX query.
while creating the report am not able to find the SQL/MDX query it has generated for the Report.
Is there a way to find out the Report SQL for Bex Universes.

  Thanks in advance

Regards,
Suneel.

suneel445 :india: (BOB member since 2009-09-17)

2

Hi,

For any OLAP cube based universes , currently in BOXI 3.1 SP2 - you cannot see the MDX through report panel. However you have two options.

  1. There is a way to set registry entries to capture the logs. SAP support might be able to provide more details on that.

  2. The way we do it, is that we run a tracer on the cube, so any queries that BO fires against the cube can be captured.

Regards

ramaks (BOB member since 2009-03-31)