Search the web
Sign In
New User? Sign Up
briousers · Brio Users - Help with deploying Brio Enterprise
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 15700 - 15825 of 15825   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#15825 From: "aekrouse18" <arica.krouse@...>
Date: Mon Dec 14, 2009 5:24 pm
Subject: Hyperion Developer needed at PNC Bank - FT Permanent Opportunity
aekrouse18
Offline Offline
Send Email Send Email
 
PNC Bank is searching for a Hyperion Developer II.  The position can work in
Cleveland, OH or Pittsburgh, PA. Interested individuals may send a copy of your
resume to the corporate IT Sourcing Recruiter at arica.krouse@.... Please
note: Third party resumes are not accepted. Thank you.

As an employee of PNC Financial Services Group, you become part of an
organization committed to customers, employees, investors, and the communities
in which we do business. PNC is an established, growing and successful financial
services company, with businesses organized around retail and commercial
banking, asset management, and funds processing. Our branches are concentrated
in thirteen states and the District of Columbia; additional offices are located
nationwide and internationally. We are growing in size and through recent
acquisitions have become the fifth largest bank by deposits in the US. We are
also growing in reputation, as a leader in areas such as work/life family
culture, "green" building design, frontier technology, and strong corporate
social responsibility.

As a Hyperion Developer, you are a member of PNC's Technology division. You will
be working with our Hyperion application. You will need 5 + years of Hyperion
development experience to play both support and project roles.

The successful candidate will have familiarity with Hyperion 9.3.1 including:

-Web Analysis
-Excel Add-In
-Financial Reporting
-Interactive Reporting (IR)
-ASO and BSO cube building
-Enterprise Integration Server (EIS) module to drill through from aggregated
data in Essbase cubes to transactional data in Oracle tables
-Analytical Provider Services (APS) in Hyperion to manage clustering of cubes.
-Shared Services
-Common Services
-Budget and Planning module is on our roadmap for 2010 so experience with this
is a plus.

You will also need demonstrable project experience/skills including:
-Scope/Requirements evaluation and Negotiation
-Estimating
-Critical Path definition
-Risk and Issue identification
-Effective written, graphical and verbal communication
-Production of clear design docs
-Creation of effective unit test plans including test data requirements

Demonstrable Support experience:
-Effective troubleshooting methodology
-Clear, explanatory, periodic communication during issue resolution
-Work effectively, productively with vendors and other departments to drive
resolution
-Works pro-actively to eliminate root causes of issues

Oracle database familiarity:
-Table / View creation and optimization
PL SQL

Infrastructure Familiarity:

-Linux/Unix (web server)
-Windows Servers
-VM Ware

PNC is committed to offering you a comprehensive and competitive benefits
package. We design our full time and part time benefits programs based on PNC's
benefits philosophy to provide quality levels of coverage at affordable costs
over the long term for both employees and PNC. We strive to balance the cost of
providing competitive benefits with the need to cover employees with a wide
range of protection during and after employment.

Options you may be able to consider include:

-Medical and Dental Coverage
-Life Insurance
-Part Time Benefits
-Education Assistance
-Paid Training
-Paid Vacation
-Competitive Pay
-Shift Differential
-401(k)
-Flexible Schedules
-Growth Opportunity
-Work/Life Balance

PNC is an Equal Employment Opportunity/Affirmative Action Employer -- M/F/D/V/SO

#15824 From: "jain_vikas_rectian" <jain_vikas_rectian@...>
Date: Fri Dec 4, 2009 11:48 am
Subject: Inserting the Brio Query Data into EIS OLAP Model tables directly
jain_vikas_r...
Offline Offline
Send Email Send Email
 
Hello Experts,

I am not very expert in using Hyperion Interactive Reporting and
Hyperion Integration Services(EIS/AIS). Can someone please help me by
sharing the knowledge on how we can directly insert the results(records)
of a brio query (from the execution of .bqy file) into the tables of an
OLAP model on EIS?

Someone advised me to write a JOOLE code for "post-process" event. I
don't have a head and tail of this thing. Can someone elaborate/guide?

Thank you,
Vikas Jain

#15823 From: larryt1985
Date: Thu Oct 22, 2009 8:58 pm
Subject: Re: Brio Software
larryt1985
Offline Offline
 
Brio(Hyperion) is now owned by Oracle

--- In briousers@yahoogroups.com, "Alex Oliveira" <alex.maior@...> wrote:
>
> Hi,
>
>     I would like to utilized a BRIO tool (Enterprise and BI), where I find
> this tool. Thanks
>
>
>   Regards
>
>   Alex Oliveira
>

#15822 From: "Ganesh/Ram" <nramganesh@...>
Date: Tue Oct 13, 2009 10:28 pm
Subject: Single logon for multiple reports
nramganesh
Offline Offline
Send Email Send Email
 
Hyperion Portal Insight 8.3

I have 28 reports that are to be migrated into Hyperion Insight. They are at
present in Hyperion Explorer.

It has a single login page where login information (user name and password) is
captured and then the menu page opens up.

In the menu page there are 28 links pointing to different dashboards,charts and
results. Also, this login page is a seperate query and this query calls other 28
queries and based on java script intelligence it passes on actual report
name,dashboard name and also user authorization details.

Now while migrating it onto Hyperion Portal insight, since it is web based -

1. How can I have single logon for these 28 reports stored and passed onto other
reports? since here the method for web sessions is OpenURL method.What do you
suggest? how can I achieve this? Please help.

Thanks very much.
Ram

#15821 From: "Bob" <haasrg@...>
Date: Mon Sep 28, 2009 7:20 pm
Subject: Custom SQL and Teradata
haasrg
Offline Offline
Send Email Send Email
 
I have a need to add a between statement in a custom SQL statement on a limit
line.  I am using Teradata and the following statement works for returning a
single value (
Cldr.Fsc_Yr_Num = select (Max(Fsc_Yr_Num) -2 )
from User_View.CLDR
Where Fsc_Wk_Prev_Clsd_Ind = 'Y'     ---- Returns 2008

this also works

Cldr.Fsc_Yr_Num = select (Max(Fsc_Yr_Num) )
from User_View.CLDR
Where Fsc_Wk_Prev_Clsd_Ind = 'Y'     ---- Returns 2010

But when I place them in a between statement

Cldr.Fsc_Yr_Num BETWEEN (select (Max(Fsc_Yr_Num) -2 )
from User_View.CLDR
Where Fsc_Wk_Prev_Clsd_Ind = 'Y' ) AND (select (Max(Fsc_Yr_Num)  )
from User_View.CLDR
Where Fsc_Wk_Prev_Clsd_Ind = 'Y' )

I get the following error:
SQL API (SQLExecDirectW, SQL RETURN (-1), SQL STATE: [42000], SQL NATIVE ERROR:
[-3706] SQL MESSAGE [[NCR][ODBC Taredata Driver] [Teradata Database] Syntax
error: expected something between '(' and the 'select' keyword ]

I have tried all combos of parens and case but get the same error consistantly

Can anyone help ... First month here and would like to show its functionality ..
have used this extensively in ORACLE using the same syntax

Bob

#15820 From: "mustluvdogs50" <loveallc@...>
Date: Fri Sep 25, 2009 2:13 pm
Subject: Unexpected end of file error
mustluvdogs50
Offline Offline
Send Email Send Email
 
Hi,

When attempting to open a .bqy file we are getting an "Unexpected end of file"
error message and can't open the file.  It has been used previously with no
problem.  Since I didn't create the query I don't know what is in it to recreate
it and I have a user who really needs the information.  I found some posts on
this forum from several years ago from others who were having the same problem
but I haven't found a solution.  Has anyone found a solution to this problem? 
Any help would be greatly appreciated!

Thank you!

#15818 From: soleary007
Date: Fri Aug 7, 2009 5:17 pm
Subject: Re: numbers of columns we can process at a time from a query on server in Brio
soleary007
Offline Offline
 
There is an has a total size limitation. it's not directly related to the number
of columns, moreso their sum total size.

re:
http://businessintelligence.ittoolbox.com/groups/technical-functional/brio-l/too\
-many-columns-to-retrieve-error-1313830

Overall, a single row can contain no more than 32K bytes of data, no matter how
many columns you select. So, you could select 32 columns of 1024 bytes each, 64
columns of 512 bytes each, 16 columns of 2K (2048 bytes) each, and so on. Any
time the calculated sum of all the columns in the query exceed 32K, this message
will pop up. It is indirectly related to the number of columns requested,
therefore.

This calculation is based on the potential length. So, let's say the
table contains a lot of varchar(2000) columns. But the actual data in
those columns is known to never exceed 50 bytes. A user could find that column
in the data model, edit its properties, and change the length. Then, the
calculated total would become less, allowing the same number
of columns to be selected that previously gave this message.

Note also that a user could change this length, even though the actual
content does run up to 2000 bytes, to be something less. The net effect of this
will be to truncate the data down to the user-entered length. This may also be
perfectly acceptable in some situations.


--- In briousers@yahoogroups.com, "Jai" <angelsdesirein@...> wrote:
>
> Anyone have idea about how many numbers of columns we can process at a
> time from a query on server? I have a query section which have 110
> columns which i am able to process successfully and the time i pull
> another column in request item it throws me an error "Too many columns
> to retrive" on server (Same happens when i run from local machine). On
> which factors it depends?
> Is it related to OCE connection on server ie Buffer size etc.
> I am getting this error in Hyperion Interactive Reporting.
>

#15817 From: andre_duijn
Date: Thu Aug 6, 2009 8:50 pm
Subject: Re: [Brio Users] Changes
andre_duijn
Offline Offline
 
Hi Paddy,

The group won't be deleted.
It just won't be moderated on a daily basis.

André

--- In briousers@yahoogroups.com, Paddy Wan <paddy_wan78@...> wrote:
>
> Hi André,
>
> Sorry for late reply.
> As a new member of the group, i'm really interested in the discussion and
files that you've attached, can we keep it alive there?
> Maybe we just need access grant for new members. Your help would be
appreciated, thanks.
>
> Paddy
> CN
>
>
>
> ________________________________
> From: andre_duijn <no_reply@yahoogroups.com>
> To: briousers@yahoogroups.com
> Sent: Wednesday, July 8, 2009 8:55:06 AM
> Subject: [Brio Users] Changes
>
>
>
>
>
> Hello folks,
>
> I have finally gotten the capability to change the group settings, so I have
set it so that 'new members' need to be granted access first before posting.
This should avoid 99% of the spam we have been receiving.
>
> If there are any serious 'volunteers' out there that want to help keep this
brio archive alive, please let me know.
>
> André
> NZ
>

#15816 From: Paddy Wan <paddy_wan78@...>
Date: Mon Aug 3, 2009 12:43 pm
Subject: Re: [Brio Users] Changes
paddy_wan78
Offline Offline
Send Email Send Email
 
Hi André,
 
Sorry for late reply.
As a new member of the group, i'm really interested in the discussion and files that you've attached, can we keep it alive there?
Maybe we just need access grant for new members. Your help would be appreciated, thanks.
Paddy
CN


From: andre_duijn <no_reply@yahoogroups.com>
To: briousers@yahoogroups.com
Sent: Wednesday, July 8, 2009 8:55:06 AM
Subject: [Brio Users] Changes

Hello folks,

I have finally gotten the capability to change the group settings, so I have set it so that 'new members' need to be granted access first before posting. This should avoid 99% of the spam we have been receiving.

If there are any serious 'volunteers' out there that want to help keep this brio archive alive, please let me know.

André
NZ



#15813 From: "Steve Cavill" <steve.cavill@...>
Date: Thu Jul 9, 2009 10:53 pm
Subject: RE: [Brio Users] Re: Brioqry Object model - results?
stevecavill
Offline Offline
Send Email Send Email
 
Sounds right to me.
A result set and a table are the  same thing.  The difference is the parent.
The parent of a results sections is a query
The parent of a table is another table (or results)
Steve


From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of Glenn Anders
Sent: Friday, 10 July 2009 8:32 AM
To: briousers@yahoogroups.com
Subject: [Brio Users] Re: Brioqry Object model - results?

--- In briousers@yahoogroups.com, andre_duijn <no_reply@...> wrote:
>
> Hi,
>
> There's no distinction 'object class wise' between query and results. They're both 'sections'
>
> I think this is the hierarchy that you're after:
>
> Documents["<document_name>"].Sections["<section_name>"].Limits["<limit_name>"].SelectedValues.Item(<number>)
>
>
> André
> NZ
> --- In briousers@yahoogroups.com, "Glenn Anders" <glenn_anders@> wrote:
> >
> > I am writing a VB.Net program that uses with the Brioqry object model.
> >
> > I see each section has a section type (e.g. query, results, etc). There is a querysection class, but no resultsection class, even tho the sectiontype property of a given section is 'results'.
> >
> > What am I missing? Where do I access the results? In particular, I need access to the limits associated with the results.
> >
> > Thanks.
> >
>
There is a difference if you are using the type library brioqry.tbl from a .Net Application. There is a class for querysection but not for resultsection. If you try to use the querysection class for the results, it errors with a mismatch. The closest I have been able to find, which I think will work, is tablesection. I will be doing more testing to make sure.


#15812 From: "Glenn Anders" <glenn_anders@...>
Date: Thu Jul 9, 2009 10:32 pm
Subject: Re: Brioqry Object model - results?
glenn_anders
Offline Offline
Send Email Send Email
 
--- In briousers@yahoogroups.com, andre_duijn <no_reply@...> wrote:
>
> Hi,
>
> There's no distinction 'object class wise' between query and results. They're
both 'sections'
>
> I think this is the hierarchy that you're after:
>
>
Documents["<document_name>"].Sections["<section_name>"].Limits["<limit_name>"].S\
electedValues.Item(<number>)
>
>
> André
> NZ
> --- In briousers@yahoogroups.com, "Glenn Anders" <glenn_anders@> wrote:
> >
> > I am writing a VB.Net program that uses with the Brioqry object model.
> >
> > I see each section has a section type (e.g. query, results, etc).  There is
a querysection class, but no resultsection class, even tho the sectiontype
property of a given section is 'results'.
> >
> > What am I missing?  Where do I access the results?  In particular, I need
access to the limits associated with the results.
> >
> > Thanks.
> >
>
There is a difference if you are using the type library brioqry.tbl from a .Net
Application. There is a class for querysection but not for resultsection.  If
you try to use the querysection class for the results, it errors with a
mismatch. The closest I have been able to find, which I think will work, is
tablesection.  I will be doing more testing to make sure.

#15811 From: andre_duijn
Date: Wed Jul 8, 2009 12:55 am
Subject: Changes
andre_duijn
Offline Offline
 
Hello folks,

I have finally gotten the capability to change the group settings, so I have set
it so that 'new members' need to be granted access first before posting. This
should avoid 99% of the spam we have been receiving.

If there are any serious 'volunteers' out there that want to help keep this brio
archive alive, please let me know.

André
NZ

#15809 From: andre_duijn
Date: Mon Jul 6, 2009 1:19 am
Subject: Re: Brioqry Object model - results?
andre_duijn
Offline Offline
 
Hi,

There's no distinction 'object class wise' between query and results. They're
both 'sections'

I think this is the hierarchy that you're after:

Documents["<document_name>"].Sections["<section_name>"].Limits["<limit_name>"].S\
electedValues.Item(<number>)


André
NZ
--- In briousers@yahoogroups.com, "Glenn Anders" <glenn_anders@...> wrote:
>
> I am writing a VB.Net program that uses with the Brioqry object model.
>
> I see each section has a section type (e.g. query, results, etc).  There is a
querysection class, but no resultsection class, even tho the sectiontype
property of a given section is 'results'.
>
> What am I missing?  Where do I access the results?  In particular, I need
access to the limits associated with the results.
>
> Thanks.
>

#15808 From: "Glenn Anders" <glenn_anders@...>
Date: Thu Jul 2, 2009 3:32 pm
Subject: Brioqry Object model - results?
glenn_anders
Offline Offline
Send Email Send Email
 
I am writing a VB.Net program that uses with the Brioqry object model.

I see each section has a section type (e.g. query, results, etc).  There is a
querysection class, but no resultsection class, even tho the sectiontype
property of a given section is 'results'.

What am I missing?  Where do I access the results?  In particular, I need access
to the limits associated with the results.

Thanks.

#15779 From: andre_duijn
Date: Sun Mar 15, 2009 11:44 pm
Subject: Re: [Brio Users] Unregister
andre_duijn
Offline Offline
 
Hi Everyone,

Sorry for the spam, but I can't do anything about it other than delete the
messages and ban the users after they have posted.
I'm the only moderator left, but I don't have high enough privliges to change
any of the group posting settings.

If you don't want to receive emails, just go to:

http://tech.groups.yahoo.com/group/briousers

Sign in, and edit your membership and set it to 'no emails' or 'special
notices'.
You can always go to the group regularly and check whether there are any new
group messages that are interesting.

with best regards,
André Duijnmayer
New Zealand
Moderator

#15778 From: "haryanto" <bontih@...>
Date: Sun Mar 15, 2009 7:20 am
Subject: Re: [Brio Users] Unregister
bontih
Offline Offline
Send Email Send Email
 
Same with me.

Tx

Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT


From: sanchita kundu
Date: Sun, 15 Mar 2009 12:46:59 +0530 (IST)
To: <briousers@yahoogroups.com>
Subject: Re: [Brio Users] Unregister

Please unregister my name also from the group..

Thanks,
Sanchita

--- On Sun, 3/15/09, srikrishnan chandrasekharan <srivijay81@yahoo.co.in> wrote:

From: srikrishnan chandrasekharan <srivijay81@yahoo.co.in>
Subject: [Brio Users] Unregister
To: briousers@yahoogroups.com
Date: Sunday, March 15, 2009, 9:11 AM

Hi Administrators,
 
I want to unregister from this group. I don't know whom to contact to request for this.
Last few weeks, I am receiving several unwanted messages,
Kindy please remove id from this group
 
Thanks
Srik
 


Add more friends to your messenger and enjoy! Invite them now.



#15777 From: sanchita kundu <sanchitakundu@...>
Date: Sun Mar 15, 2009 7:16 am
Subject: Re: [Brio Users] Unregister
sanchitakundu
Offline Offline
Send Email Send Email
 
Please unregister my name also from the group..

Thanks,
Sanchita

--- On Sun, 3/15/09, srikrishnan chandrasekharan <srivijay81@...> wrote:

From: srikrishnan chandrasekharan <srivijay81@...>
Subject: [Brio Users] Unregister
To: briousers@yahoogroups.com
Date: Sunday, March 15, 2009, 9:11 AM

Hi Administrators,
 
I want to unregister from this group. I don't know whom to contact to request for this.
Last few weeks, I am receiving several unwanted messages,
Kindy please remove id from this group
 
Thanks
Srik
 


Add more friends to your messenger and enjoy! Invite them now.



#15776 From: srikrishnan chandrasekharan <srivijay81@...>
Date: Sun Mar 15, 2009 3:41 am
Subject: Unregister
srivijay81
Offline Offline
Send Email Send Email
 
Hi Administrators,
 
I want to unregister from this group. I don't know whom to contact to request for this.
Last few weeks, I am receiving several unwanted messages,
Kindy please remove id from this group
 
Thanks
Srik
 


Add more friends to your messenger and enjoy! Invite them now.

#15723 From: "Steve Cavill" <steve.cavill@...>
Date: Fri Nov 21, 2008 1:35 pm
Subject: RE: [Brio Users] Show Remarks - Columns in Topic
stevecavill
Offline Offline
Send Email Send Email
 
This is part of the "metadata" definition.  Click on the metadata wizard option in the oce and check the help.
Steve


From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of srikrishnan chandrasekharan
Sent: Friday, 21 November 2008 1:51 AM
To: briousers@yahoogroups.com
Subject: [Brio Users] Show Remarks - Columns in Topic

Experts,

 

Good day to you

 

I have requirement wherein the remarks for the columns to be displayed when the user selects the item in the topic using the 'Show Remarks'

 

Please help in this regard

 

Thanks & regards

Srikrishnan Chandrasekaran



Add more friends to your messenger and enjoy! Invite them now.


#15722 From: srikrishnan chandrasekharan <srivijay81@...>
Date: Thu Nov 20, 2008 2:51 pm
Subject: [Brio Users] Show Remarks - Columns in Topic
srivijay81
Offline Offline
Send Email Send Email
 

Experts,

 

Good day to you

 

I have requirement wherein the remarks for the columns to be displayed when the user selects the item in the topic using the 'Show Remarks'

 

Please help in this regard

 

Thanks & regards

Srikrishnan Chandrasekaran



Add more friends to your messenger and enjoy! Invite them now.

#15721 From: "Steve Cavill" <steve.cavill@...>
Date: Fri Nov 7, 2008 1:12 am
Subject: RE: [Brio Users] API's --- BRIO BQY --- BRIO Metadata
stevecavill
Offline Offline
Send Email Send Email
 
Yes it's all in the document object model.
Which is all documented in the online help.
It's also in the PDF documentation.  The name of the PDF file varies by version, check your PDF's for "Object Model Reference"
Steve


From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of srikrishnan chandrasekharan
Sent: Thursday, 6 November 2008 4:57 PM
To: briousers@yahoogroups.com
Subject: [Brio Users] API's --- BRIO BQY --- BRIO Metadata

I am looking for help in finding out if any APIs are available for reading the BRIO BQY reports / BRIO metadata to dig out the following information.  We are having lot of brio reports and the idea to do a reports consolidation exercise and then see how the same information needs can be met in BO.

So we would like to know the following  essentially for each report.

1.       Tables referenced.

2.       Columns selected.

3.       Filters used.

4.       Entire query if possible.

Appreciate your help in this regard.

 

Thanks

Srikrishnan Chandrasekaran



Add more friends to your messenger and enjoy! Invite them now.


#15720 From: srikrishnan chandrasekharan <srivijay81@...>
Date: Thu Nov 6, 2008 5:57 am
Subject: API's --- BRIO BQY --- BRIO Metadata
srivijay81
Offline Offline
Send Email Send Email
 

I am looking for help in finding out if any APIs are available for reading the BRIO BQY reports / BRIO metadata to dig out the following information.  We are having lot of brio reports and the idea to do a reports consolidation exercise and then see how the same information needs can be met in BO.

 

So we would like to know the following  essentially for each report.

1.       Tables referenced.

2.       Columns selected.

3.       Filters used.

4.       Entire query if possible.

 

Appreciate your help in this regard.

 

Thanks

Srikrishnan Chandrasekaran



Add more friends to your messenger and enjoy! Invite them now.

#15719 From: "bernie.storrier" <bs.home@...>
Date: Wed Nov 5, 2008 5:37 am
Subject: export to access table via excel (JOOLE script) - size limit?
bernie.storrier
Offline Offline
Send Email Send Email
 
hi,

i am new to brio, and have solved some problems from this group - so
much thanks!

my problem now is that i have a query that i can export to an Access
table via Excel through JOOLE if the query returns anything up to
approximately 15,000 lines.  anything over this, it fails to paste
the results table into the Excel sheet, and consequently the transfer
spreadsheet command will fail as there is nothing in the sheet to
transfer.

i know this query works for up to 28,000 lines, as i have
successfully exported the results table to Access - however that was
before i had included the 'GetExcelPID' and 'KillExcelPID' scripts.

any suggestions????

script file :


// call vbs script to get PID of excel instance
//  the PID is stored in a file named SomeFileName.txt
//  saved in the D:\ drive home directory.
//
     if (gobjFSO.FileExists(gExportScripts+"\\GetExcelPID.vbs"))

Application.Shell "wscript",gExportScripts+"\\GetExcelPID.vbs");


//
//**************************************
//

          // Create a new instance of Access
           var oAccess=  new JOOLEObject("Access.Application");
           oAccess.Visible=true;

           var myTableName="";
           var myDbName="";
           var myExcelFileName="";
           var acImport = 0;
           var acSpreadsheetTypeExcel9=8;

           // Set table and database names

	 var fullpath_dir=ActiveDocument.Path;
	 var file_name=ActiveDocument.Name;
	 var directory_location;
	 var slash=Application.PathSeparator
	 var
dble_slash=Application.PathSeparator+Application.PathSeparator

	 directory_location = fullpath_dir.substr(0,
(fullpath_dir.length - (file_name.length + 1)))

	 var db_location=directory_location.substr(directory_location,
1, 2) + ":" + dble_slash

	 var build_string="";
	 for (var cntr=3; cntr<=directory_location.length-1; cntr
=cntr+1)
	 {
		 if (directory_location.charAt(cntr) != slash)
		 {
			 build_string=build_string +
directory_location.charAt(cntr);
		 }
		 else
		 {
			 db_location=db_location + build_string +
dble_slash;
			 build_string="";
		 }
	 }

	 db_location=db_location + build_string + dble_slash
+ "Bids.mdb";


             myTableName= "OPG";

           // add to existing database
           oAccess.OpenCurrentDatabase (db_location);      // to add
to existing database


           // Copy the Brio data into Excel
           oExcel = new JOOLEObject ("Excel.Application");
           oExcel.Visible=true;

           // Create a new Document
           var myExcelDoc = oExcel.Workbooks.Add;
           var mySheet=myExcelDoc.Worksheets.Add;
           ActiveDocument.Sections["Results - OPG R'ton"].Copy();
           mySheet.Cells.Item(1).Item(1).Select;
           mySheet.Paste;
           myExcelDoc.Save;
           myExcelFileName=myExcelDoc.FullName;



           // delete contents of existing table and copy excel
workbook over table.
           //
           // ***** NOTE Function Args in Reverse Order to Microsoft
Documentation
           // Import the data into Access
           oAccess.DoCmd.RunSQL("Delete * FROM OPG;");
           oAccess.DoCmd.TransferSpreadsheet(-1, myExcelFileName,
myTableName, acSpreadsheetTypeExcel9, acImport);

           //Close Excel Workbook
           // use application.quit to close the excel window.
          //oExcel.Workbooks.Close;
          oExcel.Application.Quit();
          oAccess.Application.Quit();

//***************************************************************


     //Finally, KILL that Excel Process!!!!
     if (gobjFSO.FileExists(gExportScripts+"\\KillExcelPID.vbs"))
         Application.Shell
("wscript",gExportScripts+"\\KillExcelPID.vbs");

Alert("Transfer of Vizirail bid data to Bids database now complete.");

#15716 From: ssekhar@...
Date: Fri Oct 17, 2008 6:43 pm
Subject: Re: [Brio Users] Too bad this group is getting spammed
clearmedia01
Offline Offline
Send Email Send Email
 
Thanks Andre!
 
ss
 
-------------- Original message --------------
From: andre_duijn <no_reply@yahoogroups.com>

Sorry folks, author has been banned now.
I can only do so much. Still have no authority to 'add' moderators,
otherwise i would have asked for help.

--- In briousers@yahoogroups.com, Don L <inventordon@...> wrote:
>
> I second that motion. Get rid of the spammer priya_s or whoever it
is!
>
> --- On Wed, 10/15/08, clearmedia01 <ssekhar@...> wrote:
>
> From: clearmedia01 <ssekhar@...>
> Subject: [Brio Users] Too bad this group is getting spammed
> To: briousers@yahoogroups.com
> Date: Wednesday, October 15, 2008, 8:18 PM
>
>
>
>
>
>
> How can we get rid of the spammer priya_s?
>
> This person is posting two stupid messages a day with pictures that
> are a waste of time.
>
> ss
>


#15715 From: jmalbitz <jmalbitz@...>
Date: Fri Oct 17, 2008 1:40 pm
Subject: Re:Too bad this group is getting spammed
jmalbitz
Offline Offline
Send Email Send Email
 
I third this notion.  It's bad enough that there's not much support out there for those of us working with this toolset, but then for someone to be blowing up one of the few places we can get help and/or help others is just despicable.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

#15714 From: andre_duijn
Date: Fri Oct 17, 2008 2:59 am
Subject: Re: [Brio Users] Too bad this group is getting spammed
andre_duijn
Offline Offline
 
Sorry folks, author has been banned now.
I can only do so much. Still have no authority to 'add' moderators,
otherwise i would have asked for help.

--- In briousers@yahoogroups.com, Don L <inventordon@...> wrote:
>
> I second that motion.  Get rid of the spammer priya_s or whoever it
is!
>
> --- On Wed, 10/15/08, clearmedia01 <ssekhar@...> wrote:
>
> From: clearmedia01 <ssekhar@...>
> Subject: [Brio Users] Too bad this group is getting spammed
> To: briousers@yahoogroups.com
> Date: Wednesday, October 15, 2008, 8:18 PM
>
>
>
>
>
>
> How can we get rid of the spammer priya_s?
>
> This person is posting two stupid messages a day with pictures that
> are a waste of time.
>
> ss
>

#15711 From: dmacdona
Date: Thu Oct 16, 2008 9:37 am
Subject: FREE OBIEE Training in UK
dmacdona
Offline Offline
 
This may be of interest to anyone still using Brio or even System 9
BI+ who is considering their future options. Oracle have stated that
their strategic BI platform is OBIEE. We will be running some very
tightly packed one day OBIEE courses. These are free for you to attend
or there may be a nominal charge to cover room hire and refreshments.
You will need to be a BI specialist with a good understanding of the
principles of Business Intelligence. You can be employed in BI, a
contractor in BI or even unemployed and with BI skills. When we have
enough interest we will set the dates.

To register for more information email your contact details to info@
rosetta-stone.co.uk

#15708 From: Don L <inventordon@...>
Date: Thu Oct 16, 2008 3:35 am
Subject: Re: [Brio Users] Too bad this group is getting spammed
inventordon
Offline Offline
Send Email Send Email
 
I second that motion.  Get rid of the spammer priya_s or whoever it is!

--- On Wed, 10/15/08, clearmedia01 <ssekhar@...> wrote:
From: clearmedia01 <ssekhar@...>
Subject: [Brio Users] Too bad this group is getting spammed
To: briousers@yahoogroups.com
Date: Wednesday, October 15, 2008, 8:18 PM

How can we get rid of the spammer priya_s?

This person is posting two stupid messages a day with pictures that
are a waste of time.

ss



#15707 From: "clearmedia01" <ssekhar@...>
Date: Thu Oct 16, 2008 3:18 am
Subject: Too bad this group is getting spammed
clearmedia01
Offline Offline
Send Email Send Email
 
How can we get rid of the spammer priya_s?

This person is posting two stupid messages a day with pictures that
are a waste of time.

ss

#15700 From: "Steve Cavill" <steve.cavill@...>
Date: Tue Sep 30, 2008 2:51 am
Subject: RE: [Brio Users] Re: Please Help!!! Brio insight plugin not working in Windows Vista
stevecavill
Offline Offline
Send Email Send Email
 
Which version of plugin?  Older versions don't support IE7
Steve.


From: briousers@yahoogroups.com [mailto:briousers@yahoogroups.com] On Behalf Of khaine_sg
Sent: Tuesday, 30 September 2008 12:26 PM
To: briousers@yahoogroups.com
Subject: [Brio Users] Re: Please Help!!! Brio insight plugin not working in Windows Vista

--- In briousers@yahoogroups.com, "jmalbitz" <jmalbitz@...> wrote:
>
> --- In briousers@yahoogroups.com, "jmalbitz" <jmalbitz@> wrote:
> >
> > Anyone else experience this or have any ideas?
> >
> > Any help is greatly appreciated!
> >
> > --thanks
> >
> in case anyone is wondering, it was a problem with ie7, not Vista. if
> you need help with this problem, just message me.
>

Please let us know what was the resolution for this. I've got a user
with this problem as well. The plugin just doesn't work with IE7 after
a while even though it was working fine before. Thus I suspect one of
the MS updates might be causing the problem.


Messages 15700 - 15825 of 15825   Newest  |  < Newer  |  Older >  |  Oldest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help