The End of the Time Scale Debate

By Brady Marr Senior Director, TM1 Practice eCapital Advisors For as long as I have been working in cube-based (OLAP) software, there has been a long running debate about whether to build your cube with a single continuous time dimension, or rather to separate into a Month dimension and a Year dimension. To describe the…

Read More

MDX Series Pt 6: Refreshable MDX Using Cell Comments and a Macro

Making MDX Refreshable By default, Smart View does not offer any options for making MDX queries refreshable. It would be a great addition if Oracle did something like storing the query in the metadata for the worksheet, and then when you go to the Essbase ribbon > Query > Execute Query, the query would be…

Read More

MDX Series Pt 5: Smart View Does More Than You Think

MDX Series This is post number five in a six-post series. A brief overview of the series: Post #1: Connect to Sample.Basic and execute two basic queries Post #2: Introduce functions using a single dimension Post #3: Introduce multiple dimensions and CrossJoin Post #4: Define sets and tuples to add a deeper understanding of how…

Read More

MDX Series Pt 4: A Tale of Two Tuples

MDX Series This is post number four in a six post series. A brief overview of the series: Post #1: Connect to Sample.Basic and execute two basic queries Post #2: Introduce functions using a single dimension Post #3: Introduce multiple dimensions and CrossJoin Post #4: Define sets and tuples to add a deeper understanding of…

Read More

MDX Series Pt 3: The Second Dimension is the Hardest

MDX Series This is post number three in a six post series. A brief overview of the series: Post #1: Connect to Sample.Basic and execute two basic queries Post #2: Introduce functions using a single dimension Post #3: Introduce multiple dimensions and CrossJoin Post #4: Define sets and tuples to add a deeper understanding of…

Read More