BusinessObjects Board

Viewing lineage in Web Intelligence

dataservices metadata reports
#1

I seem to remember that after having configured and ran Metadata Integrator one is also able to view lineage of objects in Webi/InfoView. However, I don’t see anything anywhere in any of the panels when viewing a document. My question is whether or not my assumption is true, and, if so, whether it works out of the box, or whether I should be doing something else to make it work?

wahey :netherlands: (BOB member since 2007-05-31)

#2

after running the integrator for the CMS, to view lineage of objects used in WebI Reports you will have to open the WebI report in Interactive mode (you can set this in Preferences), you will see a lineage link for each object used in WebI Report when you select dataSummary page

check the integrator log, is the Integrator run successful ?
what is the version of MM ? did you enter the login information for InfoView Integrator in the Integrator configuration ?

manoj_d (BOB member since 2009-01-02)

#3

Hi Manoj, thanks for your answer. Yes, that’s where I thought I’d find it (in the Data Summary pane in interactive mode), but it’s not there. To be clear, we’re talking about Metadata Integrator and no Metadata Manager. I’m running BOE XI 3.1 SP3 with BODS XI 3.2 SP3 on the same windows Server 2008 R2.

I can run the cmsCollector.cmd fine, but running it from the Data Services folder in InfoView doesn’t work as of yet. I get the following:

wahey :netherlands: (BOB member since 2007-05-31)

#4

I was assuming BOMM, ok in case of DS Metadata Integrator ,the lineage information of DS gets updated in the BOE only when you create a Universe from DS Designer or update a Universe from DS Designer

I am not sure if you try to update a universe that was not created using DS Designer whether it will update the lineage details or not, I guess it would since DS Designer will create input file for universe builder and universe builder will update the Universe

try this will a test universe and see if that works

manoj_d (BOB member since 2009-01-02)

#5

Great, that seems to work. One thing, though. Why won’t it run from the Data Services folder in InfoView and is there no problem when running it manually in the command line?

wahey :netherlands: (BOB member since 2007-05-31)

#6

to populate DS linege information in BOE you don’t have to run the cmsCollector you will have to run the Calculate Column mapping from DS Desginer and export the DS to CWM and update the universe

to populate BOE Metadata in DS Repo you will have to run the Metadata Integrator, on successful completion you will see the lineage in Managemnet Console, you run this Metadata Integrator configuration from DataServices folder in CMC

if the Metadata Integrator is not running from CMC, what is the status of the job is it failed or success, if it failed check the reason why it failed and fix that (click on the status link from History)

manoj_d (BOB member since 2009-01-02)

#7

The status is success, but as you can see in my second post, there are a few errors in the text file. Running the cmsCollector manually doesn’t throw any errors.

wahey :netherlands: (BOB member since 2007-05-31)

#8

the universe collection is failing, could be COM/DCOM permission issue
is the universe collection successful when run from command line ?

can you check following
what is the user logon under which BOE SIA is running ? system default or a named user ? try changing this to same use that is logged in to the server when running from command line
or
BOE gives a option to run the Program object using a logon, enter the same user there and see if that works

manoj_d (BOB member since 2009-01-02)

#9

Hi Manoj, sorry, but I got a bit sidetracked with some other stuff. Yes, running the CmsCollector.cmd manually through the command line works properly. Running the CmsCollector via the program object in InfoView works well also when using the same user (the domain administrator). For obvious reasons I don’t want to use that logon. I want to use the user that runs the SIA (also a domain account, used as well for SSO). When I run it using those credentials I can the designer.exe and businessobjects.exe pop up in the task manager, but I do get the errors provided in my earlier post. How can I solve this?

wahey :netherlands: (BOB member since 2007-05-31)

#10

the problem could be with the COM/DCOM permission, what is the login when you run the cmcCollector.cmd from the command line ? same as SIA user or other domain user

try this
open a command window (cmd)
run the dcomcnfg command
this will open component Services window in this window expand Component Services -> MyComputer and select DCOM Config this will show the registered COM services, you may get some popup message about some missing entries, ignore those (click no)
Select Designer Class, right click and open Properties window
you can try following 2

  • select the identity tab, in this select the option this user and enter the same login that is used in SIA
    or
  • select the security option and for all the 3 options, select customize click on Edit and add the domain user with fill control

repeat same steps for Desktop Intelligence Document

manoj_d (BOB member since 2009-01-02)

#11

I initially ran it with the domain administrator account, but running it through the command line with the ‘SIA’ user produces a successful result as well.

With regard to the DCOM Config pane, there’s no such thing as Designer Class, only the the Desktop Intelligence Document is available.

wahey :netherlands: (BOB member since 2007-05-31)

#12

open the registry editor do you see the following entry in it
{3496DB16-E495-48C8-9C99-014AF38AD128}

manoj_d (BOB member since 2009-01-02)

#13

Yep, it’s there.

wahey :netherlands: (BOB member since 2007-05-31)

#14

check if following registry entries are also there

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}
Class Name:
Last Write Time: 6/26/2011 - 4:33 PM
Value 0
Name: AppID
Type: REG_SZ
Data: {3496DB16-E495-48c8-9C99-014AF38AD128}

Value 1
Name:
Type: REG_SZ
Data: Designer Class

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\InprocHandler32
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: ole32.dll

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\LocalServer32
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: C:\PROGRA~2\BUSINE~1\BUSINE~1.0\WIN32_~1\designer.exe /Automation

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\ProgID
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: Designer.Application

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\VersionIndependentProgID
Class Name:
Last Write Time: 6/26/2011 - 4:33 PM
Value 0
Name:
Type: REG_SZ
Data: Designer.Application

manoj_d (BOB member since 2009-01-02)

#15

No, those are not present.

wahey :netherlands: (BOB member since 2007-05-31)

#16

let me check few more things, you are on windows 2008
I think this could be related to windows security also, since when Integrator start universe collection it imports the universe from the Enterprise which in turn gets the .unv file locally, check if the user that is running the integrator from CMC has permission to create files in default universe folder

manoj_d (BOB member since 2009-01-02)

#17

Window 2008 R2 (64-bit only). With both the domain admin as well as the ’ SIA’ user I can run the cmsCollector via the command line without issue, so I didn’t think that could cause the issue. But I checked and the Administrators group, of which the ‘SIA’ user is part, has all rights assigned on the default Universe folder.

wahey :netherlands: (BOB member since 2007-05-31)

#18

I just checked the Event Viewer and there is reference to this key a few times:

and

wahey :netherlands: (BOB member since 2007-05-31)

#19

ok, lets try to add the following registry to make the Designer Class visible in dcomcnfg, and then change the security setting

add everyone group and grant full access

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\AppID{3496DB16-E495-48c8-9C99-014AF38AD128}
Class Name:
Last Write Time: 6/14/2011 - 7:30 PM
Value 0
Name:
Type: REG_SZ
Data: Designer Class

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}
Class Name:
Last Write Time: 6/26/2011 - 4:33 PM
Value 0
Name: AppID
Type: REG_SZ
Data: {3496DB16-E495-48c8-9C99-014AF38AD128}

Value 1
Name:
Type: REG_SZ
Data: Designer Class

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\InprocHandler32
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: ole32.dll

change the following value to one from your env (its BOE_HOME\BusinessObjects Enterprise 12.0\win32_x86\designer.exe)
Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\LocalServer32
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: C:\PROGRA~2\BUSINE~1\BUSINE~1.0\WIN32_~1\designer.exe /Automation

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\ProgID
Class Name:
Last Write Time: 7/27/2011 - 12:42 PM
Value 0
Name:
Type: REG_SZ
Data: Designer.Application

Key Name: HKEY_LOCAL_MACHINE\SOFTWARE\Classes\CLSID{3496DB16-E495-48c8-9C99-014AF38AD128}\VersionIndependentProgID
Class Name:
Last Write Time: 6/26/2011 - 4:33 PM
Value 0
Name:
Type: REG_SZ
Data: Designer.Application

manoj_d (BOB member since 2009-01-02)

#20

I’ll try to do this tonight. Thanks!

wahey :netherlands: (BOB member since 2007-05-31)