Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.