Olivier Brockbank

Essbase, EPM, etc
Principal Consultant @ Qubix
https://qubix.com
https://www.linkedin.com/in/olivierbrockbank

Read this first

Data Mesh

Love this approach to data architecture
https://martinfowler.com/articles/data-monolith-to-mesh.html

View →


Take a break

https://www.bbc.co.uk/sounds/play/m0018p32
Short podcast on the benefits of taking short breaks from work.
Fewer mistakes and better eye health.

View →


Ragged hierarchies in DV

https://community.oracle.com/customerconnect/discussion/513307
Recent update to OAC supports ragged hierarchies. Havn’t tested this, but it should significantly improve the reporting experience on Essbase cubes.

View →


Json in Oracle SQL

https://thenewstack.io/why-and-how-you-should-manage-json-with-sql

View →


Planning tips

Enjoyed this series of blogs:
https://blogs.oracle.com/proactivesupportepm/application-design-for-epm-planning-part-1-app-deployment-dimensions-and-forms
https://blogs.oracle.com/proactivesupportepm/application-design-for-epm-planning-part-ii%3a-calculation-manager-rules-and-hybrid-bso
https://blogs.oracle.com/proactivesupportepm/application-design-for-epm-planning-part-iii%3a-data-maps-and-smart-push

View →


Essbase forum

https://cloudcustomerconnect.oracle.com/resources/6c34f3f3a5/summary
Slightly tricky to discover, but monitored by the dev team.

View →


MDX Exclude dynamic members

For the next time I try to remember how to exclude dynamic members from a MDX specification:
Filter(Descendants([Product], Product.Levels(0)), [Product].CurrentMember.Member_Type <> 2 AND NOT Product.CurrentMember.Shared_Flag)

View →


Essbase dimension consolidation codes

For the next time I forget them and spend an age looking:

ASO:
C
Set member as top of a stored hierarchy (applies to dimension member or generation 2 member)

D
Set member as top of a dynamic hierarchy (applies to dimension member or generation 2 member)

H
Set dimension member as multiple hierarchies enabled (applies to dimension member only)

K
Reset the time balance property to NONE (applies to accounts dimensions only).

N
Never allow data sharing

O
Tag as label only

P
Reset the time balance skip option to NONE (applies to accounts dimensions only).

BSO:
A
Treat as an time balance average item (applies to accounts dimensions only)

B
Exclude data values of zero or MISSING in the time balance (applies to accounts dimensions only)

E
Treat as an expense item (applies to accounts dimensions only)

F
Treat as a time balance first item (applies to accounts dimensions only)

G
Reset...

Continue reading →


Loading Essbase text measures via a rule

http://glennschwartzbergs-essbase-blog.blogspot.com/2020/09/creating-text-list-in-19c.html
I think this will make text measure more usable

View →


Index usage

https://www.red-gate.com/simple-talk/blogs/index-usage-finding-indexes-not-being-used/
An excellent guide on deciding if all those indexes are really needed…

View →