Ttrack BPC reports run time (excel reports created on EPM ) on a daily basis

[Former Member]

Hello, Experts!

Is there any way to track BPC reports run time  (excel reports created on EPM )  on a daily basis?

Ex: In BW,we have ST03N and technical content reports that can help to  look at Bex queries runtime.Similarly,how do we track BPC excel reports runtime on an ongoing basis?

I already experimented with BPC statistics(UJSTAT and UJ0_STAT_DTL) that can record the runtime But,they don't show the corresponding BPC report information rather seems to be session ID driven.

We are on BPC Standard NetWeaver 10.1  with BW 7.4.

Appreciate your thoughts here.

Thanks,
Swapna

[former_member186338]

The same question was asked number of times Looks like some customers do not understand the difference between some application and Excel file!

[Former Member]

Hi Swapna,

What do you mean by tracking the reports runtime??? Could you please explain your purpose to track the BPC EXCEL Reports???

Regards,

JP

[Former Member]

I am sorry for the confusion.I mean monitoring  the BPC  reports runtime trend on a daily basis.

Ex: If we look at Bex queries,SAP delivered a set of standard technical content reports that can be used to look at the overall query execution time over the period, I would like to know if there exists a similar way to monitor BPC reports runtime ?

[former_member186338]

Sorry, but BPC server has no idea about reports filenames and locations... same filenames can have different reports inside etc...

You have the user making some requests to cubes using Excel as frontend.

[Former Member]

With the help of  UJSTAT or "UJ0_STATISTICS_DELETE",We can certainly look at at the report runtime breakdown at a detail level.However, this is not showing the BPC report name.

.

[former_member186338]

And it will not show! There is no unique report ID, file can contain multiple reports, file name is not unique etc...

Is it clear?