IBM Planning Analytics TurboIntegrator Debugger Tool is Now Available

Anyone that has ever worked in TM1, specifically a TurboIntegrator¬†(TI)¬†process, knows that trying to diagnose issues with a data loading process can be problematic. It is hard to know if the issue lies in the underlying data, or if there is something is wrong with the coding in the TI process. Many of us developers…

Read More

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