Partial Results Warning

building reports webintelligence
1

Hi Bob,

I’ve a row limiter in my Universe Designer and I know some queries give me partial restults.
I know we have a warning using Infoview about partial results.
But I’ve many users using XLS format file. Is there a way to show users they have partial results in an Excel file? Indeed, it’s written anywhere contrary to .wid format.

Thanks in advance. Hoping i’m in the good section.

BR,

Alexandre.

avivier (BOB member since 2010-06-08)

2

[Moderator, can we move this topic to Web Intelligence reporting, thanks]

I’m assuming you’re using Web Intelligence for reports and you’re on XI3?

In XI3, and I think it is also available in XIr2, there is a formula DocumentPartiallyRefreshed which returns true if the doc contains partial results.

Add a cell somewhere in your report that checks this value and displays a warning message if true. When false display nothing and set cell to hide when it contains no data.

regards

AL

agulland :uk: (BOB member since 2004-03-17)

3

[Moderator Note: Moving to WebIntelligence XI forum]

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Thanks, but please use our report feature which helps us to attend all such requests even if we don’t go through this topic.

You can always report a post using the proper icon, found on the lower right-hand corner of any post.

Jansi :india: (BOB member since 2008-05-12)

5

Thanks every body…

Would it be possible to put the DocumentPartiallyRefreshed() function in a object in Universe?
The aim is to avoid final users to write this formula in their reports (quite lazy) and just drag and drop the object…

Thanks in advance.

avivier (BOB member since 2010-06-08)

6

The function you mentioned is for report level only.

Jansi :india: (BOB member since 2008-05-12)