BusinessObjects Board

Running A report against the BOXI Repository (CMS)

sdk development
#1

Could someone please let me know / send me a code snippet that uses VBA data provider to query the BOXI repository.

I need to run few simple reports against the BOXI CMS against the following Tables

CI_INFOOBJECTS
CI_SYSTEMOBJECTS
CI_APPOBJECTS.

regards

:?

revojs :india: (BOB member since 2006-05-25)

#2

Check this CMS SDK
.

haider :es: (BOB member since 2005-07-18)

#3

Thanks very much Haider.

I tried to do exactly the same , not sure if I miised out anything.
The last bit may be , I may not have understood.

  1. Save the VBA code, name the report, close any vba windows and on the “Access Data From VBA” window: Highlight “ThisDocument.getRepoUsers” and run the the code.

I copied and pasted “ThisDocument.getRepoUsers” , does not bring anything. I have changed the admin/ password.

There isn’t any error showing up , just blank , I have attached a snapshot.
test.doc (51.0 KB)

revojs :india: (BOB member since 2006-05-25)

#4

It means to save the VBA procedure by clicking on save button in VBA editor, it will prompt for report name
Then close the new report wizard and run the procedure from Tools > Macro > Macros menu in DeskI
You will be prompted to run the getRepoUsers sub-routine
.

haider :es: (BOB member since 2005-07-18)

#5

Thanks for your help Haider, It is working finally !

Next

how can we modify this code to make it return two column , I tried to returm multiple columns but it returns me the first columns copied into last column.

revojs :india: (BOB member since 2006-05-25)