EPM function

[Former Member]

hello!

I have three different forms for the same model, bpc 10 version. I need to display the date last saved data of each sheet.

Help solve this problem.

thank you

[Former Member]

Hi Sergey,

Have you tried to use the date function in excel, e.g =now(), and then submit the time with a EPMComment() function.

This way you can establish when last the data was submitted on the sheet for that specific data intersection.

I have done it in the BPC 7.5 version which worked quite well.

Regards

Henry

[Former Member]

Hi Sergey,

you could see the last modified date for the workbook but you haven't informations about the single worksheets, so you have to check every single worksheet and see which contains the last updates.

Regards

     Roberto

[Former Member]

I'm sorry I did not understand.

for example I have 2 sheets. 1 sheet I have saved data in January, the second sheet in March. where I can see these information?

Regards

Sergey

[Former Member]

Hi Sergey,

I'm on 7.5 but I think Youshould have this information also on 10 version, when Youclick on Save dynamic template  on eTools you should see right of the workbook name the last modified date.

Otherwise Youshould go to application server on ...\Webfolders\<appset>\<model>\EEXCEL\INPUT SCHEDULES or the folder where You saved the templates and see the date, but attention this is the date of the entire Workbook not of the single worksheet You will not find this information.

Regards

     Roberto

[Former Member]

Hi Sergey,

sorry I've misunderstood your request.

You can see the date of the data you saved if you have enables the data audit. The informations are in DBextra and you have some report like data audit reports to filters and extract this informations.

Sorry again and regards

     Roberto