BusinessObjects Board

Caching of data using Web Services (BIWS) in Xcelsius?

other Xcelsius - Crystal Dashboard Design
#1

I’m using the BI web services to get data in my xcelsius dashboard(ent 2008)

I’m noticing the data is cached. I’ve also read about it.
But I can’t seem to figure out when the cache is refreshed?

When I log out, close web browser, the cache remains!
I’ve even set the temp/cache settings of IE to “every time a visit the page”

But the cache still pops-up.

Is there a setting somewhere in CmC?

Tiny :netherlands: (BOB member since 2004-11-10)

#2

There are several settings in the CMC related to caching. You should primarily look at the settings for the Processing servers. The topic is a bit big for here, but the admin guide does a pretty good job of explaining it.

Lugh (BOB member since 2009-07-16)

#3

I’ve read the admin guide (bits of it) but I’m confused.

I thought (or hoped) there were some specific chache settings for the dashboard/BIWS part. But all I’ve read about is general webi cache.

So if I set those chache settings for webi my BIWS connectors will behave accordingly?

Tiny :netherlands: (BOB member since 2004-11-10)

#4

Yes. The BIWS actually use the Adaptive Processing Servers and WebI Processing Servers to parse the request and retrieve the data. You are essentially loading a WebI in every way except loading the visible elements.

Lugh (BOB member since 2009-07-16)

#5

I’m having troubles setting up the right cache settings.

What I want to achieve is the following.

  • datasource BIWS
  • scheduled latest instance from webi report
  • every dashboard user can see all data in the webi-source report

I want my dashboard to get the CACHED scheduled webi results cause they are much faster then retrieving the latest scheduled instance.

To achieve the above, I’ve done the following:

  • set up my BIWS with the setting “share report for all consumers” (see screenprint below)
  • scheduled the webi report in CmC with the following Cache setting: Caching: Standard HTML (see second screenprint below)

But the result is not what I want. At first opening, the dashboard still retrieves the webi blocks from the scheduled latest instance and does NOT get them from the CACHE.
I can notice this because a second time I open the same dashboard, data is retrieved MUCH , much faster (and is using the cache, I think)

How to retrieve the webi data from cache for the xcelsius dashboard?

  • all the cache settings on CmC server side are left to default (for all servers)
    Schedule_cache_settings.PNG
    BIWS_Blocksettingd.PNG

Tiny :netherlands: (BOB member since 2004-11-10)

#6

I just got a message back from SAP support regarding the issue in the post above (webi not using cache FIRST time)

it seems to be normal behaviour.
So cache is populated, but not used the first time somebody watches the scheduled instance. The second time a user watches this same instance the cache is USED.

They are investigating this because SAP themselves think this is a litlle bit odd behaviour.

To be continued

Tiny :netherlands: (BOB member since 2004-11-10)

#7

and SAP Support got back to me stating it’s a bug and picked up bij development team to be fixed (somewhere in the Xi 3.1 SP7 fixpack range)

Tiny :netherlands: (BOB member since 2004-11-10)