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

MDX Series Pt 2: A Function is Worth a Thousand Members

MDX Series This is post number two 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