IP Planning Sequence Execution Log

[Former Member]

Hi Folks,

We have many planning sequences attached to the reporting in Portal. We have faced an issue recently. We believe that this issue might be because of a user entering into an obsolete report and clicking on button, which triggered the obsolete planning sequence. We can able to see some records against the user in the planning cube, which are causing the issue. However, user declines by saying he has not accessed that report.

I have checked the background jobs and used the RSPLS_SQLOG* tables and program RSPLS_PLSEQ_LOG. None of them really helped me.

Now my question is how can we see the execution log of a planning sequence which gets triggered in Web(portal)? I would like to get the username of the person who accessed the report and executed the planning sequence at the time when the issue has occured.

Your help in finding this would be greatly appreciated.

Regards,

NS

[former_member5472]

Hi,

Portal has its own trace/log files.

Can you check from you portal resource if it can be pulled out from there ??

also you already hve the audit trails in you cube which states which user has enerated the data set at waht time and date.

It should be sufficient evidence.

Thanks

Pratyush

[former_member5472]

Hi,

We can able to see some records against the user in the planning cube, which are causing the issue

How are you verifying this ? Do you have any audit trail mechanism where each record generated in plan cube is placed against user name/time- date etc ??

Try T-code SLG1.. Check if you can fine anything from the application log ? If its a background job, you can find out the user name which has trigerred the job.. SM37 may help for backgrnd job ..

Thanks

Pratyush

[Former Member]

Hi Pratyush,

Yes we do have audit data which gets stored in the planning cube.

I have already tried SLG1 and back ground jobs. No luck.

Any other way of finding an execution log of a planning sequence, which has been run from the protal report?

Regards,

NS