Webi Document DRILL & Link HTML

building reports webintelligence legacy 1/2
1

Hi all:
I have a Webi Document in drill mode. My document is a simple table with 2 object Object1 Mount %Mount

My hierarchy is Object1 - Objects2 - Objects3

I need when my document is in objects3, the information is more detail. Drill --> Objetct1 objetct2
Object3 descripction id_order date description2 Mount1 Tax Mount %Mount
The representation correct is a FORM.

It is possible??? Any idea???
My solution is use the links in my document and link to HTML File with detail. Any idea??

Thanks and regards

Luis Sanchez

Listserv Archives (BOB member since 2002-06-25)

2

Hi,
Yes linking is the solution for you. What you can do is create an object in designer(object3) which is linked to other report in webi which would be your detailed report, and then create the normal drilled report with your hierarchy as object1, object2, object3, so when you come to object3 you will see an hyperlink to ,clicking on which will open another BO or Webi Document(which has already been created and stored in the repository).

Hope this helps…

Thanks
Amit Agarwal
Saama Technologies
408-371-1900

Hi all:
I have a Webi Document in drill mode. My document is a simple table with 2 object
Object1 Mount %Mount

My hierarchy is Object1 - Objects2 - Objects3

I need when my document is in objects3, the information is more detail. Drill → Objetct1 objetct2
Object3 descripction id_order date description2 Mount1
Tax Mount %Mount
The representation correct is a FORM.

It is possible??? Any idea???
My solution is use the links in my document and link to HTML File with detail. Any idea??

Thanks and regards

Luis Sanchez

_________________________________________________________________ Join the worldís largest e-mail service with MSN Hotmail. http://www.hotmail.com

Listserv Archives (BOB member since 2002-06-25)

3

Hi,

There is a prompt with link you can use it for syntax check the tips in BO website where you can pass parameters from one object to next object so that drill goes to end level. the website gives example for Ms access you need to change it to oracle syntax.

Regards
Ramesh Kumar

Listserv Archives (BOB member since 2002-06-25)

4

Hi,

Can you please give me reference in BO website from where I can find how to create an object in the designer to open a report by giving prompt in the drill mode?

Thanks & Rgds,
Hema

hema (BOB member since 2003-03-21)

5

www.BusinessObjects.com

go to TIPS and TRICKS

and then to
Universe Design and click on Link

“Linking Reports Based on Returned Values in WebIntelligence”

you can even do a search on that on BO site.

anyway link is
http://www.businessobjects.com/services/InfoCenter/tips/unvdes/tip/ut005/ut005.htm

man4urheart :india: (BOB member since 2003-02-14)

6

Hi,

Thanks for the link.

I created an object excatly the way the have described there.
But when I click on the URL, I get an error - The required WebIntelligence service is not available.

Any idea why this is happening?

Thanks,
Hema.

hema (BOB member since 2003-03-21)

7

There is a problem with the way you have defined the link.

We can have a look, if you can paste your link over here.

man4urheart :india: (BOB member since 2003-02-14)

8

Are you running the report from WebI? That technique does not work in full-client.

Anita Craig :us: (BOB member since 2002-06-17)

9

[Added BBCode -Cp 10/04/2004]

Hi,

Yes, I am using WebI .

I have created object as follows:

'<a href=' + {fn char(34)} + 'http://hkhldapp03/wi/bin/iswi.dll/WIGenerator/
wigenerator/generator/OpenDocument?sDoc=Shipment%20Details%For%Claims&amp;sType=W&amp;iDocID=31&amp;sRepo=Document&amp;sOpen=Y&amp;lsSType=' + @Select(Claims\Type)  + {fn char(34)} + '>'+@Select(Claims\Type)+ '</a>'

Let me know if there is any problem in this.

Thanks a lot,
Hema.

hema (BOB member since 2003-03-21)

10

Here’s a post where I posted non-SDK syntax that worked for me (as a report variable) during a test.

I wonder if the:

{fn char(34)}

is what is causing a problem for you. Are you defining this in the universe via Designer?

Does anyone else out there have any suggestions?

Anita Craig :us: (BOB member since 2002-06-17)

11

I guess you should Debug it by Step by Step approach

  1. Call the next page directly from browser without Prompt and withouth that Code: {fn char(34)}
  2. Then if it is successfull, keep on adding these elements 1 by 1.

man4urheart :india: (BOB member since 2003-02-14)