BO Advance analysis 1.1.4, Info Field like Last Data Update Table

[former_member182346]

Hi Experts,

I am using BO Advance analysis 1.1.4 for reporting output. There we have option to show Info Field like Last Data Update.

It is using this function to get that info :

=SAPGetSourceInfo("DS_1", "LastDataUpdate")

Anybody have idea what BW table it is refering to get that info.

As per my understanding, since these workbook of Adv. Analysis are refering Query which are built on MultiProviders, it go and find out the last cube/dso successful data load.

Also I manually checked the date and time of last successful update in cube, but it is not matching as far as time is concern. Date is matching.

Please help me to get the correct table which gave that info (date and time).

Thank-You.

Regards,

Vinod

[former_member182346]

Hi,

Thanks for your reply.

It's around 15-20 min. time difference, not fixed on daily basis.

I want to check with SP7, where will I found it to download ? And how can I apply it ?

Regards,

Vinod

[TammyPowlas]

Hello Vinod,

Go to service.sap.com/swdc

Select Support Packages and Packages

Look under "A" for SBOP Analysis

You simply download it and then reinstall.

I am not sure SP 7 will fix; however before you submit an OSS ticket that will be SAP Support's first question/request - they will want you to have the latest patches installed.

Good Luck,

Tammy

[former_member182302]

Hi Tammy,

I was trying for the similar requirement to get the "Last refreshed time" of the table used in the calculation  view  in HANA.

It uses the same formula : =SAPGetInfoLabel("LastDataUpdate")

But since Analytic View actually doesn't store any data, it is virtual. The date am seeing is the last changed date. i.e if i do any changes on the model, am seeing the last date when I changed it.

Is there any function which we can use to get the Last refreshed date of the table in the model am using?

Regards,

Krishna Tangudu

[TammyPowlas]

Krishna  - I recommend creating a new thread in the Analysis Office space

I am not using HANA so perhaps other experts can assist.

Thank you,

Tammy

[former_member182302]

Hi Tammy,

Sorry once again i didnt notice that Am in a wrong space here. I thought this question is relevant to this thread.

I will open a new thread as recommended by you.

Regards,

Krishna Tangudu

[TammyPowlas]

Hello Vinod,

I am on a later version of Analysis Office, and I noticed that the time of the refresh is off by a few minutes.

How far off is yours?

Anyway, SP 7 was released on 11/17 (this last Thursday) so maybe you could download that and see if you still experience this issue?

If you still experience this issue I recommend submitting a product error.

Regards,

Tammy