Repository Variables not Refreshing

Newuser1

Hi All,

In report level dynamic repository variable was not refreshing it is showing old data . When we test the variables in RPD initialization block it is showing the updated values but the values are not refreshing in report level. We cleared cache also but no luck can any one suggest on this .

OBIEE Version: 11.1.1.1.7.1

Data Base: Sql server

Thanks in Advance,

SriniVEERAVALLI

What value you set for Refresh Interval in Init Block?

Proper setting might help you.

https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/variables.htm#BIEMG354

Newuser1

Hi Srini,

Thanks for your reply.

Refresh interval was set for 4 Hrs .

[Deleted User]

"Are not refreshing in report level"

Are you sure that your "reports" (that's "analysis" by the way= aren't simply cached because no one thought about that and you're simply hitting stale cache?

Newuser1

No, It's not refreshing in report level we cleared both presentation  and RDP cache .

Does any thing we need to do from RDP level ...?

[Deleted User]

Ok so it's been years since I even touched .7 so I didn't remember this one but I think you're just on one of the messed up .7 versions below the necessary BP level:

MOS Doc ID 1992356.1

d68efe57-71d2-4721-9e90-2ce664562e23

Hi Guys,

Even Am facing the same issue from yesterday. It was refreshing fine till yesterday but it is giving problem now. Am using the Essbase Substitution variables.

I have cleared cache of both the servers but no use. Is services restart could do something? Any help would be appreciated.

Thanks,

Santosh