system
January 15, 2008, 4:58pm
1
Has anybody who tried access BO CMS Repository XIR2 and provide reports from it?
We are not going to use Data Integrator.
Thanks in advance for any responses.
Mike
usmwi (BOB member since 2007-02-28)
system
January 15, 2008, 5:04pm
2
Create reports from CMS repository is nothing but designing reports from a auditing universe
rollings007 (BOB member since 2007-02-15)
system
January 15, 2008, 5:36pm
3
Hi
We have an Downloadable available in the forum to get the BOXI User List and Groups.It may help you…
Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership.
It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description.
Platform: BO XI R2 / BOXI3.1 (it’s necessary to change the libs to fits XI3.1, s…
Regards
Siva.M
looksmee (BOB member since 2006-02-08)
system
January 15, 2008, 6:55pm
4
Thank you for the responses.
Also, is there a way to report Universe relationships with all report objects? Example, if a Universe needs to be changed produce a list of all report objects that would be effected.
Mike
usmwi (BOB member since 2007-02-28)
system
January 15, 2008, 7:11pm
5
Download Security Viewer from Bo website
rollings007 (BOB member since 2007-02-15)
system
January 15, 2008, 7:12pm
6
Hi
Try on BOB Downlaods…There is an Link which helps to Document your Report with List of Object used.But i dont think you can automate the process to identify the list of reports effected due to the changes on the Universe. Needs to do it manualy…
Author: Dwayne Hoffpauir, EDS
The attached utility will record objects that are used in a series of reports. Usage is as follows:
[quote:61cb8b7957=“Author’s notes”]- Create a temporary directory.
Place all documents (.rep files) to be analyzed in that directory.
Place this document in that same directory.
Open this document, and refresh.
Each document in the directory will be opened, and data provider objects recorded.
There will be a lot of screen flashing as the documents are opened and…
Regards
Siva.M
looksmee (BOB member since 2006-02-08)
system
January 15, 2008, 10:49pm
7
This thread may be of help to you:
Just wanted to clear up a few things in this thread:
The query builder is a very simple web ui which allows the user to enter a query string which will be passed to the IInfoStore.Query function.
The query string passed to the InfoStore is not real SQL and you don’t reference real table names, but its use is very similar and well documented. The reason Crystal Decisions went for this sort of syntax was because most people are familiar with SQL so there’s no huge learning curve and it’s very f…
crystal01 (BOB member since 2006-08-30)