RE: [sqr-users] Create-Array size?

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

In some situations, I can use a load-lookup to map a database field to
rownum, and then use rownum as the index of the array.  This approach uses
the binary search of the lookup command.


-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Knapp, Richard
Sent: Tuesday, April 29, 2008 9:10 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Create-Array size?


Marcel,

It is only necessary to process enough of the array to find the value you
are looking for.  Then you can 'break' out of the loop that was generating
the index.  There is also some overhead in generating the hash value which
"feels" like it should be less than the loop method.  I say this is a worthy
experiment.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street  #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of Hug
Marcel (KSFH 344)
Sent: Tuesday, April 29, 2008 9:48 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Create-Array size?

Hi,

thx. And what is the FASTEST way to search for a value in an ARRAY? Do we
always have
to loop trough all array indexes, in order to find a certain value? Or is
this possible:

let #index = autonumberhash128($the_value)
let array(#index) = $the_value

where autonumberhash128 returns an automatic unique number, based
on a hash built upon $the_value (e.g. $the_value = 'prqpe' would return
#index = 1)

Thx - Marcel


Marcel Hug
Credit Suisse
Information Technology
Solution Engineering, KSFH 344
Oracle | Hyperion Lead Ing. FN Reports
Zollstrasse 20/36
CH-8005 Zürich
Tel: +41 1 334 74 20
mailto:marcel.hug@credit-suisse.com
http://www.credit-suisse.com

-----Original Message-----
From: sqr-users-bounces+marcel.hug=credit-suisse.com@sqrug.org
[mailto:sqr-users-bounces+marcel.hug=credit-suisse.com@sqrug.org] On Behalf
Of Peter Burton
Sent: Tuesday, April 29, 2008 4:38 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Create-Array size?

Justin,

Starting with Hyperion SQR 8.0 the CREATE-ARRAY command can automatically
extend the array when the EXTENT= qualifier is specified (# of rows per
extent).

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of
Ott, Justin
Sent: Tuesday, April 29, 2008 10:03 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Create-Array size?

Hello,

 

I was wondering if when you create and array, do you have to give a
static size or is there a way to make it dynamically grow with the data?

 

thanks

 

---------------------------------------

Justin Ott

Systems Analyst/Programmer Intermediate 

Drummond Company, Inc. 

1000 Urban Center  Drive, Suite 300  

Vestavia Hills, AL  35242  

Phone: 205.945.6437  

Fax:  205.944.7516
 
 
 
 
 
Confidentiality Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain material that
is confidential, privileged and/or attorney work product.  Any unauthorized
review; usage, reliance, disclosure or distribution by others or forwarding
without express permission is strictly prohibited.  If you are not the
intended recipient, please contact the sender by reply e-mail and delete and
destroy all copies of the original message.  Thank You.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users