Can't see any metadata - lineage & impact analysis

I’m very new to this - I’ve read through the documentation (and still looking through it) but as yet have not found a concise step-by-step guide of the things I need to do to make this work. I’ve also searched through these forums and found lots of relevant info, but still not yet found the magic bullet which will make my problems disappear :slight_smile:

I’m using XI 3.1, which was installed by our service provider onto Windows 2003. Data Services XI was also installed by our service provider onto the same server. We have an XIr2 system in our Live environment - a copy of this was taken, and then upgraded to XI 3.1. I’m hoping to use Lineage and Impact Analysis to identify which reports use a handful of “faulty” objects in the newly-upgraded XI 3.1 Dev environment.

As I understand it, during the installation of DS certain elements were not automatically deployed correctly. Our service provider manually deployed BOMM war files - so I can now access the BOMM web interface. (I can also access all the client applications, on the Windows 2003 server where everything is installed).

I can’t see any mention of Integrator in the CMC, though. Should there be something in there, and if there’s nothing there should I ask our service provider to manually deploy/redeploy additional war files?

So far I’ve done the following:

  1. A data store has been created. It’s called “BODS_TestRepos”, and I can see this in Management/Repositories from the Administrator section of the web panel. The database has a whole host of tables prefixed with AL_

  2. I’ve also created a Metadata Integrator by using the client tools on the server. This seems to have created a program object which I can see in Infoview and CMC.

  3. I scheduled the program job from within Infoview. It says it’s running, but it has apparently been running for nearly 18 hours. I can see job history, but can’t see anywhere to get logs - so I can’t see what this job is (or isn’t) doing.

  4. When I click on “Impact and Lineage Analysis” from the BOMM web interface, I can see my BODS_TestRepos, and a ‘datastores’ branch below it. But I don’t see anything else - when I use the drop-down to select universes, or classes and objects or whatever - nothing changes.

  5. From within Impact and Lineage Analysis, I’ve gone to settings and tried using the “Calculate Column Mapping” button (in the “Refresh Usage Data” tab). So far still nothing.

Any ideas what steps I’m missing, or what I’m doing wrong here? I’m reasonably ok with BO Enterprise in general, but I’ve never really played with any of the EIM stuff so this is all a little new to me :frowning:

Cheers!


gutted (BOB member since 2002-10-10)

Further info…

I’ve had confirmation that there is definitely stuff missing from the CMC. I don’t know ehether it’s the reason I can’t get the collector working, but it’s certainly not going to be helping things.

I was given to understand that BOMM didn’t deploy properly during DS installation, and was therefore deployed later.

Does anyone have any idea why (a) the BOMM didn’t automatically deploy; and (b) why I might be missing stuff from the CMC?

Cheers!


gutted (BOB member since 2002-10-10)

Can you provide more detail around this? What specifically, are you missing?


Atul Chowdhury (BOB member since 2003-07-07)

you are mixing 2 different products here, BOMM is differnet from DS Metadata Integrator

which product are you using for Impact and Lineage ? DS Metadata Integrator or BOMM (Business Obejcts Metadata Manager)

if its DS Metadata Integrator, then you will have to configure the Metadata Integrator for your CMS Server and run that from CMC once that completes you can see the Impact and Lineage in DS Management Console

if you are using BOMM then you will have to first install BOMM on BOE XI R3, and run the integrator for CMS and DS


manoj_d (BOB member since 2009-01-02)

Thanks for your replies :+1:

I’m given to understand - and indeed I have screenshots to indicate - that I should be seeing a “Metadata Management” icon below “Voyager Connections” in the CMC. Presently I can’t see this, even though I can tell that the software is installed as I can see all the client tools when I log into the server.

Thanks also for the clarification on the software - it turns out that I actually have Data Services installed (NOT Metadata Manager). When I launch the DS Management Console, I want to be able to access the “Impact and Lineage Analysis” section.

:!: The good news is that this now works! (after a fashion, at least). Our service provider logged a call with SAP, SAP contacted me, SAP told us that DS 3.1 isn’t compatible with XI 3.1. Our service provider installed DS 3.2 at the request of SAP, and now the collector runs and I can see output in the ILA section in the DS admin console.

It’s still a little weird though. For example - I know that there’s a certain class that exists in several of our universes. I know this, as it’s actually the class I’m most interested in. I can see all manner of classes (and what look like tables and views?) under each of my universes, but I can’t see the class I’m looking for. When I choose an object from one of the other classes, I can see each report the object is used in when I check the “Impact” tab. This is quite literally exactly what I want to be able to see for objects in my class called ‘User Defined’. Unfortunately ‘User Defined’ is missing from the 2 universes that are of most interest to me.

I’m going to run the collector again, as I suspect/hope it failed (or otherwise didn’t complete properly for some reason). When I logged onto the server this morning, I saw a Windows pop-up telling me that “Business Objects encoutered a problem and needed to close”. I’ll run the collector again and see if it can run without the error, and whether a successful/complete(?) run yields more results…


gutted (BOB member since 2002-10-10)

check the log file ? you can open the log file from CMC, see if there were any errors in collecting that class

other thing that you can check
if there are rows for that class in AL_CMS_UNV_OBJ table in DS Repository, you can filter by UNV_CUID (get this from AL_CMS_UNV table) and CMS_NAME


manoj_d (BOB member since 2009-01-02)