Skip to Content
avatar image
Former Member

Utilizing OLAP-CACHEof Webi reports for Design Studio

Hi Team,

I want to use OLAP cache generated from Webi Reports to be used for design studio , the Idea is to schedule the webi reports so that cache will be generated in BW so when the Design studio App opens for the very first time after data load can use the cache in BW so that we can reduce the startup time , i have used all performance optimization techniques in Design studio, I was able to generate the cache at same level using Webi and design studio but two different cache is getting generate , I was able to check the Design studio is reading from the cache , i have used the link below for references.

http://scn.sap.com/thread/3789915

Regards,

Bala

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 08, 2016 at 02:03 PM

    Hi,

    Is that a question ? 😊 It seems you were able to get something of it ...

    BW OLAP cache can be used, yes. You could, for instance, generate it in a process chain.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 08, 2016 at 02:30 PM

    Good morning Bala,

    there is a solution from a Partner Company APOS for that scenario. It allows you to use the scheduled Web Intelligence report as a data source or use an instance as a data source.

    regards

    Ingo Hilgefort, Visual BI

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 09, 2016 at 06:37 AM

    Hi Experts,

    Thanks for your valuable suggestions , we don,t want to use webi's scheduled instance , we are using BICS connection to Design studio applications , and our applications has good response time,

    The issue is, when the very first time we open the dashboard after data load the initial startup time is more , because the cache gets invalidated after data load ,

    to generate the cache we must use bex broadcaster to build OLAP cache which depends on JAVA stack to be present in the system , we don't have JAVA stack, is there any possible workaround to generate cache after data load .

    To generate cache we are trying to use webi and are able to create cache but the problem is the cache generated by webi and design studio application is different pls suggest any work around

    Note : we dont want to use Webi's scheduled instance

    Regards,

    Bala

    Add comment
    10|10000 characters needed characters exceeded