brioportalusersgroup : Messages : 649-680 of 744

Hi all,

Currently we are in the process of migrating the
existing bqy documents from brio 6.1 to brio 8.0. I
need to test the same in the new environment. Is there
any evaluation version available for brio 8.0. If so
pls kindly let me know the URL. Any type of other work
around always welcome.

Thanks in advance
Prasanna.



__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

#679

From: miller_its
Date: Thu Jan 8, 2004 5:38 pm
Subject: Re: [Brio Portal Users Group] Digest Number 152

miller_its

Offline

Bill,

We just completed updating about 40 param pages here at OSU.
Basically the Smart forms have been simplified down significantly in
Brio8.   Our forms were a combination of the "auto generated" forms
of Brio Portal 7.x and an old reporting system, so I am not sure each
of the reference points in the document segment below will match your
forms exactly.  Here is the text of a document we wrote here for our
developers.
============================================================
Brio 8 SQR Parameter Form Updates

In Brio8, the parameter pages are greatly simplified, which reduces
the overall size and complexity of each form.  The parameter forms in
the current version of Brio had to perform three separate actions for
the SQR jobs:
1. displayed when running the job
2. displayed when editing an existing saved parameter list
3. displayed when creating an new parameter list

The code (elements) for each of these options was embedded in each
and every parameter form.  Now, with Brio8, these actions have been
separated out into the central system, which is then used for each
parameter page.  The custom parameter pages in the Brio8 system will
only need to contain the code (elements) for the job input parameters
required for the SQR job itself.

Below are the generalized steps for updated an existing parameter
page to the new Brio 8 format.
1. Remove the top <HTML> tag
2. Remove all code from the <HEAD> tag, to the  comment
3. remove all code below the  
comment to the end of the form
4. Insert the following code block directly below the form
documentation comments:


<WS:Import file="parameterFormJavaScript.imp"/>

Note:  we have some minor issues with a few parameter pages that used
tables, which require some additional changes

==================================================================
If you have any questions please contact me directly.

HTH
Jason

--- In brioportalusersgroup@yahoogroups.com, Bill Heck <bheck11@y...>
wrote:
> Thanks for the tips!  We have encountered several
> issues with the upgrade and so it will take awhile to
> diagnose this one fully.  Sounds as though we are in
> for some recoding, though.
>
> Bill Heck
> --- brioportalusersgroup@yahoogroups.com wrote:
> > There is 1 message in this issue.
> >
> > Topics in this digest:
> >
> >       1. Re: Brio Portal - Foundation upgrade issues
> >            From: unixjedi
> >
> >
> >
>
______________________________________________________________________
__
> >
>
______________________________________________________________________
__
> >
> > Message: 1
> >    Date: Wed, 07 Jan 2004 05:56:50 -0000
> >    From: unixjedi
> > Subject: Re: Brio Portal - Foundation upgrade issues
> >
> > Some of the templates that were in 7.x will have to
> > be recoded for
> > V8.x. Notably any SQR Parameter forms that are now
> > JSP.
> >
> > I hope to get more V8 stuff here.
> >
> > Rob
> >
> > --- In brioportalusersgroup@yahoogroups.com, Don
> > Mellen <donm@o...>
> > wrote:
> > > I assume these are "Smart Forms" that worked in
> > 7.0.2.
> > >
> > > As a quuickie guess, did you update the smartforms
> > for any
> > differences in
> > > the new portal?  Like, new object IDs?
> > >
> > > On Wed, 31 Dec 2003, Bill Heck wrote:
> > >
> > > > At Miani University, we are upgrading from Brio
> > Portal
> > > > 7.0.2 to 8.1 (so now it will be Foundation).
> > > > Background: Portal is running on AIX with an
> > Oracle db
> > > > for the repository.
> > > >
> > > > We've run into an issue and would appreciate any
> > help
> > > > from those who might have experienced something
> > > > similar:
> > > >
> > > > We have published a lot of SQR jobs and have
> > developed
> > > > "Smart Forms" for some of them.  The SQR jobs
> > that use
> > > > the default parameter input forms (no Smart
> > Forms) run
> > > > OK.  The jobs that use Smart Forms won't start.
> > That
> > > > is, when the user clicks on the Run button,
> > nothing
> > > > happens.  The Reset button does work properly.
> > Anyone
> > > > else have this experience?
> > > >
> > > > Thanks for any ideas.
> > > >
> > > > Bill Heck
> > > >
> > > > __________________________________
> > > > Do you Yahoo!?
> > > > New Yahoo! Photos - easier uploading and
> > sharing.
> > > > http://photos.yahoo.com/
> > > >
> > > >
> > > >
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > > To visit your group on the web, go to:
> > > >
> > http://groups.yahoo.com/group/brioportalusersgroup/
> > > >
> > > > To unsubscribe from this group, send an email
> > to:
> > > >
> > brioportalusersgroup-unsubscribe@yahoogroups.com
> > > >
> > > > Your use of Yahoo! Groups is subject to:
> > > >  http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> >
> -------------------------------------------------------------------
> > ----
> > > Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
> > http://www.ontko.com/
> > > donm@o... |  "In the beginning, there was nothing,
> > which exploded"
> >
> >
> >
> >
>
______________________________________________________________________
__
> >
>
______________________________________________________________________
__
> >
> >
> >
> >
> >
> --------------------------------------------------------------------
----
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> >  http://groups.yahoo.com/group/brioportalusersgroup/
> >
> > To unsubscribe from this group, send an email to:
> >  brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to:
> >  http://docs.yahoo.com/info/terms/
> >
> --------------------------------------------------------------------
----
> >
> >
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
> http://hotjobs.sweepstakes.yahoo.com/signingbonus

#678

From: Bill Heck <bheck11@...>
Date: Thu Jan 8, 2004 1:41 pm
Subject: Re: [Brio Portal Users Group] Digest Number 152

bheck11

Offline

Thanks for the tips!  We have encountered several
issues with the upgrade and so it will take awhile to
diagnose this one fully.  Sounds as though we are in
for some recoding, though.

Bill Heck
--- brioportalusersgroup@yahoogroups.com wrote:
> There is 1 message in this issue.
>
> Topics in this digest:
>
>       1. Re: Brio Portal - Foundation upgrade issues
>            From: unixjedi
>
>
>
________________________________________________________________________
>
________________________________________________________________________
>
> Message: 1
>    Date: Wed, 07 Jan 2004 05:56:50 -0000
>    From: unixjedi
> Subject: Re: Brio Portal - Foundation upgrade issues
>
> Some of the templates that were in 7.x will have to
> be recoded for
> V8.x. Notably any SQR Parameter forms that are now
> JSP.
>
> I hope to get more V8 stuff here.
>
> Rob
>
> --- In brioportalusersgroup@yahoogroups.com, Don
> Mellen <donm@o...>
> wrote:
> > I assume these are "Smart Forms" that worked in
> 7.0.2.
> >
> > As a quuickie guess, did you update the smartforms
> for any
> differences in
> > the new portal?  Like, new object IDs?
> >
> > On Wed, 31 Dec 2003, Bill Heck wrote:
> >
> > > At Miani University, we are upgrading from Brio
> Portal
> > > 7.0.2 to 8.1 (so now it will be Foundation).
> > > Background: Portal is running on AIX with an
> Oracle db
> > > for the repository.
> > >
> > > We've run into an issue and would appreciate any
> help
> > > from those who might have experienced something
> > > similar:
> > >
> > > We have published a lot of SQR jobs and have
> developed
> > > "Smart Forms" for some of them.  The SQR jobs
> that use
> > > the default parameter input forms (no Smart
> Forms) run
> > > OK.  The jobs that use Smart Forms won't start.
> That
> > > is, when the user clicks on the Run button,
> nothing
> > > happens.  The Reset button does work properly.
> Anyone
> > > else have this experience?
> > >
> > > Thanks for any ideas.
> > >
> > > Bill Heck
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > New Yahoo! Photos - easier uploading and
> sharing.
> > > http://photos.yahoo.com/
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
> > >
> > > To visit your group on the web, go to:
> > >
> http://groups.yahoo.com/group/brioportalusersgroup/
> > >
> > > To unsubscribe from this group, send an email
> to:
> > >
> brioportalusersgroup-unsubscribe@yahoogroups.com
> > >
> > > Your use of Yahoo! Groups is subject to:
> > >  http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
>
-------------------------------------------------------------------
> ----
> > Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
> http://www.ontko.com/
> > donm@o... |  "In the beginning, there was nothing,
> which exploded"
>
>
>
>
________________________________________________________________________
>
________________________________________________________________________
>
>
>
>
>
------------------------------------------------------------------------
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>  http://groups.yahoo.com/group/brioportalusersgroup/
>
> To unsubscribe from this group, send an email to:
>  brioportalusersgroup-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
>  http://docs.yahoo.com/info/terms/
>
------------------------------------------------------------------------
>
>


__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

#677

From: unixjedi
Date: Wed Jan 7, 2004 5:56 am
Subject: Re: [Brio Portal Users Group] Brio Portal - Foundation upgrade issues

unixjedi

Offline

Some of the templates that were in 7.x will have to be recoded for
V8.x. Notably any SQR Parameter forms that are now JSP.

I hope to get more V8 stuff here.

Rob

--- In brioportalusersgroup@yahoogroups.com, Don Mellen <donm@o...>
wrote:
> I assume these are "Smart Forms" that worked in 7.0.2.
>
> As a quuickie guess, did you update the smartforms for any
differences in
> the new portal?  Like, new object IDs?
>
> On Wed, 31 Dec 2003, Bill Heck wrote:
>
> > At Miani University, we are upgrading from Brio Portal
> > 7.0.2 to 8.1 (so now it will be Foundation).
> > Background: Portal is running on AIX with an Oracle db
> > for the repository.
> >
> > We've run into an issue and would appreciate any help
> > from those who might have experienced something
> > similar:
> >
> > We have published a lot of SQR jobs and have developed
> > "Smart Forms" for some of them.  The SQR jobs that use
> > the default parameter input forms (no Smart Forms) run
> > OK.  The jobs that use Smart Forms won't start.  That
> > is, when the user clicks on the Run button, nothing
> > happens.  The Reset button does work properly.  Anyone
> > else have this experience?
> >
> > Thanks for any ideas.
> >
> > Bill Heck
> >
> > __________________________________
> > Do you Yahoo!?
> > New Yahoo! Photos - easier uploading and sharing.
> > http://photos.yahoo.com/
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> > To visit your group on the web, go to:
> >  http://groups.yahoo.com/group/brioportalusersgroup/
> >
> > To unsubscribe from this group, send an email to:
> >  brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> > Your use of Yahoo! Groups is subject to:
> >  http://docs.yahoo.com/info/terms/
> >
> >
>
> -------------------------------------------------------------------
----
> Donald Mellen  | Ray Ontko & Co. - Richmond, IN -
http://www.ontko.com/
> donm@o... |  "In the beginning, there was nothing, which exploded"

Reply | Forward | Messages in this Topic (3)

#676

From: Don Mellen <donm@...>
Date: Wed Dec 31, 2003 8:21 pm
Subject: Re: [Brio Portal Users Group] Brio Portal - Foundation upgrade issues

lairpridesro...

Offline

I assume these are "Smart Forms" that worked in 7.0.2.

As a quuickie guess, did you update the smartforms for any differences in
the new portal?  Like, new object IDs?

On Wed, 31 Dec 2003, Bill Heck wrote:

> At Miani University, we are upgrading from Brio Portal
> 7.0.2 to 8.1 (so now it will be Foundation).
> Background: Portal is running on AIX with an Oracle db
> for the repository.
>
> We've run into an issue and would appreciate any help
> from those who might have experienced something
> similar:
>
> We have published a lot of SQR jobs and have developed
> "Smart Forms" for some of them.  The SQR jobs that use
> the default parameter input forms (no Smart Forms) run
> OK.  The jobs that use Smart Forms won't start.  That
> is, when the user clicks on the Run button, nothing
> happens.  The Reset button does work properly.  Anyone
> else have this experience?
>
> Thanks for any ideas.
>
> Bill Heck
>
> __________________________________
> Do you Yahoo!?
> New Yahoo! Photos - easier uploading and sharing.
> http://photos.yahoo.com/
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
>  http://groups.yahoo.com/group/brioportalusersgroup/
>
> To unsubscribe from this group, send an email to:
>  brioportalusersgroup-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
>  http://docs.yahoo.com/info/terms/
>
>

-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/
donm@... |  "In the beginning, there was nothing, which exploded"

Reply | Forward | Messages in this Topic (3)

#675

From: Bill Heck <bheck11@...>
Date: Wed Dec 31, 2003 4:58 pm
Subject: Brio Portal - Foundation upgrade issues

bheck11

Offline

At Miani University, we are upgrading from Brio Portal
7.0.2 to 8.1 (so now it will be Foundation).
Background: Portal is running on AIX with an Oracle db
for the repository.

We've run into an issue and would appreciate any help
from those who might have experienced something
similar:

We have published a lot of SQR jobs and have developed
"Smart Forms" for some of them.  The SQR jobs that use
the default parameter input forms (no Smart Forms) run
OK.  The jobs that use Smart Forms won't start.  That
is, when the user clicks on the Run button, nothing
happens.  The Reset button does work properly.  Anyone
else have this experience?

Thanks for any ideas.

Bill Heck

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

Reply | Forward | Messages in this Topic (3)

#672

From: "Narro, Arthur (HRSA)" <anarro@...>
Date: Fri Dec 12, 2003 4:40 pm
Subject: RE: [brio-l] Re: [Brio Portal Users Group] Brio 8: HELP Process() a query while running the iServer.

smsysupd

Offline

Gary -- After putting this together, I realized this is not what you are
interested in (since I am sure you could develop this just as easily as I
and maybe better).  There were no problem with the Console scripts, the
problem was the Process() -- that is where it stopped working.

The following are extracted from the Document.OnStartup() event trigger.

// *************************************************************************
// Warehouse Report (Warehouse.bqy) Document Script
// Version 2.0, December 12, 2003
// Developer: A. Narro
// Notes:
//  (1) So that sharing of code between BQY files can be more less
// cumbersome, a version number was added to each function.
// The version number is in the format of yyyymmdd.
//  (2) The iServer does not have the console so this application
// includes a console like capability using an EIS titled "Diagnostic
// Console." Associated with the console there are Console control
// functions: Console_Reset (clears the console), Console_View
(displays
// the console), and Console_Writeln (writes messages to the console).
// The Diagnostic Console EIS and associated functions were written so
// that a developer could look at what is happening while using the
// bqy from the web (iServer).   In the Document.OnStartup() event
// trigger, there is a global variable Console_EIS with the name of
// the console window (EIS).  The Console_EIS has a large text box
// (TextBox1 - very original name) and two buttons "Return to Main EIS"
// and "Reset Console".  The return to main EIS activates the main EIS
// and hides the console.  The Console_EIS control scripts:
//  The reset console button OnClick event:
// 	   Console_Reset ();
//
//  The return to main EIS OnClick event:
// 	   ActiveDocument.Sections[EIS1].Activate();
// 	   ActiveDocument.Sections[Console_EIS].Visible = false;
//
//
// Change History:
// DATE, BY, DESCRIPTION
// -------------------------------------------------------------------------
// 2003.09.12 A. Narro Version 1.3 - The report has been changed to
// 	 conform to the data model and to standardize
// 	 function code and global variable usage.
// 2003.12.10 A. Narro Modified from the version 1.3 application to
// 	 comport and take advantage of the iServer
functionality
// 	 and requirements.
//
// *************************************************************************
// Declaring Global Variables
// *************************************************************************
with(Application)
{
	 // EIS Global Constants - Universal:
	 EIS1 = "Data Selection Criteria";
	 EIS2 = "Display Results";
	 Console_EIS = "Diagnostic Console";

	 // Other Global Variable/Constants - Universal.
	 strALL="<ALL>"; // Constant - The all option in the drop down lists.
	 display_code = 1; // Variable - used by the report selection
EIS1.

	 // Result Sets - BQY Specific:
	 // TBD.

	 // Reports - BQY Specific:
	 // TBD.
}

// *************************************************************************
// * OnStartup Event Trigger global functions follow ...
// *************************************************************************

// *************************************************************************
// Function: Console_Reset () : Console_ResetFunc ()
// Author: A. Narro
// Version:  20031210
// Arguments: None
// Return: None.
// Purpose: This function is used for developers to see what is happening,
//   mostly intended to be used while looking at the website application,
//   clears the entries in the diagnostic console window.
// Class: Development/Debug Monitor
// *************************************************************************
function Console_ResetFunc ()
	 {
	 var Obj = ActiveDocument.Sections[Console_EIS].Shapes["TextBox1"];
	 today=new Date();
	 Obj.Text =  today.toLocaleString() +
		 " * Diagnosic window  entries cleared."
	 Console_Writeln ("* Client Application Name: " + Application.Name);
	 return;
	 }



// *************************************************************************
// Function: Console_View () : Console_ViewFunc ()
// Author: A. Narro
// Version:  20031210
// Arguments: None
// Return: None.
// Purpose: This function is used for developers to see what is happening,
//   mostly intended to be used while looking at the website application,
//   displays the diagnostic console window.
// Class: Development/Debug Monitor
// *************************************************************************
function Console_ViewFunc ()
	 {
	 ActiveDocument.Sections[Console_EIS].Activate();
	 return;
	 }



// *************************************************************************
// Function: Console_WritelnFunc()
// Author: A. Narro
// Version:  20031210
// Arguments: sLine
// Return: None.
// Purpose: This function is used for developers to see what is happening,
//   mostly intended to be used while looking at the website application.
// Class: Development/Debug Monitor
// *************************************************************************
function Console_WritelnFunc(sLine)
	 {
	 var Obj = ActiveDocument.Sections[Console_EIS].Shapes["TextBox1"];
	 today=new Date();
	 Obj.Text =  Obj.Text + "\r\n" + today.toLocaleString() + " " + sLine
	 return;
	 }

// *************************************************************************
// * OnStartup Event Trigger begins below
// *************************************************************************


// -------------------
// Declare Console functions and reset the Console.
// -------------------

Console_Reset = Console_ResetFunc;
Console_View = Console_ViewFunc;
Console_Writeln = Console_WritelnFunc;

Console_Reset ();

...


Sincerely,

Art Narro


-----Original Message-----
From: Gary Mccool via brio-l [mailto:brio-l@...]
Sent: Friday, December 12, 2003 9:10 AM
To: Narro; Narro, Arthur (HRSA)
Cc: Narro, Arthur (HRSA); 'brio-l@...'; Narro;
'brioportalusersgroup@yahoogroups.com'; 'briousers@yahoogroups.com'
Subject: [brio-l] Re: [Brio Portal Users Group] Brio 8: HELP Process() a
query while running the iServer.

# See It Now
# Read Paper: http://bi.ITtoolbox.com/r/hdr.asp?r=14075

# View Group Archive: http://ITtoolbox.com/hrd.asp?i=798

Can you supply the code behind Console_Writeln?

Enjoy!

Gary Mc

> ------------------------------------------------------------------------
> You cannot reply to this message via email because you have chosen not
> to disclose your email address to the group.
>
> To reply:
>
http://groups.yahoo.com/group/brioportalusersgroup/post?act=reply&messageNum
=671
> ------------------------------------------------------------------------
>
> Gary --
>
> If you notice in the code and the NOTE, the Console I am using is one I
> created myself (Console_Writelin is function I wrote) to check on things
> like print in the old BASIC/FORTRAN days.
>
> Sincerely,
>
> Art
>
> -----Original Message-----
> From: Gary Mccool via brio-l [mailto:brio-l@...]
> Sent: Thursday, December 11, 2003 7:34 PM
> To: Narro; Narro, Arthur (HRSA)
> Cc: Narro, Arthur (HRSA); 'brio-l@...';
> 'brioportalusersgroup@yahoogroups.com'; 'briousers@yahoogroups.com'
> Subject: [brio-l] Re: [Brio Portal Users Group] Brio 8: HELP Process() a
> query while running the iServer.
>
> # See It Now
> # Read Paper: http://bi.ITtoolbox.com/r/hdr.asp?r=14075
>
> # View Group Archive: http://ITtoolbox.com/hrd.asp?i=798
>
> Arthur,
>
> the Console class is not available in iServer.
>
> Gary Mc  ... Keypulse
> > ------------------------------------------------------------------------
> > You cannot reply to this message via email because you have chosen not
> > to disclose your email address to the group.
> >
> > To reply:
> >
>
http://groups.yahoo.com/group/brioportalusersgroup/post?act=reply&messageNum
> =670
> > ------------------------------------------------------------------------
> >
> > NOTE:  I set up a Diagnostic Console EIS and Console_Writeln is a
function
> > written so I can look at what is happening while using the bqy from the
> web.
> >
> > The following code is perfectly OK from Designer.  Why does this not
work
> > when calling the bqy from the iServer on the web.
> >
> > Console_Writeln ("Set up the connection for query Query.");
> > var MyCon = ActiveDocument.Sections["Query"].DataModel.Connection;
> >
> > Console_Writeln ("Set the user.");
> > MyCon.Username = "FAKE_USER";
> >
> > Console_Writeln ("Set the password.");
> > MyCon.SetPassword("FAKE_PASSWORD");
> >
> > Console_Writeln ("Set the connection.");
> > MyCon.Connect();
> >
> > Console_Writeln ("Process query Query.");
> > ActiveDocument.Sections["Query"].Process();  // stops processing here.
> >
> > Thanks in advance.
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
> ****************Want True Enterprise Reporting?****************
> See Archived MicroStrategy Report Services Webcast
> http://www.ITtoolbox.com/r/rd.asp?i=2614
> ***************************************************************
> *Archives: http://www.OpenITx.com/g/brio-l.asp
> *Manage Subscriptions: http://My.ITtoolbox.com
> *Leave Group: mailto:leave-brio-l@...
> *Need Subscription Help? mailto:Listmaster@...
> *Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
> *Copyright (c) ITtoolbox and message author. No redistribution.
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

****************Want True Enterprise Reporting?****************
See Archived MicroStrategy Report Services Webcast
http://www.ITtoolbox.com/r/rd.asp?i=2614
***************************************************************
*Archives: http://www.OpenITx.com/g/brio-l.asp
*Manage Subscriptions: http://My.ITtoolbox.com
*Leave Group: mailto:leave-brio-l@...
*Need Subscription Help? mailto:Listmaster@...
*Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
*Copyright (c) ITtoolbox and message author. No redistribution.

#671

From: "Narro, Arthur (HRSA)" <anarro@...>
Date: Fri Dec 12, 2003 1:53 pm
Subject: RE: [brio-l] Re: [Brio Portal Users Group] Brio 8: HELP Process() a query while running the iServer.

smsysupd

Offline

Gary --

If you notice in the code and the NOTE, the Console I am using is one I
created myself (Console_Writelin is function I wrote) to check on things
like print in the old BASIC/FORTRAN days.

Sincerely,

Art

-----Original Message-----
From: Gary Mccool via brio-l [mailto:brio-l@...]
Sent: Thursday, December 11, 2003 7:34 PM
To: Narro; Narro, Arthur (HRSA)
Cc: Narro, Arthur (HRSA); 'brio-l@...';
'brioportalusersgroup@yahoogroups.com'; 'briousers@yahoogroups.com'
Subject: [brio-l] Re: [Brio Portal Users Group] Brio 8: HELP Process() a
query while running the iServer.

# See It Now
# Read Paper: http://bi.ITtoolbox.com/r/hdr.asp?r=14075

# View Group Archive: http://ITtoolbox.com/hrd.asp?i=798

Arthur,

the Console class is not available in iServer.

Gary Mc  ... Keypulse
> ------------------------------------------------------------------------
> You cannot reply to this message via email because you have chosen not
> to disclose your email address to the group.
>
> To reply:
>
http://groups.yahoo.com/group/brioportalusersgroup/post?act=reply&messageNum
=670
> ------------------------------------------------------------------------
>
> NOTE:  I set up a Diagnostic Console EIS and Console_Writeln is a function
> written so I can look at what is happening while using the bqy from the
web.
>
> The following code is perfectly OK from Designer.  Why does this not work
> when calling the bqy from the iServer on the web.
>
> Console_Writeln ("Set up the connection for query Query.");
> var MyCon = ActiveDocument.Sections["Query"].DataModel.Connection;
>
> Console_Writeln ("Set the user.");
> MyCon.Username = "FAKE_USER";
>
> Console_Writeln ("Set the password.");
> MyCon.SetPassword("FAKE_PASSWORD");
>
> Console_Writeln ("Set the connection.");
> MyCon.Connect();
>
> Console_Writeln ("Process query Query.");
> ActiveDocument.Sections["Query"].Process();  // stops processing here.
>
> Thanks in advance.
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>

****************Want True Enterprise Reporting?****************
See Archived MicroStrategy Report Services Webcast
http://www.ITtoolbox.com/r/rd.asp?i=2614
***************************************************************
*Archives: http://www.OpenITx.com/g/brio-l.asp
*Manage Subscriptions: http://My.ITtoolbox.com
*Leave Group: mailto:leave-brio-l@...
*Need Subscription Help? mailto:Listmaster@...
*Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
*Copyright (c) ITtoolbox and message author. No redistribution.

#670

From: "Narro, Arthur (HRSA)" <anarro@...>
Date: Thu Dec 11, 2003 11:13 pm
Subject: Brio 8: HELP Process() a query while running the iServer.

smsysupd

Offline

NOTE:  I set up a Diagnostic Console EIS and Console_Writeln is a function
written so I can look at what is happening while using the bqy from the web.

The following code is perfectly OK from Designer.  Why does this not work
when calling the bqy from the iServer on the web.

Console_Writeln ("Set up the connection for query Query.");
var MyCon = ActiveDocument.Sections["Query"].DataModel.Connection;

Console_Writeln ("Set the user.");
MyCon.Username = "FAKE_USER";

Console_Writeln ("Set the password.");
MyCon.SetPassword("FAKE_PASSWORD");

Console_Writeln ("Set the connection.");
MyCon.Connect();

Console_Writeln ("Process query Query.");
ActiveDocument.Sections["Query"].Process();  // stops processing here.

Thanks in advance.


[Non-text portions of this message have been removed]

#669

From: "malikcv" <malikcv@...>
Date: Thu Nov 20, 2003 2:55 pm
Subject: Brio Broadcast Server Freezing

malikcv

Offline

Hiya Guys & Gals,

We have jobs scheduled to run at 5am every morning. These jobs have
been producing the reports without much problems but recently, the
temporary directory rather than having *.log files only.  Contains
the in addition to the *.log files a *.bqy, *.txt and *.txt.status
file for each scheduled job.

Additionally the job view list shows all jobs in `Running'
completion status.

In summary, the *.bqy reports are created as expected, but these
extra files detailed above seem to be left behind now   These files
have to be deleted and broadcast server is restarted in preparation
for the next run.

The Bqserver.log file contains the text below umpteen times:

".....Success: Already connected to DATAMART as 'genesys'.
Broadcast Server: Sleeping because the maximum number of permited
jobs are running
Broadcast Server:Sleeping for 1800 seconds (30.000000 min)
Broadcast Server: Resuming polling of schedule databases after hiatus.
Poll bcs_polling at 18/11/2003 05:48:30....."

Appreciate all the help i can get to resolve this issue.

Waiting in anticipation.....basically please help :-(

Cheers
Mohammed

#668

From: dlinstedt
Date: Thu Nov 20, 2003 12:57 pm
Subject: Data Vault - Enterprise Data Warehouse Modeling

dlinstedt

Offline

Having trouble with queries against massive volumes?
Want to learn how to model your enterprise warehouse in a
flexible/extensible manner?
Got problems with volumes of data breaking your star-schema
architecture?
Need to load data in near-real-time to your enterprise warehouse and
can't do it?

The Data Vault data modeling architecture has all of these components.

http://www.danlinstedt.com is the new home for the Data Vault.  Check
it out.

Cheers,
Dan L

#667

From: "Steve Cavill" <steve.cavill@...>
Date: Thu Nov 13, 2003 9:51 am
Subject: RE: [Brio Portal Users Group] report bursting

stevecavill

Offline

Bursting using the SECURITY command only works with HTML, and is documented
as such.  If you want to burst any other format you cannot use the SECURITY
command.  You need to create a separate output file for each section (using
new-report command).  Portal will publish all the resulting files as
separate output files.  You will then need to use the API to add security to
each of those output files.

The logic is not complicated, but if you haven't used the API before it will
take you a while to get it right.

Steve.

-----Original Message-----
From: vkodunt [mailto:no_reply@yahoogroups.com]
Sent: Thursday, 13 November 2003 12:04 AM
To: brioportalusersgroup@yahoogroups.com
Subject: [Brio Portal Users Group] report bursting


has anyone been able to successfully burst an sqr report in any other
format except html. we want to burst a report based on different
groups in the organization  and prefer to do it in pdf format or .xls
format .

is this possible or is .html the only output possible in  SQR report
bursting.





To unsubscribe from this group, send an email to:
brioportalusersgroup-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

#666

From: vkodunt
Date: Wed Nov 12, 2003 1:03 pm
Subject: report bursting

vkodunt

Offline

has anyone been able to successfully burst an sqr report in any other
format except html. we want to burst a report based on different
groups in the organization  and prefer to do it in pdf format or .xls
format .

is this possible or is .html the only output possible in  SQR report
bursting.

#665

From: unixjedi
Date: Mon Nov 10, 2003 5:08 pm
Subject: Re: Brio 8 on Windows 2003

unixjedi

Offline

What port number are you specifying? If it 1433 try using 1450 or
check the tcp ip setting on the DSN


--- In brioportalusersgroup@yahoogroups.com, blueghia
<no_reply@y...> wrote:
> I cannot successfully install Brio 8 on Windows 2003 Server with
SQL
> Server 2000.  I can connect to the DB using ODBC, but when I use
> that same connection during the Brio 8 Server install, the JDBC
test
> to the DB fails.  No log is produced, so it's impossible to see
why
> its failing.  Any suggestions would be appreciated!

#664

From: blueghia
Date: Mon Nov 10, 2003 3:40 pm
Subject: RE: Brio 8 on Windows 2003 Server

blueghia

Offline

...still doesn't work with C:\overrides solution.  Anyother ideas out
there?  I'm using SQLServer 2000 and the ODBC test connection works
fine.  BRIO fails on the JDBC connection.

THANKS!

#663

From: blueghia
Date: Fri Nov 7, 2003 3:47 pm
Subject: Re: Brio 8 on Windows 2003

blueghia

Offline

Thanks in advance...email is blueghia@....


--- In brioportalusersgroup@yahoogroups.com, "bolinmu"
<bolinmu@y...> wrote:
> i download it from internet, say me a mail where i can send it to
you
>
> --- In brioportalusersgroup@yahoogroups.com, blueghia
<no_reply@y...>
> wrote:
> > I cannot successfully install Brio 8 on Windows 2003 Server with
> SQL
> > Server 2000.  I can connect to the DB using ODBC, but when I use
> > that same connection during the Brio 8 Server install, the JDBC
> test
> > to the DB fails.  No log is produced, so it's impossible to see
why
> > its failing.  Any suggestions would be appreciated!

#662

From: "bolinmu" <bolinmu@...>
Date: Thu Nov 6, 2003 5:01 pm
Subject: Re: Brio 8 on Windows 2003

bolinmu

Offline

i download it from internet, say me a mail where i can send it to you

--- In brioportalusersgroup@yahoogroups.com, blueghia <no_reply@y...>
wrote:
> I cannot successfully install Brio 8 on Windows 2003 Server with
SQL
> Server 2000.  I can connect to the DB using ODBC, but when I use
> that same connection during the Brio 8 Server install, the JDBC
test
> to the DB fails.  No log is produced, so it's impossible to see why
> its failing.  Any suggestions would be appreciated!

#661

From: "bolinmu" <bolinmu@...>
Date: Thu Nov 6, 2003 3:22 pm
Subject: Re: Brio 8 on Windows 2003

bolinmu

Offline

you have to create the folder overrides in C:\
with files: msbase.jar, mssqlserver.jar and msutil.jar
In the machine where you are going to install Brio 8


--- In brioportalusersgroup@yahoogroups.com, blueghia <no_reply@y...>
wrote:
> I cannot successfully install Brio 8 on Windows 2003 Server with
SQL
> Server 2000.  I can connect to the DB using ODBC, but when I use
> that same connection during the Brio 8 Server install, the JDBC
test
> to the DB fails.  No log is produced, so it's impossible to see why
> its failing.  Any suggestions would be appreciated!

#660

From: blueghia
Date: Thu Nov 6, 2003 1:51 pm
Subject: Brio 8 on Windows 2003

blueghia

Offline

I cannot successfully install Brio 8 on Windows 2003 Server with SQL
Server 2000.  I can connect to the DB using ODBC, but when I use
that same connection during the Brio 8 Server install, the JDBC test
to the DB fails.  No log is produced, so it's impossible to see why
its failing.  Any suggestions would be appreciated!

#659

From: "Aureliano" <anarro@...>
Date: Wed Nov 5, 2003 8:47 pm
Subject: Re: Unexpected Features in Version 8.1.2

smsysupd

Offline

WRT the iServer issues there were no comments from the group so here
is an update and an issue with persistent cookies:

Item 1, after some additional testing (over our intranet) we found
that you can pass the user logon and server information in the URL and
the report EIS will start and operate.  However this could only be
tested over the intranet at this time and we believe that this should
work on the internet.  <Any help here verifying this is appeciated>

Item 2 and 3 are just the nature of the software.

--- In brioportalusersgroup@yahoogroups.com, "Narro, Arthur"
<anarro@h...> wrote:
> Hello Group,
>
> I want to use Brio version 8.1.2 iServer to present the reports
over the
> web.  The intent of this approach was to avoid having users
download,
> install, and use the Brio plug-in (also the plug-in would require
managing
> the number of concurrent users).  With this approach there are
issues that
> have been identified that are at odds with the requirements for
distributing
> the data over the internet; the most pressing being that this data
is
> intended to be available to the public and therefore should not need
a user
> Id and password to be presented.  Below are some issues and my
understanding
> with respect to v8.1.2:
>
> (1)        Using the Brio iServer EIS and report bqy files cannot be
called
> without requiring the user to login with a user ID and password.
Embedding
> the user name and password in the URL does not log the user into the
server.
>
> (2)        The reports are presented using frames with the top frame
being a
> gray button (menu) bar.  This is how the iServer delivers the report
at the
> present time there is not a way to alter or remove this bar.
>
> (3)        Any mouse or keyboard click on EIS page the objects (drop
down
> lists, radio buttons, result sets, etc.) cause a request being sent
to the
> server and the regeneration of the EIS page.  The object on the EIS
pages
> are only links, meaning that the content is not live so any mouse or
> keyboard clicks that affect these objects need to be resolved at the
server
> and the page regenerated and sent back to the user's browser.  If
the object
> is a result set, then the server will return a new page only
showing the
> result set (for the user to return to the EIS, they need to use the
gray
> button bar).
>
> I have been told that each of these is issues that are "on the
list" and
> "will be delivered in a future release."  It is good that these are
being
> fixed; however, this does not help my current situation.  Has
anyone out
> there experienced these issues and know of any way to get around it?
  Thanks
> for any help you can provide.
>
> Sincerely,
>
> Art
>
>
> [Non-text portions of this message have been removed]

#658

From: "Aureliano" <anarro@...>
Date: Tue Nov 4, 2003 4:55 pm
Subject: Brio 8 iServer Permanent Cookie

smsysupd

Offline

*Brio 8 iServer Permanent Cookie*

Hello group,

I know that you are all working on my last post :) but I do have
another issue/question.  I have been looking at my reports (delivered
via the iServer) and noticed that there is a permanent cookie being
written to the workstation.  That is something I need to eliminate for
my implementation.  I have set the security on my browser to see it
being created and need a way to get around having a permanent cookie
written (session cookies are OK).

Thanks,

Art

#657

From: "Narro, Arthur (HRSA)" <anarro@...>
Date: Mon Nov 3, 2003 4:31 pm
Subject: Unexpected Features in Version 8.1.2

smsysupd

Offline

Hello Group,

I want to use Brio version 8.1.2 iServer to present the reports over the
web.  The intent of this approach was to avoid having users download,
install, and use the Brio plug-in (also the plug-in would require managing
the number of concurrent users).  With this approach there are issues that
have been identified that are at odds with the requirements for distributing
the data over the internet; the most pressing being that this data is
intended to be available to the public and therefore should not need a user
Id and password to be presented.  Below are some issues and my understanding
with respect to v8.1.2:

(1)        Using the Brio iServer EIS and report bqy files cannot be called
without requiring the user to login with a user ID and password.  Embedding
the user name and password in the URL does not log the user into the server.

(2)        The reports are presented using frames with the top frame being a
gray button (menu) bar.  This is how the iServer delivers the report at the
present time there is not a way to alter or remove this bar.

(3)        Any mouse or keyboard click on EIS page the objects (drop down
lists, radio buttons, result sets, etc.) cause a request being sent to the
server and the regeneration of the EIS page.  The object on the EIS pages
are only links, meaning that the content is not live so any mouse or
keyboard clicks that affect these objects need to be resolved at the server
and the page regenerated and sent back to the user's browser.  If the object
is a result set, then the server will return a new page only showing the
result set (for the user to return to the EIS, they need to use the gray
button bar).

I have been told that each of these is issues that are "on the list" and
"will be delivered in a future release."  It is good that these are being
fixed; however, this does not help my current situation.  Has anyone out
there experienced these issues and know of any way to get around it?  Thanks
for any help you can provide.

Sincerely,

Art


[Non-text portions of this message have been removed]

#656

From: Steve Cavill <steve.cavill@...>
Date: Fri Oct 24, 2003 6:39 am
Subject: RE: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

stevecavill

Offline

There's another group called rm-users (meaning reportmart users - reportmart
is the old name of brio.portal).  Though it's pretty quiet.  You can
subscribe to that and read the archives at sqrug.org.
Cheers, Steve.

-----Original Message-----
From: Steve Cavill [mailto:steve.cavill@...]
Sent: Friday, 24 October 2003 4:35 PM
To: brioportalusersgroup@yahoogroups.com
Subject: RE: [Brio Portal Users Group] Can Output From Scheduled SQR Be
Published To Portal?


Great to hear it's working, that's what the email group is here for :-)
Steve.

-----Original Message-----
From: shemkbd [mailto:shemkbd@...]
Sent: Friday, 24 October 2003 2:30 AM
To: brioportalusersgroup@yahoogroups.com
Subject: Re: [Brio Portal Users Group] Can Output From Scheduled SQR Be
Published To Portal?


Steve,
I think I found the problem.  I believe it had to do with the default
group that was selected for the user creating the portal objects.
After reading the on-line help for permissions more carefully it
became a bit clearer to me.  Once I redefined the default groups for
the appropriate users everything works fine.  And it appears that
this applies to the 'administrator' super-user as well.

I'm slowly learning the admin side of this platform.

Thanks again for your help.  You got me going on the right path.

-bernie




--- In brioportalusersgroup@yahoogroups.com, Steve Cavill
<steve.cavill@i...> wrote:
> Certainly sounds odd.  The Administrator's Guide is the only
resource I am
> aware of.
> administrator is defined as a "super-user" so permissions are
ignored for
> administrator.
> If administrator can't see the output then it really isn't there!
>
> There's something odd happening, but I can't think of anywhere
obvious to
> start looking, except for the logs which you have already looked at.
>
> Steve.
>
> -----Original Message-----
> From: shemkbd [mailto:shemkbd@n...]
> Sent: Wednesday, 22 October 2003 10:07 PM
> To: brioportalusersgroup@yahoogroups.com
> Subject: Re: [Brio Portal Users Group] Can Output From Scheduled
SQR Be
> Published To Portal?
>
>
> Thanks Steve.
> Success - although not straight forward.
>
> Permissions are a bit confusing to me.  Originally, I logged into
> One/Administrator using the 'administrator' id, published the sqr to
> portal and set up the scheduled job (all through ONE/Administrator
> as 'administrator').  The sqr executed succesfully on schedule but
no
> output was published to portal. I tried different combos of
> permissions for the published sqr, the portal category and some test
> user id's as well.  No luck. The log didn't indicate any output was
> created. In some cases the log indicated that the user executing the
> sqr did not have write permissions to the category.  I couldn't find
> a conflict in the permission settings (at least from what I could
> tell).
>
> After a while I decided to start over.  This time I logged into
> One\Administrator Publisher using a 'test user id' and published a
> copy of the same sqr (a copy with a slightly different name).
> This 'test user id' could did not have authority to use Scheduler in
> ONE/Administrator so I logged into Portal with that same 'test user
> id'.  From there I set up a schedule for the job based on an
existing
> time event that was previously created by 'administrator' via
> ONE/Administrator.  Everything worked fine.  The sqr job executed on
> schedule, successfully completed and produced/published output to
the
> portal.
>
> I don't know why the scheduling scenario using my 'test user id'
> through the portal worked, but the scheduling scenario using
> the 'administrator' id via One/Administrator didn't.
>
> I looked through the Brio.Portal administrators guide but it didn't
> really clarify permissions for me - especially relative to
> publishing, scheduling and output.  Do you know of any good
resources
> that explain this portion of portal well? Maybe it's an obvious
thing
> that I'm just not seeing.
>
> Thanks again for your help.  -bernie
>
>
> --- In brioportalusersgroup@yahoogroups.com, Steve Cavill
> <steve.cavill@i...> wrote:
> > Hi Bernie,
> > the behaviour of a run-on-demand job and a scheduled job should be
> the same.
> > It could be a permissions problem - if different users run the job
> vs
> > schedule the job, then you could have different results due to
> permissions.
> > Are you sure the output is not published, or is it you just can't
> see the
> > output.
> >
> > The best way to diagnose this would be to turn on job factory
> debugging (in
> > the one/setup tool) and check the job factory log, which shows all
> the
> > output being created and published.
> >
> > Cheers, Steve.
> >
> > -----Original Message-----
> > From: shemkbd [mailto:shemkbd@n...]
> > Sent: Saturday, 18 October 2003 2:44 AM
> > To: brioportalusersgroup@yahoogroups.com
> > Subject: [Brio Portal Users Group] Can Output From Scheduled SQR
Be
> > Published To Portal?
> >
> >
> > We have an SQR job/program that has been published to the Portal.
> > The main purpose of the job/program is to query an Oracle table
and
> > send email to individuals based on the query results.  The output
> file
> > (s) contain the body of each email that is sent and is used as
> > confirmation of the individual email sent by the administration
> team.
> >
> > When that SQR job/program is executed manually through Portal (end
> > user selects the SQR job/program) the program runs successfully,
> > emails are sent and the output files are 'pubished' to the Portal
> > (html and spf files).  However, when the same SQR job/program is
> > executed via Scheduler it runs successfully, sends email but no
> > output files are created in Portal.
> >
> > Is this normal? Can the Scheduled SQR job/program be 'enabled' to
> > produce the same output files in Portal that are generated when it
> is
> > executed manually?
> >
> > We are using Brio Performance Suite on NT - Portal 7.0.3, SQR
6.2.1.
> >
> > Any help is appreciated.
> >
> > Thanks,
> > Bernie
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
brioportalusersgroup-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

#655

From: Steve Cavill <steve.cavill@...>
Date: Fri Oct 24, 2003 6:34 am
Subject: RE: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

stevecavill

Offline

Great to hear it's working, that's what the email group is here for :-)
Steve.

-----Original Message-----
From: shemkbd [mailto:shemkbd@...]
Sent: Friday, 24 October 2003 2:30 AM
To: brioportalusersgroup@yahoogroups.com
Subject: Re: [Brio Portal Users Group] Can Output From Scheduled SQR Be
Published To Portal?


Steve,
I think I found the problem.  I believe it had to do with the default
group that was selected for the user creating the portal objects.
After reading the on-line help for permissions more carefully it
became a bit clearer to me.  Once I redefined the default groups for
the appropriate users everything works fine.  And it appears that
this applies to the 'administrator' super-user as well.

I'm slowly learning the admin side of this platform.

Thanks again for your help.  You got me going on the right path.

-bernie




--- In brioportalusersgroup@yahoogroups.com, Steve Cavill
<steve.cavill@i...> wrote:
> Certainly sounds odd.  The Administrator's Guide is the only
resource I am
> aware of.
> administrator is defined as a "super-user" so permissions are
ignored for
> administrator.
> If administrator can't see the output then it really isn't there!
>
> There's something odd happening, but I can't think of anywhere
obvious to
> start looking, except for the logs which you have already looked at.
>
> Steve.
>
> -----Original Message-----
> From: shemkbd [mailto:shemkbd@n...]
> Sent: Wednesday, 22 October 2003 10:07 PM
> To: brioportalusersgroup@yahoogroups.com
> Subject: Re: [Brio Portal Users Group] Can Output From Scheduled
SQR Be
> Published To Portal?
>
>
> Thanks Steve.
> Success - although not straight forward.
>
> Permissions are a bit confusing to me.  Originally, I logged into
> One/Administrator using the 'administrator' id, published the sqr to
> portal and set up the scheduled job (all through ONE/Administrator
> as 'administrator').  The sqr executed succesfully on schedule but
no
> output was published to portal. I tried different combos of
> permissions for the published sqr, the portal category and some test
> user id's as well.  No luck. The log didn't indicate any output was
> created. In some cases the log indicated that the user executing the
> sqr did not have write permissions to the category.  I couldn't find
> a conflict in the permission settings (at least from what I could
> tell).
>
> After a while I decided to start over.  This time I logged into
> One\Administrator Publisher using a 'test user id' and published a
> copy of the same sqr (a copy with a slightly different name).
> This 'test user id' could did not have authority to use Scheduler in
> ONE/Administrator so I logged into Portal with that same 'test user
> id'.  From there I set up a schedule for the job based on an
existing
> time event that was previously created by 'administrator' via
> ONE/Administrator.  Everything worked fine.  The sqr job executed on
> schedule, successfully completed and produced/published output to
the
> portal.
>
> I don't know why the scheduling scenario using my 'test user id'
> through the portal worked, but the scheduling scenario using
> the 'administrator' id via One/Administrator didn't.
>
> I looked through the Brio.Portal administrators guide but it didn't
> really clarify permissions for me - especially relative to
> publishing, scheduling and output.  Do you know of any good
resources
> that explain this portion of portal well? Maybe it's an obvious
thing
> that I'm just not seeing.
>
> Thanks again for your help.  -bernie
>
>
> --- In brioportalusersgroup@yahoogroups.com, Steve Cavill
> <steve.cavill@i...> wrote:
> > Hi Bernie,
> > the behaviour of a run-on-demand job and a scheduled job should be
> the same.
> > It could be a permissions problem - if different users run the job
> vs
> > schedule the job, then you could have different results due to
> permissions.
> > Are you sure the output is not published, or is it you just can't
> see the
> > output.
> >
> > The best way to diagnose this would be to turn on job factory
> debugging (in
> > the one/setup tool) and check the job factory log, which shows all
> the
> > output being created and published.
> >
> > Cheers, Steve.
> >
> > -----Original Message-----
> > From: shemkbd [mailto:shemkbd@n...]
> > Sent: Saturday, 18 October 2003 2:44 AM
> > To: brioportalusersgroup@yahoogroups.com
> > Subject: [Brio Portal Users Group] Can Output From Scheduled SQR
Be
> > Published To Portal?
> >
> >
> > We have an SQR job/program that has been published to the Portal.
> > The main purpose of the job/program is to query an Oracle table
and
> > send email to individuals based on the query results.  The output
> file
> > (s) contain the body of each email that is sent and is used as
> > confirmation of the individual email sent by the administration
> team.
> >
> > When that SQR job/program is executed manually through Portal (end
> > user selects the SQR job/program) the program runs successfully,
> > emails are sent and the output files are 'pubished' to the Portal
> > (html and spf files).  However, when the same SQR job/program is
> > executed via Scheduler it runs successfully, sends email but no
> > output files are created in Portal.
> >
> > Is this normal? Can the Scheduled SQR job/program be 'enabled' to
> > produce the same output files in Portal that are generated when it
> is
> > executed manually?
> >
> > We are using Brio Performance Suite on NT - Portal 7.0.3, SQR
6.2.1.
> >
> > Any help is appreciated.
> >
> > Thanks,
> > Bernie
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/


To unsubscribe from this group, send an email to:
brioportalusersgroup-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

#654

From: "shemkbd" <shemkbd@...>
Date: Thu Oct 23, 2003 4:29 pm
Subject: Re: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

shemkbd

Offline

Steve,
I think I found the problem.  I believe it had to do with the default
group that was selected for the user creating the portal objects.
After reading the on-line help for permissions more carefully it
became a bit clearer to me.  Once I redefined the default groups for
the appropriate users everything works fine.  And it appears that
this applies to the 'administrator' super-user as well.

I'm slowly learning the admin side of this platform.

Thanks again for your help.  You got me going on the right path.

-bernie




--- In brioportalusersgroup@yahoogroups.com, Steve Cavill
<steve.cavill@i...> wrote:
> Certainly sounds odd.  The Administrator's Guide is the only
resource I am
> aware of.
> administrator is defined as a "super-user" so permissions are
ignored for
> administrator.
> If administrator can't see the output then it really isn't there!
>
> There's something odd happening, but I can't think of anywhere
obvious to
> start looking, except for the logs which you have already looked at.
>
> Steve.
>
> -----Original Message-----
> From: shemkbd [mailto:shemkbd@n...]
> Sent: Wednesday, 22 October 2003 10:07 PM
> To: brioportalusersgroup@yahoogroups.com
> Subject: Re: [Brio Portal Users Group] Can Output From Scheduled
SQR Be
> Published To Portal?
>
>
> Thanks Steve.
> Success - although not straight forward.
>
> Permissions are a bit confusing to me.  Originally, I logged into
> One/Administrator using the 'administrator' id, published the sqr to
> portal and set up the scheduled job (all through ONE/Administrator
> as 'administrator').  The sqr executed succesfully on schedule but
no
> output was published to portal. I tried different combos of
> permissions for the published sqr, the portal category and some test
> user id's as well.  No luck. The log didn't indicate any output was
> created. In some cases the log indicated that the user executing the
> sqr did not have write permissions to the category.  I couldn't find
> a conflict in the permission settings (at least from what I could
> tell).
>
> After a while I decided to start over.  This time I logged into
> One\Administrator Publisher using a 'test user id' and published a
> copy of the same sqr (a copy with a slightly different name).
> This 'test user id' could did not have authority to use Scheduler in
> ONE/Administrator so I logged into Portal with that same 'test user
> id'.  From there I set up a schedule for the job based on an
existing
> time event that was previously created by 'administrator' via
> ONE/Administrator.  Everything worked fine.  The sqr job executed on
> schedule, successfully completed and produced/published output to
the
> portal.
>
> I don't know why the scheduling scenario using my 'test user id'
> through the portal worked, but the scheduling scenario using
> the 'administrator' id via One/Administrator didn't.
>
> I looked through the Brio.Portal administrators guide but it didn't
> really clarify permissions for me - especially relative to
> publishing, scheduling and output.  Do you know of any good
resources
> that explain this portion of portal well? Maybe it's an obvious
thing
> that I'm just not seeing.
>
> Thanks again for your help.  -bernie
>
>
> --- In brioportalusersgroup@yahoogroups.com, Steve Cavill
> <steve.cavill@i...> wrote:
> > Hi Bernie,
> > the behaviour of a run-on-demand job and a scheduled job should be
> the same.
> > It could be a permissions problem - if different users run the job
> vs
> > schedule the job, then you could have different results due to
> permissions.
> > Are you sure the output is not published, or is it you just can't
> see the
> > output.
> >
> > The best way to diagnose this would be to turn on job factory
> debugging (in
> > the one/setup tool) and check the job factory log, which shows all
> the
> > output being created and published.
> >
> > Cheers, Steve.
> >
> > -----Original Message-----
> > From: shemkbd [mailto:shemkbd@n...]
> > Sent: Saturday, 18 October 2003 2:44 AM
> > To: brioportalusersgroup@yahoogroups.com
> > Subject: [Brio Portal Users Group] Can Output From Scheduled SQR
Be
> > Published To Portal?
> >
> >
> > We have an SQR job/program that has been published to the Portal.
> > The main purpose of the job/program is to query an Oracle table
and
> > send email to individuals based on the query results.  The output
> file
> > (s) contain the body of each email that is sent and is used as
> > confirmation of the individual email sent by the administration
> team.
> >
> > When that SQR job/program is executed manually through Portal (end
> > user selects the SQR job/program) the program runs successfully,
> > emails are sent and the output files are 'pubished' to the Portal
> > (html and spf files).  However, when the same SQR job/program is
> > executed via Scheduler it runs successfully, sends email but no
> > output files are created in Portal.
> >
> > Is this normal? Can the Scheduled SQR job/program be 'enabled' to
> > produce the same output files in Portal that are generated when it
> is
> > executed manually?
> >
> > We are using Brio Performance Suite on NT - Portal 7.0.3, SQR
6.2.1.
> >
> > Any help is appreciated.
> >
> > Thanks,
> > Bernie
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > brioportalusersgroup-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

#653

From: Steve Cavill <steve.cavill@...>
Date: Wed Oct 22, 2003 12:52 pm
Subject: RE: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

stevecavill

Offline

Certainly sounds odd.  The Administrator's Guide is the only resource I am
aware of.
administrator is defined as a "super-user" so permissions are ignored for
administrator.
If administrator can't see the output then it really isn't there!

There's something odd happening, but I can't think of anywhere obvious to
start looking, except for the logs which you have already looked at.

Steve.

-----Original Message-----
From: shemkbd [mailto:shemkbd@...]
Sent: Wednesday, 22 October 2003 10:07 PM
To: brioportalusersgroup@yahoogroups.com
Subject: Re: [Brio Portal Users Group] Can Output From Scheduled SQR Be
Published To Portal?

Thanks Steve.
Success - although not straight forward.

Permissions are a bit confusing to me.  Originally, I logged into
One/Administrator using the 'administrator' id, published the sqr to
portal and set up the scheduled job (all through ONE/Administrator
as 'administrator').  The sqr executed succesfully on schedule but no
output was published to portal. I tried different combos of
permissions for the published sqr, the portal category and some test
user id's as well.  No luck. The log didn't indicate any output was
created. In some cases the log indicated that the user executing the
sqr did not have write permissions to the category.  I couldn't find
a conflict in the permission settings (at least from what I could
tell).

After a while I decided to start over.  This time I logged into
One\Administrator Publisher using a 'test user id' and published a
copy of the same sqr (a copy with a slightly different name).
This 'test user id' could did not have authority to use Scheduler in
ONE/Administrator so I logged into Portal with that same 'test user
id'.  From there I set up a schedule for the job based on an existing
time event that was previously created by 'administrator' via
ONE/Administrator.  Everything worked fine.  The sqr job executed on
schedule, successfully completed and produced/published output to the
portal.

I don't know why the scheduling scenario using my 'test user id'
through the portal worked, but the scheduling scenario using
the 'administrator' id via One/Administrator didn't.

I looked through the Brio.Portal administrators guide but it didn't
really clarify permissions for me - especially relative to
publishing, scheduling and output.  Do you know of any good resources
that explain this portion of portal well? Maybe it's an obvious thing
that I'm just not seeing.

Thanks again for your help.  -bernie

--- In brioportalusersgroup@yahoogroups.com, Steve Cavill
<steve.cavill@i...> wrote:
> Hi Bernie,
> the behaviour of a run-on-demand job and a scheduled job should be
the same.
> It could be a permissions problem - if different users run the job
vs
> schedule the job, then you could have different results due to
permissions.
> Are you sure the output is not published, or is it you just can't
see the
> output.
>
> The best way to diagnose this would be to turn on job factory
debugging (in
> the one/setup tool) and check the job factory log, which shows all
the
> output being created and published.
>
> Cheers, Steve.
>
> -----Original Message-----
> From: shemkbd [mailto:shemkbd@n...]
> Sent: Saturday, 18 October 2003 2:44 AM
> To: brioportalusersgroup@yahoogroups.com
> Subject: [Brio Portal Users Group] Can Output From Scheduled SQR Be
> Published To Portal?
>
>
> We have an SQR job/program that has been published to the Portal.
> The main purpose of the job/program is to query an Oracle table and
> send email to individuals based on the query results.  The output
file
> (s) contain the body of each email that is sent and is used as
> confirmation of the individual email sent by the administration
team.
>
> When that SQR job/program is executed manually through Portal (end
> user selects the SQR job/program) the program runs successfully,
> emails are sent and the output files are 'pubished' to the Portal
> (html and spf files).  However, when the same SQR job/program is
> executed via Scheduler it runs successfully, sends email but no
> output files are created in Portal.
>
> Is this normal? Can the Scheduled SQR job/program be 'enabled' to
> produce the same output files in Portal that are generated when it
is
> executed manually?
>
> We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.
>
> Any help is appreciated.
>
> Thanks,
> Bernie
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
brioportalusersgroup-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

#652

From: "shemkbd" <shemkbd@...>
Date: Wed Oct 22, 2003 12:06 pm
Subject: Re: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

shemkbd

Offline

Thanks Steve.
Success - although not straight forward.

Permissions are a bit confusing to me.  Originally, I logged into
One/Administrator using the 'administrator' id, published the sqr to
portal and set up the scheduled job (all through ONE/Administrator
as 'administrator').  The sqr executed succesfully on schedule but no
output was published to portal. I tried different combos of
permissions for the published sqr, the portal category and some test
user id's as well.  No luck. The log didn't indicate any output was
created. In some cases the log indicated that the user executing the
sqr did not have write permissions to the category.  I couldn't find
a conflict in the permission settings (at least from what I could
tell).

After a while I decided to start over.  This time I logged into
One\Administrator Publisher using a 'test user id' and published a
copy of the same sqr (a copy with a slightly different name).
This 'test user id' could did not have authority to use Scheduler in
ONE/Administrator so I logged into Portal with that same 'test user
id'.  From there I set up a schedule for the job based on an existing
time event that was previously created by 'administrator' via
ONE/Administrator.  Everything worked fine.  The sqr job executed on
schedule, successfully completed and produced/published output to the
portal.

I don't know why the scheduling scenario using my 'test user id'
through the portal worked, but the scheduling scenario using
the 'administrator' id via One/Administrator didn't.

I looked through the Brio.Portal administrators guide but it didn't
really clarify permissions for me - especially relative to
publishing, scheduling and output.  Do you know of any good resources
that explain this portion of portal well? Maybe it's an obvious thing
that I'm just not seeing.

Thanks again for your help.  -bernie

--- In brioportalusersgroup@yahoogroups.com, Steve Cavill
<steve.cavill@i...> wrote:
> Hi Bernie,
> the behaviour of a run-on-demand job and a scheduled job should be
the same.
> It could be a permissions problem - if different users run the job
vs
> schedule the job, then you could have different results due to
permissions.
> Are you sure the output is not published, or is it you just can't
see the
> output.
>
> The best way to diagnose this would be to turn on job factory
debugging (in
> the one/setup tool) and check the job factory log, which shows all
the
> output being created and published.
>
> Cheers, Steve.
>
> -----Original Message-----
> From: shemkbd [mailto:shemkbd@n...]
> Sent: Saturday, 18 October 2003 2:44 AM
> To: brioportalusersgroup@yahoogroups.com
> Subject: [Brio Portal Users Group] Can Output From Scheduled SQR Be
> Published To Portal?
>
>
> We have an SQR job/program that has been published to the Portal.
> The main purpose of the job/program is to query an Oracle table and
> send email to individuals based on the query results.  The output
file
> (s) contain the body of each email that is sent and is used as
> confirmation of the individual email sent by the administration
team.
>
> When that SQR job/program is executed manually through Portal (end
> user selects the SQR job/program) the program runs successfully,
> emails are sent and the output files are 'pubished' to the Portal
> (html and spf files).  However, when the same SQR job/program is
> executed via Scheduler it runs successfully, sends email but no
> output files are created in Portal.
>
> Is this normal? Can the Scheduled SQR job/program be 'enabled' to
> produce the same output files in Portal that are generated when it
is
> executed manually?
>
> We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.
>
> Any help is appreciated.
>
> Thanks,
> Bernie
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> brioportalusersgroup-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/

#651

From: unixjedi
Date: Sun Oct 19, 2003 6:14 am
Subject: Re: Installing Brio 8????

unixjedi

Offline

Hello,
Did you create and C:\overrides  directory and then copy the
db2java.zip into this? Also make sure that in you SQLLIB\java12 you
run the usejava2.bat.

Rob

--- In brioportalusersgroup@yahoogroups.com, "rbarila" <rbarila@y...>
wrote:
> I'm trying to install the Brio 8 servers cd 1 of 2 on a Windows 2000
> Server with IIS and a DB2 7.2 database. When I get to the screen
> where it says: "Enter the connection parameters for the Repository
> database. This information is used to create the Brio Repository
> database tables". It hangs on this screen after I enter the
> parameters and click OK. A DB2 database was setup prior to the
> install.
>
> Thanks.

#650

From: Steve Cavill <steve.cavill@...>
Date: Sat Oct 18, 2003 3:25 am
Subject: RE: [Brio Portal Users Group] Can Output From Scheduled SQR Be Published To Portal?

stevecavill

Offline

Hi Bernie,
the behaviour of a run-on-demand job and a scheduled job should be the same.
It could be a permissions problem - if different users run the job vs
schedule the job, then you could have different results due to permissions.
Are you sure the output is not published, or is it you just can't see the
output.

The best way to diagnose this would be to turn on job factory debugging (in
the one/setup tool) and check the job factory log, which shows all the
output being created and published.

Cheers, Steve.

-----Original Message-----
From: shemkbd [mailto:shemkbd@...]
Sent: Saturday, 18 October 2003 2:44 AM
To: brioportalusersgroup@yahoogroups.com
Subject: [Brio Portal Users Group] Can Output From Scheduled SQR Be
Published To Portal?


We have an SQR job/program that has been published to the Portal.
The main purpose of the job/program is to query an Oracle table and
send email to individuals based on the query results.  The output file
(s) contain the body of each email that is sent and is used as
confirmation of the individual email sent by the administration team.

When that SQR job/program is executed manually through Portal (end
user selects the SQR job/program) the program runs successfully,
emails are sent and the output files are 'pubished' to the Portal
(html and spf files).  However, when the same SQR job/program is
executed via Scheduler it runs successfully, sends email but no
output files are created in Portal.

Is this normal? Can the Scheduled SQR job/program be 'enabled' to
produce the same output files in Portal that are generated when it is
executed manually?

We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.

Any help is appreciated.

Thanks,
Bernie





To unsubscribe from this group, send an email to:
brioportalusersgroup-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

#649

From: "shemkbd" <shemkbd@...>
Date: Fri Oct 17, 2003 4:43 pm
Subject: Can Output From Scheduled SQR Be Published To Portal?

shemkbd

Offline

We have an SQR job/program that has been published to the Portal.
The main purpose of the job/program is to query an Oracle table and
send email to individuals based on the query results.  The output file
(s) contain the body of each email that is sent and is used as
confirmation of the individual email sent by the administration team.

When that SQR job/program is executed manually through Portal (end
user selects the SQR job/program) the program runs successfully,
emails are sent and the output files are 'pubished' to the Portal
(html and spf files).  However, when the same SQR job/program is
executed via Scheduler it runs successfully, sends email but no
output files are created in Portal.

Is this normal? Can the Scheduled SQR job/program be 'enabled' to
produce the same output files in Portal that are generated when it is
executed manually?

We are using Brio Performance Suite on NT - Portal 7.0.3, SQR 6.2.1.

Any help is appreciated.

Thanks,
Bernie