Force not to refresh a column or a block in WEBI

building reports webintelligence
1

Hi,

I have searched the forum, all the topics raised so far are with regards to WEBI displaying Partial results due to various reasons. My query is exactly opposite, let me tell you an example the user requirement is for example: On a weekly basis they need to capture Pending, Opened and Closed Work Orders for that week, Opened and Closed is not an issue as I can retrieve the orders on the Date Dimension. The Pending figure as expected keeps on changing i.e. Week1 there could be 10 pending orders, Week2 15 and Week 3 5.
Now in the database we do not store history information :frowning: so what I want to do is say we are in Week1… now get the figures add one more column next Week i.e. Week 2 but refresh information only for Week2 and leave Week1 information as it is.

Hope I have been clear with my issue. Please let me know any feedback at all.

Many Thanks in Advance and have a great weekend.
Cheers

friend123 (BOB member since 2008-05-30)

2

Plainly speaking, you want BO to retrieve a value at a later point when that value is no longer in the database. That is not possible on the BO side. You should be looking for a database solution for this one.

vinod_menon :india: (BOB member since 2007-04-09)

3

Thanks Vinod with your reply, as it validates my assumption.

friend123 (BOB member since 2008-05-30)