Drilling - based on rows

building reports desktopintelligence
1

Hi All,

I have to create a drill down report on a table in which data is having parent - child relationship meaning a value in a row for a column can act as parent for another column in a different row. I understand that Business Objects supports drilling on columns but is there any way out by which I can drill based on rows.

Also I do not know the level of drill as it changes depending upon the number of rows.

Regards,

Forum_Member101 :us: (BOB member since 2005-05-18)

2

Are you using Crystal or WEBI?

datagal :us: (BOB member since 2005-12-21)

3

Business Objects Reporter 6.5.1.

Forum_Member101 :us: (BOB member since 2005-05-18)

4

Sorry… I’m no help with that one… :nonod:

datagal :us: (BOB member since 2005-12-21)

5

Moved from “General Discussion” to “Building Reports” --> BusinessObject Classic sub-forum.

Bobarella (BOB member since 2004-02-12)

6

Your best option might be to look at the OpenDocument function, for starters look here.

Andreas :de: (BOB member since 2002-06-20)

7

Hi All,

I created a link object in Universe (based on oracle database) so that I can pass the value of this cloumn to another report as a prompt, below is the code for that

my issue is that this object works fine and passes the value to the second report however second report fails to fetch the data using the value supplied by the first report the reason is the sql shown below

SELECT     
  EBDATAMART.EVENT_FACT.EVENT_ID,
  '<a href="http://dr-bo.constellation.com/infoview/scripts/openDocument.asp?sDocName=Document&amp;sType=wid&amp;RepoType=Corporate&amp;iDocID=7314&amp;lsSVitem='||EBDATAMART.DOCUMENT_VIRTUAL_ITEM.VITEM_CODE_L1||'">'||EBDATAMART.DOCUMENT_VIRTUAL_ITEM.VITEM_CODE_L1||'</a>'
FROM
  EBDATAMART.EVENT_FACT,
  EBDATAMART.DOCUMENT_VIRTUAL_ITEM,
  EBDATAMART.EVENT_VIRTUAL_ITEM
WHERE
  ( EBDATAMART.DOCUMENT_VIRTUAL_ITEM.DOC_VITEM_GEN_NBR=EBDATAMART.EVENT_VIRTUAL_ITEM.DOC_VITEM_GEN_NBR  )
  AND  ( EBDATAMART.EVENT_VIRTUAL_ITEM.EVENT_GEN_NBR=EBDATAMART.EVENT_FACT.EVENT_GEN_NBR  )
  AND  
  '<a href="http://dr-bo.constellation.com/infoview/scripts/openDocument.asp?sDocName=Document&amp;sType=wid&amp;RepoType=Corporate&amp;iDocID=7314&amp;lsSVitem='||EBDATAMART.DOCUMENT_VIRTUAL_ITEM.VITEM_CODE_L1||'">'||EBDATAMART.DOCUMENT_VIRTUAL_ITEM.VITEM_CODE_L1||'</a>'  =  'A'

see how the last AND condition has whole of the URL string on the left side where as the on the right side there is just ‘A’.

I am not sure if I need two objects one with the URL which I will use in the first report and the second one as the conditional object that I will use in the second report.

Please help.

Regards,

Forum_Member101 :us: (BOB member since 2005-05-18)