Hyperion

[Adam G.]

Hi All,

It's no secret that I love Hyperion 

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

[tony]

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

[CTIgem]

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.

[tony]

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

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

- et voila...! ?



TT

[CTIgem]

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