Tag Archives: oracle

Essbase book

Read Edward Roske and Tracy McMullen’s “Look Smarter than you are with Essbase System 9″ over the weekend. It’s really the best “technical” book I’ve read over past couple of years. Written in simple and not annoying language, with a lot of humor (I couldn’t hold myself when I’ve read the fight club joke) — [...]

Using Oracle Model clause in real-life )

I’ve been a long-term fan of oracle model by clause, talking about here and there, doing some small&funny examples (like eight queens solution in one select) but lacked some real-life necessity to use it. It always turned out that partition by was enough, or some tricky analytical function was already built-in (like trend calculations I [...]

Future Oracle BI Architecture by Rittman

Just in case you missed that — awesome course about on how to cook Oracle BI projects is freely available!!!

Calculating trend lines in Cognos Report Studio and Oracle SQL

I’m more than just emotional right now since I’ve finally got that bugger of my neck.
To those who’re interested in getting trend calculated in oracle — press page-down once.
Trend line calculation in Cognos.
It’s 2008 as my desktop calendar says and it’s “Targeted information to a broader range of users ” on top of the Cognos [...]

Some link dumping

Essbase is finally supported in Oracle BI. Hooray. From here.
Cognos 8.2 BI sp1 out, gotta give it a try.

Oracle Data Integrator + Jython : How to drop all indexes on table

I’m currently building a warehouse using ODI, so I’ll share some findings as it goes. And there’s be Cognos BI on top of it and EP is one of the sources, so I’m still close to the roots )
Disclaimer: I’m Oracle & ODI n00b — there are (?) better ways of accomplishing these tasks and [...]

New Oracle&Hyperion blog

Nice overview and details. I’d only seen cubegeek posting Hyperion-related stuff.

Hyperion on edelivery

Well, I’m last to notice — they’ve brought all hyperion apps on edelivery.oracle.com
Started unwrapping this mid-summer present today. It took me quite a time to get to Hyperion Planning LogOn screen, I must admit. This is no Analyst out-of-box experience, this is serious software with lots of ports&services stuff ) And AIX 64 capable ))
See [...]

Rittman on Oracle+Hyperion

Definitely worth reading.
I’m just confused with EPB future. And if EPB will be changed by Hyperion products, all EPF concepts falls. Future of products will remain unclear until Oracle explains their plans in detail.
But the main goal Oracle’s is obvious. Got the illustration from Tom Kyte’s blog.

Oracle To Buy Hyperion

Oh my God.
CNN article
Anyway, that’ll give me access to Essbase and I wanted that.

FireStats icon Powered by FireStats