Data Mesh
Love this approach to data architecture
https://martinfowler.com/articles/data-monolith-to-mesh.html
Love this approach to data architecture
https://martinfowler.com/articles/data-monolith-to-mesh.html
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.
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.
https://thenewstack.io/why-and-how-you-should-manage-json-with-sql
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
https://cloudcustomerconnect.oracle.com/resources/6c34f3f3a5/summary
Slightly tricky to discover, but monitored by the dev team.
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)
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...
http://glennschwartzbergs-essbase-blog.blogspot.com/2020/09/creating-text-list-in-19c.html
I think this will make text measure more usable
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…