BOXI SDK, VB.NET, and Appworx. Can they all work together?

scheduling XI Scheduler
1

We have a folder with over 200 reports.

They’re all the same report, just with different parameters.

Since we’re going to be upgrading to BOXI soon, I thought I’d try and fix this mess.

I’m a .NET developer, and I was wondering if what I was thinking was even possible.

We have Appworx, and I was thinking of creating a .NET app that would loop through a LOV and use just one physical report to generate all the instances.

So, it’s a .NET job triggered by Appworx that loops variables through a report.

Is this the most efficient way of doing this?

jbetts (BOB member since 2006-01-06)

2

If it helps to clarify a bit, this is going to be all back-end stuff.

No front end or user input is going to be used at all.

Just some kind of .NET app that runs each morning and loop-generates reports based on a list of parameters.

jbetts (BOB member since 2006-01-06)

3

This is the sort of thing that Broadcast Agent was designed to do, but you can just as easily do it from a Macro in full client (assuming these are full client reports), or an asp/jsp script for webi docs.

Hayden_Gill :australia: (BOB member since 2002-08-15)

4

I’m not an expert on the XI scheduling functionality yet, but I believe it has built-in bursting capabilities. Have you researched that option?

I’m going to move this topic to the XI scheduling forum, but leave a copy in the SDK forum as well.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

5

Thank you.

I looked into bursting, but it initially appears that bursting is more about security (who can see what data in the report) then actually “looping” the reports.

Also, from what little I can gather, it sounds like you need to use Desktop Intelligence with bursting?

jbetts (BOB member since 2006-01-06)

6

Did you move further with this. I am trying hard in looking into bursting capabilities using DeskI however still cannot get a definitive picture. I will appreciate if you can share ideas.

Thanks, Mani

nnemani :canada: (BOB member since 2004-09-28)

7

We decided not to do Bursting or use DeskI.

Instead, I just wrote a script that creates a large directory of subdirectories, and places “new” reports in each of those with appropriate parameters.

I’m attaching a zip file with 3 asp files in it.

global.asp & functions.asp are universal pages that i include on a bunch of other pages. you can probably merge the two if you wanted.

functions.asp has a bunch of useful functions:

ReturnReportID
ReturnFolderID
AddFolder
AddReport

rcreports.asp is basically a loop to call those functions and pass in specific parameters.

I documented farily well I think, but if you need to know more let me know.
scripts.zip (3.0 KB)

jbetts (BOB member since 2006-01-06)

8

Hi,

Can i use this code for Web Intelligence reports?
We are using BO XI R1 and IIS on Windows.

Thanks

harikodali (BOB member since 2003-08-29)