Where is doc id?

building reports webintelligence
1

Where do i look for doc id in webi XI (Report linking)

casino :us: (BOB member since 2006-10-23)

2

Use the document name. XI allows you to link by folder path + document name which is much more appropriate.

Dave Rathbun :us: (BOB member since 2002-06-06)

3

Right click on your infoview screen → view source.
You will see lot of codes like this along with document name.

<a class='list' href="javascript:void(0);" onClick="doAction('../../InfoView/CrystalEnterprise_Webi/view.do?objId=262400', 262400, true, 'iv', 'fullscreen=yes,location=no,scrollbars=yes,menubars=no,toolbars=no,resizable=yes');; return false;" oncontextmenu='return false;'>

The six digit number inside that code is the document id for one of my reports.

kool :nepal: (BOB member since 2005-04-15)

4
  1. Go go to the BOXI Admin Launchpad screen and select the Query Builder option under “Administrative Tools” on the left.
  2. Enter your BOXI login info (I think this needs to be an administrator user)
  3. Enter the following query:
SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS

then click on [Submit Query]

This will list all the objects on your system (folders, reports …etc). The “SI_ID” column contains the CUID that you can use in the OpenDOcument syntax.

Another way
In Infoview, Place the mouse point on the report then the report id can be shown on status bar

Thank you,
Upendar

upendar_tulluru :us: (BOB member since 2006-08-05)

5

Yes, but…

Use the document name. :slight_smile: It doesn’t change from one environment to another.

Dave Rathbun :us: (BOB member since 2002-06-06)

6

Yeah! I was told that using Doc Cuid is better than using DocId, Anyway another simpler way to find out the Doc Id of a report is --> Just Move your mouse cursor on the “small up arrow” found to the left side of your report(in the folder view) and then look for the DocId in the Status bar below.
Hope that helps!

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

7

Dave! Does the Cluster Id change for a Report? I thought even that doesn’t change!

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

8

What about migrating from DEV to TEST, or TEST to PROD?

I don’t see how they can guarantee that the ID values will never change.

Suppose you have two DEV environments. When migrating from DEV1 or DEV2 to TEST, how would you ensure that the assigned ID would not conflict? As a result, I assume (and it is an assumption on my part, I have not thoroughly investigated this) that the ID cannot be guaranteed to stay the same.

We are using the document path + name at my current client.

Dave Rathbun :us: (BOB member since 2002-06-06)

9

Thanks Dave.
We moved around some reports from Dev–>Test–>Prod and found that the Cuid was the same in all Environments.
Yeah! But i agree, there is no rule that it stays same all the time.
The only reason i try not to use Document Name is: I might have multiple copies of it with same name in Favorites, Inbox etc. and i might pick up the wrong one.

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

10

Thanks to all of you! I found it.

Sravani.

casino :us: (BOB member since 2006-10-23)

11

As far as I know, OpenDocument will only pick published docs; favorites and inbox are “invisible”. And you can specify the folder as part of the document name as well.

Dave Rathbun :us: (BOB member since 2002-06-06)

12

Yes Dave!, you are right…as always.

Respect,
Kon

konquistador :us: (BOB member since 2006-01-04)

13

Hi all,

This was an intreseting thread.
I accept the fact that it is good to use the doc name instead of ID’s. However, in my scenario when i used document name it throwed report linking error and the weird part was that it does sometimes. Not sure why. So, i tried with the idocID and it worked.

I know this will not solve the pupose as idocID changes for different environments. I will include the CUID instead which would be mostly same throughout diff environmnts.

Thanks!!!

arun9911 :us: (BOB member since 2008-01-16)

14

CUID will stay the same throughout as long as no one does a save as to the report and you do an ovewrwrite each time you switch environments.

maverick976 :us: (BOB member since 2004-07-06)

15

Hi maverick976,

Do you think we can find the CUID from the infoview. As far as i know we can only find the idocID from infoview. Do we have to logon to CMC to find the CUID’s?

Thanks!

arun9911 :us: (BOB member since 2008-01-16)

16

in 3.1 the cuid is displayed under the properties (right click–>properties) of the report in infoview. I do not remember if it is in other versions. As they mentioned above though the cuid can change, so there is a risk by linking to it.

maverick976 :us: (BOB member since 2004-07-06)

17

Thank you.

I am using XI R2. XIR2 does not have the right click style of GUI.
I can get the CUID from CMC though.
Reason i am planning to use CUID is because sDocName is not helping me. It give report linking error sometimes.

Thanks maverick976

arun9911 :us: (BOB member since 2008-01-16)

18

You can get it from Query Builder.

Use the query:

Select si_cuid from ci_infoobjects where si_id=''

Thanks,
Kon

konquistador :us: (BOB member since 2006-01-04)

19

Thanks konquistador… I do not have access to use query builder in BO.

arun9911 :us: (BOB member since 2008-01-16)

20

If I remember correctly you CAN get the CUID in XiR2 Infoview

katullus :us: (BOB member since 2009-08-21)