If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Creating a hash value

Started by take_yer_points, 09 Jul 2018 08:16:48 AM

Previous topic - Next topic

take_yer_points

Cognos 10.2.2

I'm looking for a report studio function similar to Oracle's ORA_HASH.

Is there a function in report studio that will allow me to create a hash value?

BigChris

What's a hash value? (Anyone that gives me an answer in £s per ounce will be made to stand in the naughty corner!)

Lynn

Quote from: BigChris on 09 Jul 2018 09:30:29 AM
What's a hash value? (Anyone that gives me an answer in £s per ounce will be made to stand in the naughty corner!)


;D ;D ;D ;D ;D ;D ;D ;D ;D

CognosPaul

A hash is, usually, a numeric value that encodes a string based on a seed value. The expression and seed should always resolve to the same value.

In this case I'd try to use the ORA_HASH from Oracle. What happens when you try to use it? Cognos will occasionally permit the use of native database function, so long as you are calling that particular database. If you're not on Oracle, what database is it?

sdf