Retrieving Historic Lock Statuses

[Former Member]

Good Afternoon,

One of our tables on the servers is .dbotblfinreplock and houses all the present & historic data re the work status of entities. In BPC for Excel you can use the EVLCK command to return the latest entry (lock status). My question, is there any command or way in which you can retrieve the historic statuses for a certain time, entity or category from the table in BPC for Excel?

Many Thanks in Advance

[Former Member]

Is there not a way to get this information in BPC for Excel, as we currently have an issue with Reporting Services, which will not allow us to run any reports in BPC.

[Former Member]

Go to BPC-WEB,

select in the actionpane 'launch BPC System Reports',

select in the actionpane 'Work Status Report',

This report should give you a list of all changes made in the workstatus tables.

Alwin