Last Data Update in Visual Composer and Web App Designer

[Former Member]

Hello,

We want to show the last data update in query result and we used 2

differents ways to do it: throught Web Application Designer (SP 12) and

Visual Composer (SP 10).

In query result of Web Application Designer, the last data update came

in GMT0 and in visual composer came ok (GMT - 3, that's our time zone).

This value (ROLLUPTIME) is taken out of the RSMDATASTATE table and this is used in SAPLRSMDATASTATE program, that is called by Web App Designer.

Why does the difference exist between: Web App Designer and Visual Composer for last data update?

So, I need more information how the Visual Composer brings the correct value (in our time zone) and Web App Designer in GMT0.

Best Regards,

Pablo Moraes

[Former Member]

Hi Mario,

Yes, i used the same user and the same query to access the information. But, how can i check the mapping from my VC user to the BI user?

Regards,

Pablo Moraes

[Former Member]

In the setup of the connection in the Portal (see the Visual Composer WIKI) you have to specifiy of how the users are mapped from VC to BI (SSO, or explicit user & pwd). If the VC user is mapped to a different BW user as you normally use, then I would check the locale settings this other user has.

[Former Member]

Do you use the same user for accessing the information via WAD and VC or is it a different one? (note: check the mapping from your VC user to the BI user)