(no subject)

general discussion
1

Hi Friends,
BO 4.11 and Oracle 7.34

Is there any way that Bus Obj can do “what if” scenarios.

I want to do financial reporting , then replace one of the numbers and see what the effects are against the original report. Can Bus Obj do this and if it can …
any suggestions on how it can be done.
thanks,
laurenf@bellatlantic.net

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

2

Is there any way that Bus Obj can do “what if” scenarios.

This could be tricky but try this:
Create Named Constants that will be your numbers to change. Integrate these into other formulas. You can do this by adding a text box, and putting in the initial value. Then “insert” the constant from the Variable Editor list wherever you need to use it. When you need to change - edit the constant from the Variable Editor, it’ll automatically carry through to all formulas that use that same constant.

If this doesn’t quite make sense, drop me a line and I can clarify.

David Jelinek
DAVID.JELINEK@opc.com

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

3

Hi Rajesh,
the report test is a WebI report. If you went by the examples that have
been provided in the SDK the use Document id and somehow I am unable to get the Document Id for an already existing report. Now since I confirm that my report is not on the fat client can you tell me what could be the problem.
Anand
On Mon, 31 Jul 2000 11:40:41 -0000, you wrote:

Hi,

This code may not work if document test is created in Desktop version of Business Objects.
You cannot manipulate fat client reports using Webi SDK.

Regards,
Rajesh

____________________________________________ Service Brought To You By http://WWW.DWP.NET

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

4

Hi Anand,

You can get document id from repository. obj_m_documents (table).

Can you please check the following.

1 Are u able to create the WISERVER object.
Just check the resulting URL etc Wiserver.httpserverurl
Wiserver.isrunning

2 Whether session is created correctly.

3 User has right on this document

Rajesh

Hi Rajesh,
the report test is a WebI report. If you went by the examples that have
been provided in the SDK the use Document id and somehow I am unable to get the Document Id for an already existing report. Now since I confirm that my report is not on the fat client can you tell me what could be the problem.
Anand

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

5

Hi Rajesh,
Well I went ahead of the problem that I had mentioned earlier. Three more questions 1) I am unable to get the number of prompts using GetPRompts() for the WIPromts object. The count shows zero. 2) How does one access the id table from the repository rather how will the user know how to do it. Keeping in mind that he will have no ASP knowledge. 3) Also the function GEtSession requires a session key??? What is this and where does one find it. Anand

____________________________________________ Service Brought To You By http://WWW.DWP.NET

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

6

ser busob-l nomail

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

7

I’m using WebI 2.6.1. On a tabular report, there is calculation on the left most column. The calculation footer doesn’t display a label for the calculation. If there is a calculation on the second column from the left, a label such as ‘Count :’ is printed in the left most column and the distinct count is printed in the second column of the calculation footer. Is there any way to print a label for a calculation on the left most column in the calculation footer of a WebI report?

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

8

Everyone,

I am trying to develop a report which will give me automatically cumlative daily data, so I can forward report to BCA. For example, I need 11-01-01 thru 11-09-01 data. I placed date-1 in my where statement and of course it resulted yesterday’s data. I am going against Teradata data. Thanks.

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

9

Tyrone

You might want to try a query condition of (Oracle syntax):

to_date(TransactionDate,‘yyyymm’) = to_date(Sysdate,‘yyyymm’)

This is good for an environment where fiscal month = calendar month and warehouse is update nightly.

I’m sure Teradata has a similar function as to_date to reformat date information.

Mike McErlain

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