WebI XI 3.1 SP 3 View On Demand v.s. Scheduling

[Former Member]

Hello,

One of our customer has the following problem, when he try to refresh on demand a web intelligence report the refresh never finish, but if he tries to refresh document by scheduling it, the document is correctly finish and refresh.

We saw that several sessions are active, so we tryied to increase the Number of connexion (25 -> 50) and the number of document per user (5 -> 10) for each WebIPorcessingServer (2 in total). But, this not solve for problem.

Do you have an idea on how we can trace and solve that problem?

Note,

     the problem is not a database issue.

     the cutsomer has enough licences

     until now, the platform works correctly.

Best regards;

Laurent.

[Former Member]

Check the traces looking into the note 1335757. It is very informative to capture traces at run time.

Look forward to trace the WIPS. Do check whether the issue is particular to a users machine. If it is check whether the problem is due to cache of the browser.

[former_member191664]

Hi,

Since you are on XI3.1 SP3, the problem that "try to refresh on demand a web intelligence report the refresh never finish, but if he tries to refresh document by scheduling it, the document is correctly finish and refresh" could be caused by the load balancing issue among the WIReportServer.  See ADAPT01536471

Description:

In Web Intelligence, an error message may appear when refreshing a Web Intelligence document when a load balancer is used in front of the Application Server.

New Behavior:

This problem is resolved.

Or, the LOV performance issue in WIReportServer.  See ADAPT01551854

Description:

LOVs are not displayed in cascading prompts when refreshing a Web Intelligence document in edit mode(Java Report panel), but lovs are displayed when refreshing the document in view mode (dHTML) in XI3.1 FP3.4 and higher versions.

New Behavior:

this problem is resolved.

Limitations:

After XI3.1 FP2.10, XI3.1 FP3.4 a caching mechanism has been implemented to improve prompt performance. If the LOV has already been loaded a first time, and it is still available in server cache, then this LOV is displayed. If the

LOV is not available in cache, it is not displayed, except in ther 2 situations where there is no default value defined or there is no previous values defined. In these 2 specific situations the LOV refresh is forced, and LOV is displayed in the prompt.

I'd suggest you to consider upgrade your XI3.1 SP3 to SP6 or above to accommodate the WIReportServer memory, load balancing, and LOV fixes.

In addition, the performance difference between XI3.1 Webi refresh on demand vs. scheduling is that scheduling does not generate the pre-caching XML file on the fly unless the user enable the pre-caching.

HTML Pre-Cache

HTML Pre-caching can be used to generate the XML files at schedule time instead of at view time of the instance.   This is particularly useful for complex reports including those that contain many report level variables that perform calculations on the data stored in the data cube of the WebI document.

Using HTML pre-caching in WebIntelligence does not actually generate HTML files, but XML files.  The XML files are converted into browser readable files (HTML, image files) when viewed.  The SDK does this XSL Transformation on the fly.

To enable HTML pre-caching from the CMC:

1. Login to the CMC.
2. Navigate to the report to be scheduled.
3. Click Properties > Schedule > Caching Options
4. Under “Select the Formats to Pre-Load the Cache with when Scheduling“ check “Standard HTML”
5. Next select the locale the cache files are to be created in.
6. Click the “Update” button.
7. Click back on the “Schedule” tab.
8. Click “Schedule” button.

To enable HTML pre-caching from Infoview:

1. Login to the Infoview.
2. Navigate to the Folder containing the report to be scheduled.
3. Click “Schedule” link below report name.
4. Expand the “Caching the Options” section.
5. Under “Select the Formats to Pre-Load the Cache with when Scheduling“ check “Standard HTML”
6. Next select the locale the cache files are to be created in.
7. Click “Schedule” button.

So are for the Excel Pre-Cache and PDF Pre-Cache.  Thus, if you schedule a webi report with pre-caching on, you'd see the scheduling completion time would increase, too.

Hope this helps,

Jin-Chong

[Former Member]

Hi Laurent,

With the Schedule option we have an opportunity to select the required parameters for which the data/records is to be fetched from the reporting DB however with View-on-Demand it directly fetched all the data/records from the reporting DB.

In Schedule we can provide later time when the report is to be scheduled by View-on-Demand is on that instant.

Please let me know if ot helps....

Thanks,

Arun

[Former Member]

Hi Laurent,

I would suggest to create a trace and check the trace file what is happening. There might be quite a few different reasons for the same behavior which could be difficult to troubleshoot without tracing.

Cheers!!

Durga

[Former Member]

Hello Durga,

Thanks you, yes this is the next step.

Regards

Laurent

[Henry_Banks]

Hi,

What version, SP and Patch level please?

Have you checked the "fixed issues" list which is attached to the 'information' pop-up next to each BObj download at www.service.sap.com/swdc ?

this is the best way to check the latest corrections on that codeline.

regards,

H

[Former Member]

Hello Henry,

This a XI 3.1 SP3, with kind of trouble until few weeks, for the increase of users connected and refresh on demand.

regards

Laurent