Skip to content

The Truth About CPM

A treatise on solving problems, getting answers, and hacking Corporate and Enterprise Performance Management

  • Home
  • About

Category: Metadata

A n00b’s OneStream Journey No. 2.1 — Building dimensions manually

A geek’s reach should exceed his grasp, Or what’s a blog post for?

With extensive apologies to Rabbie Burns aka the Bard of Ayrshire aka the Ploughman Poet (I hope that every lit prof I had in school is now beyond happy that I can remember a line from Andrea del Sarto – see, I did pay attention, sometimes) I had high hopes that I could cover the entire OneStream dimension build process from thinking about it to building and editing it manually to loading and editing it from external sources. Whew. And that’s not even counting applying said dimension to a cube. Double whew.

It’s simply too much to cover in a single blog post so I’ll disappoint you bitterly relieve you and me considerably by reducing scope as splitting this into multiple posts is the only way to reasonably approach the subject.

Along the way I’ll try to explain as much of the architecture and philosophy behind OSXF’s (I’m too lazy to write out OneStream XF more than once per post) metadata management but there will be much that I shan’t and can’t cover yet. There’s a lot going on and a lot of functionality that isn’t …

cameronl Metadata 2 Comments 6 November, 20176 November, 2017 7 Minutes

Posts navigation

Newer posts

RSS The bright shiny new episode of EPM Conversations

  • EPM Conversations Episode 29 – A Conversation With Tim Tow, The Coolest Guy in EPM, Part 1 10 April, 2025 Cameron Lackpour
  • EPM Conversations Episode 28 — A Conversation With The Recruiters 3: Freya Bull, Patrick Cronan, and Austin Perez, Understanding How Recruiters Work, Who They Are, And Why We Should All Care 10 January, 2025 Cameron Lackpour
  • EPM Conversations Episode 27 — A Conversation With Matt Bradley, Oracle Senior Vice President, Development 6 November, 2024 Tim German
  • EPM Conversations Episode 26 – A Conversation With Gabby Rubin, Group Vice President, Product Management, Oracle Analytics, Part 2 28 September, 2024 Cameron Lackpour
  • EPM Conversations Episode 25 – A Conversation With Gabby Rubin, Group Vice President, Product Management, Oracle Analytics, Part 1 29 August, 2024 Cameron Lackpour
  • EPM Conversations Episode 24 — A Portrait in Leadership: Women in EPM with Sharon Wang 23 July, 2024 Cameron Lackpour
  • EPM Conversations Episode 23 — A Portrait in Leadership: Women in EPM with Oracle Barbie aka Kate Helmer 27 June, 2024 Cameron Lackpour
  • EPM Conversations Episode 22 – A Conversation With Shankar Viswanathan, The Man Who Owns The Product That Bought Me My House 15 April, 2024 Cameron Lackpour
  • A Portrait in Leadership: Women in EPM with Minie Parikh 24 February, 2024 Cameron Lackpour
  • EPM Conversations Episode 20 – A Culture Clash Conversation,  The African 8 November, 2023 Cameron Lackpour

About This Site

I’m going to cover C/EPM in all of its glory.  And pain.  And fun.  I hope.  Join me, won’t you?

Search

Latest posts

  • EPM Conversations Episode 16 — A Culture Clash Conversation or 50 Million Frenchmen Can’t be Wrong with Ludovic De Paz and Pascal De Schryver 10 February, 2023
  • EPM Conversations — Episode 14, A Conversation with Sree Menon, The Calc Man 7 June, 2022
  • EPM Conversations — Episode 13, A Conversation with Elizabeth Ferrell, Accountant (ex), Advocate (of so many things), and Aviatrix 19 April, 2022
  • EPM Conversations — Episode 12, A Conversation With Kumar Ramaiyer, Workday Adaptive Planning Business Unit Vice President 14 December, 2021
  • EPM Conversations — Episode 11, A Conversation With Peter Fugere, OneStream Software’s Chief Strategic Services Officer 2 November, 2021

Blog Archive

  • February 2023 (1)
  • June 2022 (1)
  • April 2022 (1)
  • December 2021 (1)
  • November 2021 (1)
  • September 2021 (1)
  • May 2021 (1)
  • April 2021 (1)
  • March 2021 (1)
  • February 2021 (1)
  • January 2021 (1)
  • December 2020 (1)
  • November 2020 (1)
  • October 2020 (2)
  • September 2020 (1)
  • August 2020 (1)
  • May 2020 (3)
  • April 2020 (1)
  • March 2020 (2)
  • February 2020 (2)
  • January 2020 (2)
  • December 2019 (2)
  • November 2019 (1)
  • October 2019 (3)
  • September 2019 (4)
  • July 2019 (3)
  • June 2019 (6)
  • September 2018 (1)
  • June 2018 (1)
  • April 2018 (1)
  • December 2017 (1)
  • November 2017 (4)
  • October 2017 (2)

Tags

AppliedOLAP (2) AVBS (1) Changes (5) Cloud (5) CPM (9) Data (5) Dimensions (12) Dodeca (1) EPM (22) EPM Conversations (6) Essbase (18) Excel (2) Groovy (1) Infrastructure (4) Kscope (7) Marketplace (2) Metadata (10) n00b (3) OAC (3) OneStream (9) Oracle (1) Planning (18) Security (1) Stupid Tricks (1) Upgrade (3)

Categories

Other Sites You Should Read

  • EPM Lab – Smart View for Google Workspace – Part 2 The EPM Lab, 22 January, 2025 Jun
  • EPM Lab – Smart View for Google Workspace The EPM Lab, 1 July, 2024 Jun
  • EPM Lab – Form 2.0 The EPM Lab, 29 January, 2024 Jun
  • EPM Lab – 2023 New Features Review The EPM Lab, 2 January, 2024 Jun
  • ODI in the hybrid database world – Amazon Redshift – AWS CLI DEV EPM, 5 June, 2023 Rodrigo Radtke de Souza
  • ODI in the hybrid database world – Azure SQL Database – BCP Utility DEV EPM, 8 May, 2023 Rodrigo Radtke de Souza
  • ODI in the hybrid database world – Oracle ADW – OCI/CLI + DBMS_CLOUD DEV EPM, 14 April, 2023 Rodrigo Radtke de Souza
  • Snowflake loader using ODI DEV EPM, 13 April, 2023 Rodrigo Radtke de Souza
  • How the Essbase CLI Login Works Cube Coder, 9 March, 2023 TimG
  • Quick tip - Finding out your EPM Cloud Infrastructure Datacentre EPM Simplified, 8 December, 2022 Omar Shubeilat
  • EPCM - A workaround for deleting scheduled jobs EPM Simplified, 9 September, 2022 Omar Shubeilat
  • EPCM BUG - Error deleting scheduled jobs EPM Simplified, 3 September, 2022 Omar Shubeilat
  • Quick tip - Groovy rule validates successfully but fails to run EPM Simplified, 3 August, 2022 Omar Shubeilat
  • A New Platform – EPM Conversations Cube Coder, 29 September, 2020 TimG
  • Enterprise Data Management (EDM) REST API Requests II The Unlocked Cube, 19 July, 2020 Vijay Kurian
Proudly powered by WordPress | Theme: Independent Publisher 2 by Raam Dev.