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
>

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

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

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!

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.
>

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
>

--- 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.

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

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.
>

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.

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

Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT

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.");

-------------- 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
>

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
>

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

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

--- 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.