CurrentTime() Not Quite Current Time?

building reports webintelligence
1

Hi All,

The function CurrentTime() it looks to me like this is last refresh time or something, can someone confirm that?

Thanks,

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

2

Nope.

Drag a blank cell onto the canvas and insert a currenttime() function - it shows the time. Then delete it and repeat - different time, at least for me.

=lastexecutiontime()

…should show the time at the last refresh.

Version info in sig.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

3

Hi Mcnelson,

Happy new year.

I guess what I mean is the time doesn’t change after you drag it across to the report, so it’s not current by definition. It’s the time that you drag it over. Then the only way to update the cell without replacing is refreshing queries.

Does that make sense?

Thanks

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

4

Does it “refresh” when you have Created / amended a variable, haven’t tried, just interested?

Mak 1 :uk: (BOB member since 2005-01-06)

5

If its the current time var then yes, if you mean another one then no.

It doesnt matter too much for what I am doing- report with various tables which are conditionally hidden based on time and day and the report scheduled to different groups based on their view of the sensitive data.

Just interesting!

Thanks,

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

6

Hi Thomas,

Regarding this:-
the report scheduled to different groups based on their view of the sensitive data.

You may want to have a look at this trick, if you have not done so, already:-

http://trustedbi.com/2007/11/07/row-level-security-with-webintelligence/

Mak 1 :uk: (BOB member since 2005-01-06)

7

Other actions causing the currenttime() to refresh:
[list]Changing report tabs & returning to the original tab
Resizing cell containing currenttime()
Selecting a value via an Input Control[/list]
Agree, it’s probably not the best idea to base a security mechanism on.

NMG

mcnelson :uk: (BOB member since 2008-10-09)

8

Hi Mak,

Sorry I was typing off my phone and didn’t really explain that well enough.

Basically my report has 3 cross tabs, the first cross tab is for yesterday and is always present. The second crosstab is for two days ago and is hidden unless a prompt date is entered, or the report run time is between 7.00am and 7.05am. The third cross tab is the same as the second.

I am familiar with row level security as defined in the universe - I haven’t yet found a use for it, as I tend to restrict rights at the database / table level based on groups, and a Universe security model based on AD groups.

Thanks,

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

9

The link above is a little different, row level security for instances :).

Mak 1 :uk: (BOB member since 2005-01-06)

10

Really?

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

11

Yep, you need a security table in your universe, but it uses a combo of BO user and current user to filtyer the results. Simple but clever.

Mak 1 :uk: (BOB member since 2005-01-06)