Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Presentation Hierarchies 11g

No description
by

Jeremy Harms

on 24 June 2014

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Presentation Hierarchies 11g

0. Who am I?
(And what am I doing here!?)
Jeremy Harms
* Director of Business Intelligence
EmeraldCube Solutions
Atlanta, GA
* Oracle Fusion Middleware 11g BI Foundation
Certified Implementation Specialist
* Beards. Motorcycles. Roll Tide.
* OBIEE consultant for six years
1. Objectives
2. Overview
4. Performance?
5. Modeling…
6. Drill
8. Thanks!
3. Pitfalls!
The "KEY" is... For all child level columns, append all prior parent columns
*MUST*
make the child key value unique across all parents
Beware
reused child codes/values in multiple parents!
t
h
r
u
What Your Parents Didn't Tell You…
About OBIEE 11g Presentation Hierarchies!
Jeremy Harms
Director of BI
EmeraldCube Solutions

Business Intelligence for JDE
* Cloud-based SaaS and on-prem BI offerings:
EmeraldVision & Oracle (OBIEE)
* Subscription and traditional software acquisition models
EmeraldCube Focus
* Business Intelligence

* JD Edwards Managed Services/CNC
Managed Services for JDE
* On demand and managed services plans
* EmeraldPrism: Unmatched proactive, monitoring, alerting
* JDE technical upgrades, functional improvement,
process re-engineering, CNC
Introduced in OBIEE 11g
Intuitive behavior for users
...but with some not-so-obvious quirks!
A must-have for Essbase cube analysis
This session will focus on their usage
on relational DB
Avoid numeric data type columns as the hierarchy level display!
Don't rename presentation tables or hierarchies!
Conditional format
+ Presentation Hierarchy
+ "Excluded" cols
= ERROR
Jeremy Harms
Director of BI
EmeraldCube Solutions
@jeremyharms
jharms@emerald-cube.com
www.emerald-cube.com/blog
If you want
fast
,
then you want
Essbase
.
Otherwise...
* UNION statements for each level!

Choosing a few or less? Well done!
Wait, you're seriously using five or more!?
Uh, well then...
vs.
"You have chosen... wiiiisely."
"He chose... poooorly."
Avoid
numeric
data type columns as the hierarchy level display
7. Review
[start]
[end]
or
t
h
r
u
(And an oddity...)
"Parent values after children"
Weeee!
* For each hierarchy column, this is compounded!
* Therefore, be careful how many you throw into a query...
* Look at the performance costs and review SQL
* Pre-built BI data warehouse specifically for JDE
* OBIEE managed service and support offerings
(meaning, Cartesian product!!)
Full transcript