BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

XI3 Instance Viewer
1 members found this topic helpful
Goto page 1, 2  Next
 
Search this topic... | Search BOB's Downloads... | Search Box
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Author Message
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Mon Dec 27, 2010 3:45 pm 
Post subject: XI3 Instance Viewer

Author: Joe Peters (with thanks to Rachidb)
Platform: MS Excel
Version: 1.0
Notes:
Quote:

This is a fork of Rachidb's "Instances Viewer" with the following additions:
  • Support for XI3 (note: the scheduling info for XI3 is very different from XIr2. I think I have the logic nailed down.)
  • Added Server Group to the display
  • Formatted Duration and Delay as D hh:mm:ss
  • Save login info, so as not to display the logon box at each refresh
  • Event info is displayed in the "Schedule Type" column, rather than a separate column

The Saved Login logic works by saving the cms, ID, password, and Auth method into a hidden sheet. The content of the hidden sheet are erased when the workbook is closed (via auto_close), so the credentials won't be saved with it. However, the info is visible (in slightly encrypted form) in the hidden tab before the workbook is closed.



xi3sched.xls
 Description:

Download
 Filename:  xi3sched.xls
 Filesize:  192.5 KB
 Downloaded:  4672 Time(s)

Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19332
Location: Bratislava


flag
PostPosted: Mon Dec 27, 2010 4:11 pm 
Post subject: Re: XI3 Instance Viewer

Moderator note:
Approved, and moved to BOB's Downloads.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
karen
Principal Member
Principal Member



Joined: 18 Jun 2003

Posts: 397



PostPosted: Sat Mar 26, 2011 1:17 pm 
Post subject: Re: XI3 Instance Viewer

Hello,
I'm trying to use the Excel SDK to view instances and i'm getting "No response from server,time out exceeded".I have CMS registry key values set to time out after 20 minutes,but this error is showing up after 10 minutes though.

Any ideas?
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Sat Mar 26, 2011 7:32 pm 
Post subject: Re: XI3 Instance Viewer

Not sure if this is the same problem, but I had the same thing happen last week. Turned out we had around 100,00 failed instances due to this issue.

Joe
Back to top
writetoprav
Senior Member
Senior Member



Joined: 09 Apr 2007

Posts: 72
Location: Chicago, IL


flag
PostPosted: Fri Apr 01, 2011 3:20 pm 
Post subject: Re: XI3 Instance Viewer

Thanks a lot of the tool..this is really helping me out.

Is there a way to get the parameters in the report for all the instances.

Any help is appreciated.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Fri Apr 01, 2011 5:08 pm 
Post subject: Re: XI3 Instance Viewer

Unfortunately, according to this post, no.

Joe
Back to top
karen
Principal Member
Principal Member



Joined: 18 Jun 2003

Posts: 397



PostPosted: Thu Apr 05, 2012 8:04 am 
Post subject: Re: XI3 Instance Viewer

Hello,

I changed CMS thread timeout after N minutes to 60.But i still get "No response from server,time out exceeded" error message after 10 minutes.

Does anyone knows how to resolved this.Please advice.

Thanks
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Thu Apr 05, 2012 8:44 am 
Post subject: Re: XI3 Instance Viewer

Not sure exactly... I would check:
  • CMS and authentication are correct
  • Desktop apps (DeskI/Designer) are correctly installed
  • Log in is possible from desktop apps using the same credentials

Joe
Back to top
ChrisW1204
Principal Member
Principal Member



Joined: 21 Apr 2011

Posts: 248


flag
PostPosted: Fri Jul 06, 2012 10:55 am 
Post subject: Re: XI3 Instance Viewer

Does the macro discard some records? The spreadsheet returns 556 records but when I run the generated query in Query Builder I get 845 records. (NOTE: Some of the records are NOT valid and I'm not sure why Query Builder would include them. The date ranges are WAY older than the criteria.) I'm just trying to look at the last couple days. Any help/advise?

End Goal : I trying to create a java program that will display schedule results and allow reports to be rescheduled. I can't get my query results anywhere close to the results of this spreadsheet or Instance Manager (around 450).
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Fri Jul 06, 2012 11:11 am 
Post subject: Re: XI3 Instance Viewer

Yes, there is some filtering done once the query is complete. It was done because of some quirkiness/bugs with the date fields in XI3; I haven't revisited it since I applied SP3.1, so the logic may need to be changed again.

Check the getBOXISchedules routine, after For Each oInfoObject In oInfoObjects. It calculates the date to use based on either si_nextruntime or si_creation_time.

Joe
Back to top
ChrisW1204
Principal Member
Principal Member



Joined: 21 Apr 2011

Posts: 248


flag
PostPosted: Fri Jul 06, 2012 12:14 pm 
Post subject: Re: XI3 Instance Viewer

Looks like this IF statement filters them out based on some more date criteria.

Code:
           If (dSchedStart >= startdate And dSchedStart <= enddate) _
                Or (dActualStart >= startdate And dActualStart <= enddate) Then
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Fri Jul 06, 2012 1:10 pm 
Post subject: Re: XI3 Instance Viewer

Yes, exactly. Look just above it for the definitions of the date variables.
Back to top
summoner
Principal Member
Principal Member



Joined: 17 Dec 2008

Posts: 296


flag
PostPosted: Sun Aug 05, 2012 8:14 pm 
Post subject: Re: XI3 Instance Viewer

Nice work. It save me some time to access BO directly icon_biggrin.gif

I've got a few comment/suggestions.
1. The formula of "Avg Duration" and "Avg Delay" use SUBTOTAL. I think it should be something else
2. The duration field is shown as ":00", ":04:00", etc
3. Cannot find records within date range (Date format issue?)
4. Current design cannot be used for scheduling. (lazy icon_rolleyes.gif )
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6671
Location: Connecticut, USA


flag
PostPosted: Mon Aug 06, 2012 7:24 am 
Post subject: Re: XI3 Instance Viewer

Hi summoner,

summoner wrote:
1. The formula of "Avg Duration" and "Avg Delay" use SUBTOTAL. I think it should be something else
SUBTOTAL is the correct formula, as it dynamically recalculates based on the currently selected filter. But it is broken -- the Avg Duration should be pointed at column L, and Avg Delay at column M. And both should be formatted as h:mm:ss

summoner wrote:
2. The duration field is shown as ":00", ":04:00", etc
That's correct -- it's in h:mm:ss format

summoner wrote:
3. Cannot find records within date range (Date format issue?)
What do you mean? In the dialog box that appears when you run the macro?

summoner wrote:
4. Current design cannot be used for scheduling. (lazy icon_rolleyes.gif )
What would you like it to do?

Joe
Back to top
summoner
Principal Member
Principal Member



Joined: 17 Dec 2008

Posts: 296


flag
PostPosted: Mon Aug 06, 2012 7:51 pm 
Post subject: Re: XI3 Instance Viewer

#1,2 - got it
#3 - After further checking, it is found that it is my problem icon_lol.gif
I propose #4 because of my laziness. Say I would like to setup a schedule job that runs on my desktop for checking yesterday's schedules. They I do not need to open the file and choose the date range icon_rolleyes.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> BOB's Downloads  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0360 seconds using 20 queries. (SQL 0.0061 Parse 0.0025 Other 0.0274)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo