Hyperion

General Discussion
1

Hi All,

It’s no secret that I love Hyperion ;D ;D

I’ll soon be starting to play with Oracle Business Intelligence 11 - as this is what I believe is the latest name\version. I’m looking forward to it! Has anyone else looked at it? Any thoughts\tips etc?

W yn

2

I have some thoughts… but they are based on the fact that you just said you love Hyperion… lol :wink:

3

Hi,
Sounds like you are the best person to ask about Brio.
I’m having a trouble displaying 17 digit number (hex-connid-id converted to decimal) in brio result.
Brio chops it off around 14 digits or so…don’t remember exactly.
Is there a setting that increases max number of display?
I used number format of ################ (17) but without any luck…

Thanks.

1 Like
4

Try this: but you need to be in your Query Results section:

Navigate to the Right of your Result columns - beyond the last column, then right-click and select "Add computed item"
Give your new Column a Name
Click in the Definition, then click on the Reference button, on the right.
Select your converted HEX “integer” Field and it will be inserted in the Definition Field.
Click on the Options button, on the right and a subsequent Option drop-down list appears, below the Definition Field, called Datatype - select String, then click OK

  • et voila…! ?

:slight_smile:

TT

5

Thanks!!!
Yep, I have to use string type not number…

4 Likes