Hi Jerry,

I want to calculate the calculation in the cube > SSAS. As a reporting tool, we use SSRS but excel, for power users, as well.

The goal is that the end-user (via an interface of course) can create their own calculations without interference of IT, so the calculation definition should be stored in the database
and be calculated in the cube.

We have 3 dimensions "Table";"Line";"Column" that are related to the fact via m-n relations.

What we want to achieve is a new calculation for example:

Cell (Table: T_Custom A; Line: L_Custom 1; Column: C_x)

= (Table D; Line **1**; Column a) + (Table D; Line
**2**; Column a)

We want to avoid calculating these new formulas in the ETL, as doing the calculation for millions of records, and as the base-values already exist, it isn't very pragmatic.

Thanks in advance,

Bram