Can I read How To Use MDX Dimension Formulas - v1 on EtoBox?

How To Use MDX Dimension Formulas - v1 by Anirban DevBurman is a document available to read on EtoBox.

What is How To Use MDX Dimension Formulas - v1 about?

This document provides guidance for writing dimensional formulas in SAP BPC 5.x when using multiple hierarchies in a dimension. It discusses how formulas must be written differently in SQL 2000 and SQL 2005 to account for how Analysis Services recognizes and evaluates dimensions and hierarchies. The key points are that in SQL 2000, formulas must use IIF statements and fully qualify all members, while in SQL 2005 qualification is not required but performance can significantly degrade. It is generally recomme

Author

Anirban DevBurman

Language

EN